基于单机的DataGuard切换文档

主机名

型号

操作系统版本

主机名

型号

操作系统版本

IP

Alias

备注

IP

Alias

备注

SQL> SELECT   DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

DATABASE_ROLE    SWITCHOVER_STATUS

----------------   --------------------

PRIMARY          TO STANDBY

备注代码 ：

附 ：   A:switchover_status 出现 session active/not   allowed

当出现 session active 的时候表示还有活动的 session, 则运行 下面代码：

 Alter database commit to switchover to   physical standby with session shutdown;

当出现not allowed时，在官方文档说转换会不成功尝试运行一下代码

B.ORA-01153: an   incompatible media recovery is active 则 运行下面代码：

Alter database   recover managed standby database finish;

或者 Alter database   recover managed standby database finish force;

SQL>Alter   database commit to switchover to physical standby with session shutdown;

或者

SQL> ALTER   DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;

Database altered.

SQL> SHUTDOWN   IMMEDIATE

SQL> startup   mount;

SQL> ALTER DATABASE   RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

SQL> SELECT   DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

DATABASE_ROLE    SWITCHOVER_STATUS

----------------   --------------------

STANDBY          TO PRIMARY

附 ： 若不是用此语句切换 ：ALTER DATABASE COMMIT TO SWITCHOVER   TO PRIMARY with session shutdown

补充 ： 若出现 ：ORA-16139: media recovery required

是因为没有执行：alter   database recover managed standby database disconnect from session;

SQL> ALTER DATABASE   COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

SQL> shutdown   immediate;

SQL> startup;

SQL> alter   system switch logfile;

su - oraclesqlplus "/ as sysdba"SQL>alter system switch logfile;SQL>alter system switch logfile;

$ tail -f   /oracle/app/diag/rdbms/kinton/kinton/trace/alert_kinton.log

$export ORACLE_SID=kinton$sqlplus / as sysdba 确认传输服务设在log_archive_dest_state_2 参数上SQL> alter system set log_archive_dest_state_2=defer   scope=both sid='*';

停止应用归档：

　　 SQL> ALTER   DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

　　Database   altered.

备库停止应用归档 ­

　　 SQL> ALTER   DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

或 SQL> ALTER   DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;

Database altered.

确认数据库角色为STANDBY

确认数据库保护模式为最大性能模式

　　 SQL> select   DATABASE_ROLE,PROTECTION_MODE,SWITCHOVER_STATUS from v$database;

　　 DATABASE_ROLE

　　 ----------------

PHYSICAL STANDBY

若数据库非最大性能模式，则手动切换成最大性能模式，若是则跳过此步

SQL> alter   database set standby database to maximize performance;

执行Failover切换

　　 SQL> ALTER   DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Database altered.

切换完成之后重启数据库

    SQL> shutdown immediate

      SQL> startup