oracle data guard protection modes

switch to the primary role. Otherwise, confirm that the Redo app is started until the query results show to primary or sessions ACTIVE. 7. Switch the physical standby to the primary role Execute the following SQL on the target physical standby: Sql> ALTER DATABASE COMMIT to switchover to PRIMARY with SESSION SHUTDOWN; Note: If the query results in step 1th are to PRIMARY, the WITH SESSION shutdown clause in the SQL statement can be omitted.

Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows: 1. Stop log transfer

a dictionary in the redo dataTo build dictionary in the redo data, you must enable the logminer at first.Issuing the following statement when the primary database is in the open state:04:59:50 SQL> alter database add Supplemental log data;If you do not run the command above to enable the logminer, the alter database recover to logical standby cuuo will never end up even if you run;Execute dbms_logstdby.bui

Lab 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 its strong adaptability to the network, it can adopt synchronous real-time transmission methods and asynchronous delay transmission methods, it can even become a remote disaster recovery solution. Regardless of the purpose, the DG will inevita

Lab 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 its strong adaptability to the network, it can adopt synchronous real-time transmission methods and asynchronous delay transmission methods, it can even become a remote disaster recovery solution. Regardless of the purpose, the DG will inevita

Role Switching between Data Guard master and slave databases is divided into the following two types:1) SwitchoverSwithchover is generally designed to switch roles, such as upgrading. It is usually lossless, that is, there will be no data loss.Its execution is divided into two phases:1. convert Primary to Standby2. Convert Standby (one) to Primary2) FailoverFailo

The role switching between Data guard master and subordinate libraries is divided into the following two kinds:1) SwitchoverSwithchover are usually artificial and planned for role swaps, such as upgrades. It is usually lossless, that is, there will be no loss of data. its implementation is mainly divided into two stages:1.Primary Switch to Standby2.Standby (one)

* ERROR in line 1:ora-03113: End-of-file on communication channel--trying to manipulate the main library throw error Process id:4810 session id:28 Serial: Not connected to Oracle Sys@priocm> exit disconnected from Oracle Database 11g Enterprise Edition release 11.2.0.3.0 -Production with the partitioning, OLAP, Data Mining and real application testing options--t

/standby/system01.dbf /data/oradata/standby/undotbs01.dbf /data/oradata/standby/sysaux01.dbf /data/oradata/standby/users01.dbf /data/oradata/standby/test01.dbf Sql> Show Parameter Standby_file NAME TYPE VALUE ------------------------------- ----------- ------------------------------ Standby_file_management stri

Oracle Data Guard from the macroscopic point of view, mainly provides the following two services: 1) Log transmission: The main library transmits the generated redo log to the standby library; 2 log application: The redo log, which is transferred from the main library, is used by the standby library. This article first describes the log Transport service, the

set to MANUAL or AUTO: Drop the tablespace from the primary database:1. delete a tablespace from the master databaseSQL> drop tablespace tbs_4; SQL> ALTER SYSTEM SWITCH LOGFILE; Make sure that Redo Apply is running (so that the change is applied to the standby database). If the following query returns the MRP or MRP0 process, Redo Apply is running.Make sure that the redo application is running, so that the slave database will apply these changes. If the MRP or MRP0 process returned by the f

DG's core function is to provide high availability disaster, so the role-switching content described in this section is the most important part of DG. The role switching between DG Master and slave Libraries is divided into the following two kinds: 1) Switchover Swithchover refers to the master-slave library for role swaps (master Library, reserve library variable main library), usually man-made, planned, such as the use of switchover can reduce the database upgrade downtime, so do not cause

When the application redo log is started, the redo log is canceled when the application is disabled:8.1 Starting Up and Shutting Down a Physical Standby Database This section describes the SQL * Plus statements used to start up and shut down a physical standby database.8.1.1Starting Up a Physical Standby Database8.1.1 start the Physical Standby Database To start a physical standby database, use SQL * Plus to connect to the database with administrator privileges, and then use either the SQL * Plu

To test the creation of a data guard environment on the same server. The main library is in a normal state and there are available backups, and the force logging and associated initialization parameters for the main library are set below: sql> ALTER DATABASE force logging; Database altered. To modify the initialization parameters of the main library: Sql> alter system set Log_archive_config = ' dg_conf

The following is a detailed analysis of the use of Oracle switchover and failover, the need for friends under the reference The role switching between Data guard master and subordinate libraries is divided into the following two kinds:1) SwitchoverSwithchover are usually artificial and planned for role swaps, such as upgrades. It is usually lossless, that is, th

Before you can create a logical repository, you must first create a physical repository, and for how to create a physical library, refer to the Data Guard series (4)-Creating a physical repository without stopping the main library. 1. Stop the Log Application service on the physical repository sys@jkka> ALTER database RECOVER MANAGED STANDBY database CANCEL; Database altered. 2. Reset the main

; GRANT CREATE synonym to Tjsq_trade; Grant succeeded. sql> GRANT CREATE synonym to Tjsq_trade_oper; Grant succeeded. The creation of table spaces and the time required for data file initialization need to be timed separately: Sql> SET TIMING on sql> CREATE tablespace tjsq datafile '/data/oracle/oradata/tjsq/tjsq01.dbf ' size20g, 2 '/

; GRANT CREATE synonym to Tjsq_trade; Grant succeeded. sql> GRANT CREATE synonym to Tjsq_trade_oper; Grant succeeded. The creation of table spaces and the time required for data file initialization need to be timed separately: Sql> SET TIMING on sql> CREATE tablespace tjsq datafile '/data/oracle/oradata/tjsq/tjsq01.dbf ' size20g, 2 '/

According to Oracle's documentation, the data pump in different ways to export imports, performance can be significantly different, this time just have the opportunity to test, migration table space, direct path, external table, and database chain export, import performance differences. First check that the table space of the source database satisfies the self contained condition: Sql> EXEC Dbms_tts. Transport_set_check (' tjsq,tjsq_tmp ') Pl/sql p

reads are not allowed; serializable: dirty reads, non-repeated reads, and Phantom reads are not allowed. Oracle provides read committed and serializable isolation levels, and an additional read-only mode. The read committed mode is used by default. Read committed provides statement-level read consistency, and serializable provides transaction-level read consistency. Under the Read committed level, non-repeated and hypothetical reads may still occur.