After the cluster was last installed, I didn't have time to write a test article (see). Today I wrote an article on the preliminary test, if you still want to know how to handle the ipvs cluster in different situations, you can leave a message to me
1. Shut down the databaseSQL> shutdown immediate;2. Move data files and log files to a new locationSQL> host mv/u01/olddata. dbf/u02/newdata. dbf;SQL> host mv/u01/oldredo. log/u02/newredo. log;3. Start the database in load modeSQL> startup mount;4.
I have previously written a basic article about scn, but it does not reflect the changes and existence of scn. Here I want to say that many situations of scn may change, rather than submitting or
The scn exists in multiple places. Such as log files,
BackupBackup is used as a means of redundancy to prevent errors or downtime.I. Oracle backup can be divided into two types: physical backup and logical backup.1. Physical backup: copy, copy files such as datafile and control file to other
System Version: CentOS 5.5x64
Database Version: Oracle 11G R2 11.2.0
The following error is reported:
[oracle@server253 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 1 17:38:49 2012
SQLPLUS> alter database datafile 2 ONLINE;Alter database datafile 2 ONLINE*ERROR is located in row 1st:ORA-01190: control file or data file 2 comes before the last RESETLOGSORA-01110: data file 2: 'e: \ Oracle9I \ ORA9I \ undotbs01.dbf'Next, because
After the Select statement, create index, and other sorting operations using the TEMP tablespace are completed, Oracle Automatically releases the temporary segment. However, if some temporary segments are not released, the TEMP tablespace is almost
Rman backup appears ORA-19625:
The reason is that the archive log is deleted in the operating system and has not been backed up yet. When rman backs up the log, the archive fails to be found. You can solve this problem by using the following
Oracle backup:
Backup is redundancy. In essence, it refers to copying a few copies of the current data to other places, so that when the original data file is damaged due to various reasons, we can use the backup file to restore the status of the
Connection query is a frequently used query method in database query statements. The following describes how to query connections based on the official documents provided by Oracle:
1. Connection Type:
1) Unique oracle connection types:
A.Equijoin
We have previously introduced the virtual columns and read-only tables in the new Oracle 11g feature. Today we will introduce another new feature, the combined trigger.
In earlier versions of Oracle, you can use the FOLLOWS keyword to control the
[Grid @ vm11gr2]/home/grid>Sqlplus "/as sysasm"SQL * Plus: Release 11.2.0.1.0 Production on Sun Oct 25 10:16:21 2009Copyright (c) 1982,200 9, Oracle. All rights reserved.Connected to an idle instance.SQL>StartupORA-01078: failure in processing
In a query statement using a view or nested view, Oracle merges these views to obtain the optimal execution plan and connects the tables in the view to the tables in the external query.
-- Example:
SQL>SelectE. first_name, e. last_name, dept_locs_
1. First download the source file of the Berkeley db database from the Oracle official website.
Http://download.oracle.com/otn/berkeley-db/db-5.3.15.tar.gz
2. The downloaded file is a packaged file and needs to be decompressed using tar in the
1. application scenarios:Environment:Host Name ip vip sid DiskGroupDb1 1.1.1.1 1.1.1.11 bkjia DATA1Db2 1.1.1.2 1.1.1.12 bkjiadb DATA2 Expected results:Db1 and db2 can be backed up to each other. Here db1 is used as the master database, and db2 is
Due to the lock mechanism, when execution of a DML or ddl SQL statement is blocked, you need to find out why the SQL statement is blocked. The following describes the common diagnostic methods:
Suppose there is a table: table t (id int primary key,
This week, two sets of EMC storage are migrated, and several intranet database servers are attached to the storage space. You need to migrate the stored database to the server. The specific migration steps are as follows:
I. Environment:
1. original
First, cmd-sqlplusw
Common User Logon: User name: scott (Common User Name) password: tiger (common user password)
Administrator Logon: User name: system password: system (administrator password)
Note the following when a super Administrator logs on:
RMAN is a required management tool for Oracle Database Backup management. There are many ways to operate it. I sorted out some common operation commands and summarized them to facilitate work.
1. database backup operation commands
Simplified Version
This test shows how to access a table containing Blob fields through DBLink.
I. Simulated Problems
1.1In the instance1Operation on:
Create a test table containing blob:
/* FormattedOn10:18:05 (QP5 v5.185.11230.41888 )*/
CREATE TABLELob1
(
Line
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.