oracle data guard synchronous replication

The Oracle Data guard logical standby database uses a backup of the master database to first create a physical standby database and then convert it to a logical standby database. After that, the master database transmits the logs to the slave database. The slave database uses logminer to parse the SQL statements executed by the master database from the logs of th

RAC, Data Gurad, Stream are three tools in the Oracle High-availability system, each of which can be used independently or in conjunction with each other. Their respective emphasis is different, the application scenario is also different. RAC its strength lies in solving single point of failure and load balancing, so the RAC scheme is often used in the core system of 7*24, but the

;--------------------------------------------------------------------------View the protected mode of the database: select Database_ Role,protection_mode,protection_level from V$database; maximum protection: write in the master library while ensuring that it is also written in the standby (MAXIMUM PROTECTION) Maximum availability: Provides maximum protection data without affecting the main library (MAXIMUM availability) maximum performance: not

. 3. Insert tablespace Invoke the Data Pump utility to plug the set of tablespaces into the primary database. Redo data will be generated and applied at the standby site to plug the tablespace into the standby database. Call the Data Pump to insert the tablespace to the master database. Then, the slave database will obtain the redo

Oracle Data Guard role conversion experiment environment: OEL + Oracle11.2.0.3 + physical standby as we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to the strong adaptability of log transmission to the network, in addi

RAC, Data Gurad, Stream are three tools in the Oracle High-availability system, each of which can be used independently or in conjunction with each other. Their respective emphasis is different, the application scenario is also different. RAC its strength lies in solving single point of failure and load balancing, so the RAC scheme is often used in the core system of 7*24, but the

EnvironmentOn servers 192.168.1.89 and 90, the operating system is linux Red Hat as 5.2, Oracle 10.2.0.4 is installed, and a single instance database webdb is created respectively.Configure the Data Guard environment with the webdb Of the 89 database as the master database and the slave database of the 90 database as the backup database. Procedure for creating

Oracle Data Guard (2) Physical Standby 1. check whether the Primary database is archivelog mode SQL> select log_mode from v $ database; if the result is not "ARCHIVELOG", run the following command: SQL> shutdown immediate; SQL> startup mount; SQL> alter database archivelog; SQL> alter database open; 2. check whether the Primary database is in force logging mode S

Oracle 11gR2 Database and Active Data Guard migration case, 11gr2guard The customer's core system is composed of an Oracle Database 11.2.0.3.4 single machine and an Active Data Guard, which run on two PC servers respectively. The

DataFile (s) in backup setincluding standby control file in backup setChannel ora_disk_1:starting piece 1 at 2016-11-23 21:20:42Channel ora_disk_1:finished piece 1 at 2016-11-23 21:20:43Piece Handle=/home/oracle/ctlfile.bak tag=tag20161123t212041 comment=noneChannel Ora_disk_1:backup set complete, elapsed time:00:00:01Finished backup at 2016-11-23 21:20:43Rman> Then, when the backup task is finished, on the main library, the control fil

Apply before you can change the log files. 1. If the redo application is running, you must cancel the redo application after you change the log file. 2. If the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO, change the value to MANUAL. If the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO, change it to MANUAL. 3. Add or drop an online redo log file: 3. add or delete online redo log files: Bytes To add an online redo log file, use a SQL statement such as this: A

parameter is setAUTOAndMANUAL,Respectively. Add a data file to the master database as follows. STANDBY_FILE_MANAGEMENT of the slave database is set to AUTO and MANUAL respectively.8.3.1.1When STANDBY_FILE_MANAGEMENT Is Set to AUTO8.3.1.1 when STANDBY_FILE_MANAGEMENT Is Set to AUTO, The following example shows the steps required to add a new datafile to the primary and standby databases when STANDBY_FILE_MANAGEMENTInitialization parameter is set AUTO.

The failover of Oracle Data Guard was described in both previous articles, but there was no systematic explanation, so in this paper, DG's failover is described in a systematic note. The processing of failover redo under physical data Guard http://www.cndba.cn/Dave/article/

In Windows, configure Oracle 11gR2 Data Guard. I used to configure Data Guard when I was never in contact with Oracle. Paid download a detailed configuration document for data

Configuring the Oracle 11g Data Guard (logical standby) Oracle Data Guard logical standby database based on the same host uses a backup of the master database to first create a physical standby database, then convert it to a logic

single-instance databases or multi-instance RAC databases.6. Each Master/Slave database must have its own control file.7. If you place the Master/Slave database in a system, you must adjust the initialization parameters.8. As long as Data Guard is used, the master database must be in force logging mode. If no logging is used on the master database, logs are not generated, and the

1. Data Guard master database archive deletion policy: When we set: RMAN> configure archivelog deletion policy to applied on standby; In Maximum Availability and Maximum Performance, when RMAN backs up the archive file and adds delete input, the archive will be deleted. RMAN> configure archivelog deletion policy to none; The archive deletion policy is canceled. 2. Data