Oracle11g Snapshot Standby Database

ORACLE11G Snapshot Standby Database

 

A snapshot standby database is a fully updatable standby database.（snapshot standby database是一个可读写数据库）

1.  Like a physical or logical standby database, a snapshot standby database receives and archives redo data from a primary database.(类似于普通物理standby数据库，接受主库传送过来的归档)

2.   Unlike a physical or logical standby database, a snapshot standby database does not apply the redo data that it receives. The redo data received by a snapshot standby database is not applied until the snapshot standby is converted back into a physical standby database, after first discarding any local updates made to the snapshot standby database.（又不类似普通物理standby数据库，只接受归档，但是不应用归档日志）

3.   A snapshot standby database is best used in scenarios that require a temporary, updatable snapshot of a physical standby database. Note that because redo data received by a snapshot standby database is not applied until it is converted back into a physical standby, the time needed to recover from a primary database failure is directly proportional to the amount of redo data that needs to be applied.（快照standby数据库的应用场景是可以临时搭建成一个可读写的数据库，供测试使用）

4.Converting a Physical Standby Database into a Snapshot Standby Database（普通standby数据库转换成快照standby数据库）

    4.1 Stop Redo Apply, if it is active.（取消日志恢复）

    4.2  On an Oracle Real Applications Cluster (Oracle RAC) database, shut down all but one instance.（如果快照库是rac，只mount其中一个实例）

    4.3  Ensure that the database is mounted, but not open.（数据库处于mount）

    4.4  Ensure that a fast recovery area has been configured. It is not necessary for flashback database to be enabled.（需要Fra，但是不需要闪回数据库功能）

    4.5  Issue the following SQL statement to perform. the conversion:（转换指令）

     SQL> ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

 

5.Converting a Snapshot Standby Database into a Physical Standby Database（快照standby数据库回切普通standby数据库）

 

   5.1   On an Oracle Real Applications Cluster (Oracle RAC) database, shut down all but one instance..（如果快照库是rac，只mount其中一个实例）

   5.2   Ensure that the database is mounted, but not open.（数据库处于mount）

   5.3   Issue the following SQL statement to perform. the conversion::（转换指令）

           SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

在转换与回切的过程中，主库的归档日志一直在向备库发送，在转换之前，备库停止了应用数据（scn 100），但是归档继续接受；在回切之后，备库继续应用数据（从停止的scn 100继续），因此dataguard架构并没有被破坏，数据库仍然是正常的主库备库的形式正常运转。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21266384/viewspace-755628/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21266384/viewspace-755628/