oracle 10g dataguard 切换实战

操作步骤

备库：

SQL> alter database recover managed standby database cancel;

Database altered.

SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

Database altered.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

SQL>  SHUTDOWN IMMEDIATE;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 2.2599E+10 bytes
Fixed Size                  2111736 bytes
Variable Size            2466252552 bytes
Database Buffers         2.0082E+10 bytes
Redo Buffers               48218112 bytes
Database mounted.
Database opened.

收尾工作 。比如清理日志 之类 清理临时表空间之类 。