手动执行failover

          在主库出现宕机不能及时诊断并且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"