Data Guard Failover 处理

   目前两边主备是正常，为了模似data grard环境主库实例无法启动，快速把备库拉起来，不考滤数据丢失，直接先把备份启动起来，接管主库工作

主库介绍
SQL> select db_unique_name,open_mode,database_role,switchover_status from v$database;

DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    SWITCHOVER_STATUS
------------------------------ -------------------- ---------------- --------------------
un_dg18                        READ WRITE           PRIMARY          RESOLVABLE GAP

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

备库介绍

SQL> set lines 1000
SQL> select db_unique_name,open_mode,database_role,switchover_status from v$database;  


DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    SWITCHOVER_STATUS
------------------------------ -------------------- ---------------- --------------------
un_dg19                        READ ONLY WITH APPLY PHYSICAL STANDBY NOT ALLOWED


SQL> select * from v$version;


BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


模似主库服务器电源故障，无法启动故障

在主库上shutdown abort
SQL> select db_unique_name from v$database;


DB_UNIQUE_NAME
------------------------------
un_dg18


SQL> shutdown abort;
ORACLE instance shut down.
SQL> 



2.3  强制激活备库：

sql> alter database recover managed standby database cancel;
sql> recover standby database until cancel;   ---提示输入日志信息。如没有直接输cancel

sql>alter database activate standby database;
sql>shutdown immediate;

sql>startup

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

转载于:http://blog.itpub.net/27252036/viewspace-1428656/