oracle dataguard的一些说明

====================================================================
10g
standby 库 DG

SQL> startup nomount
SQL> alter database mount standby database;

启动redo 应用
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

停止redo应用
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;





启动实时应用
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

提示：disconnect from session
子句并非必须，该子句用于指定启动完应用后自动退出到命令操作符前，
如果不指定的话，当前session 就会一直停留处理redo 应用，如果想做其它操作，就只能新建一个连接。


停止实时应用
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;


在standby 库上，redo Apply(MRP 进程)或sql Apply(LSP 进程)读取归档文件将数据应用至standby 数据库。(如果启用了实时应用的话，MRP/LSP 会直接读取standby redolog 并应用到standby 数据库，无须再等待归档)。



===================================================================================================
11g R2

standby 库 DG

启动到read only状态:startup
启动到redo apply: startup mount/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect
redo apply到read only open: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel/alter database open read only
read only open到redo apply: shutdown immediate/startup mount/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect

启动到实时应用: startup mount/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT
实时应用到read only open: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel/alter database open read only



standby 库 ADG
redo apply可以在mount或readonly open状态激活
redo apply在mount状态激活就是DG：startup mount/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

redo apply在readonly open状态激活就是ADG：startup mount/ALTER DATABASE OPEN/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

状态之间装换：startup mount / ALTER DATABASE OPEN / ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT
/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT
/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT
/ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel/shutdown immediate


DG-->ADG
SQL> startup mount
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;