ITPub博客

首页 > 数据库 > Oracle > Performing a Failover to a Physical Standby Database

Performing a Failover to a Physical Standby Database

原创 Oracle 作者:不一样的天空w 时间:2020-02-24 15:43:19 0 删除 编辑

一: Performing a Failover to a Physical Standby Database

https://docs.oracle.com/cd/E11882_01/server.112/e41134/role_management.htm#SBYDB00625

章节:8.2.2, This section describes how to perform a failover to a physical standby database.


二: activate_standby_db_clause

https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_1004.htm#i2078537


activate_standby_db_clause

Use the  ACTIVATE  STANDBY  DATABASE clause to convert a standby database into a primary database.

Caution:

Before using this command, refer to  Oracle Data Guard Concepts and Administration for important usage information.

PHYSICAL Specify  PHYSICAL to activate a physical standby database. This is the default.

LOGICAL Specify  LOGICAL to activate a logical standby database. If you have more than one logical standby database, then you should first ensure that the same log data is available on all the standby systems.

FINISH APPLY This clause applies only to logical standby databases. Use it to initiate  terminal apply, which is the application of any remaining redo to bring the logical standby database to the same state as the primary database. When terminal apply is complete, the database completes the switchover from logical standby to primary database.

If you require immediate restoration of the database in spite of data loss, then omit this clause. The database will execute the switchover from logical standby to primary database immediately without terminal apply.

三:Oracle 10g/11g关于activate standby database

https://www.linuxidc.com/Linux/2013-09/90091.htm

http://blog.itpub.net/267265/viewspace-2134546/


四、failover后能够恢复DG

https://blog.csdn.net/shiyu1157758655/article/details/55261193

为了能够在failover后能够恢复DG,需要在主库上开启flashback

关于开启flashback 可以参考:

http://blog.csdn.net/shiyu1157758655/article/details/55095760

如果不开启flashback的话,DG就要重新搭建


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

请登录后发表评论 登录
全部评论

注册时间:2016-09-22

  • 博文量
    916
  • 访问量
    1400313