在主库出现宕机不能及时诊断并且FSFO没有开启的情况下,需要能够尽快恢复业务,这时候想要进行switchover是不可能的,只能执行failover。区别于10g,如果配置得当,failover过后仍可以进行恢复,(启用闪回的情况下,主库修复之后依然可以进行恢复不需要进行重新初始化)
查看当前主备库状态
DGMGRL>show configuration
Configuration- KING
Protection Mode: MaxPerformance
Databases:
king_pri - Primary database
king_std - Physical standby database
Fast-StartFailover: DISABLED
ConfigurationStatus:
SUCCESS
DGMGRL>help failover
Changesa standby database to be the primary database
Syntax:
FAILOVER TO <standby database name>[IMMEDIATE];
执行failover
DGMGRL>failover to king_std immediate
Performingfailover NOW, please wait...
Failoversucceeded, new primary is "king_std"
DGMGRL>show configuration
Configuration- KING
Protection Mode: MaxPerformance
Databases:
king_std - Primary database
king_pri - Physical standby database(disabled)
ORA-16661: the standby database needs tobe reinstated
-----这时候看到备库进行failover之后,主库的角色也发生变化,并且提示需要进行还原
Fast-StartFailover: DISABLED
ConfigurationStatus:
SUCCESS
DGMGRL>help reinstate
Changesa database marked for reinstatement into a viable standby
Syntax:
REINSTATE DATABASE <database name>;
对主库进行恢复
DGMGRL> reinstate database king_pri
Reinstatingdatabase "king_pri", please wait...
Operationrequires shutdown of instance "king" on database "king_pri"
Shuttingdown instance "king"...
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "king" on database "king_pri"
Starting instance "king"...
ORACLE instance started.
Database mounted.
Continuing to reinstate database "king_pri" ...
Operation requires shutdown of instance "king" on database "king_pri"
Shuttingdown instance "king"...
ORA-01109:database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "king" on database "king_pri"
Starting instance "king"...
ORACLE instance started.
Databasemounted.
Continuingto reinstate database "king_pri" ...
Reinstatementof database "king_pri" succeeded
重新reinstate之后,查看主备库的归档,日志序列号均是从1重新开始
SQL>archive log list
Databaselog mode Archive Mode
Automaticarchival Enabled
Archivedestination /u01/app/oracle/oradata/king/arch
Oldestonline log sequence 5
Nextlog sequence to archive 7
Currentlog sequence 7
-----这时候查看配置,主备同步关系已经修复,没有出现错误
DGMGRL>show configuration
Configuration- KING
Protection Mode: MaxPerformance
Databases:
king_std - Primary database
king_pri - Physical standby database
Fast-StartFailover: DISABLED
ConfigurationStatus:
SUCCESS
[oracle@node2~]$ dgmgrl sys/oracle@king_std
DGMGRLfor Linux: Version 11.2.0.3.0 - 64bit Production
Copyright(c) 2000, 2009, Oracle. All rights reserved.
Welcometo DGMGRL, type "help" for information.
Connected.
-----查看主备库状态,均已恢复正常
DGMGRL>show configuration
Configuration- KING
Protection Mode: MaxPerformance
Databases:
king_std - Primary database
king_pri - Physical standby database
Fast-StartFailover: DISABLED
ConfigurationStatus:
SUCCESS
-----回切至主库
DGMGRL>switchover to king_pri
Performingswitchover NOW, please wait...
Newprimary database "king_pri" is opening...
Operationrequires shutdown of instance "king" on database "king_std"
Shuttingdown instance "king"...
ORACLEinstance shut down.
Operationrequires startup of instance "king" on database "king_std"
Startinginstance "king"...
ORACLEinstance started.
Databasemounted.
Databaseopened.
Switchoversucceeded, new primary is "king_pri"