57.oracle如何快速激活DG备库

一、切换DG备库到主库。

1.停止备库的同步

alter database recover managed standby database cancel;

2.关闭数据库

shu immediate 

3.启动到mount 

SQL> startup mount
ORACLE instance started.

Total System Global Area 3925032960 bytes
Fixed Size            2259240 bytes
Variable Size          822085336 bytes
Database Buffers     3087007744 bytes
Redo Buffers           13680640 bytes
Database mounted.

4.激活备库
SQL> alter database activate standby database;

Database altered.

SQL> alter database open;

Database altered.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

二、主库损坏，failover切换从库为主库。

alter database recover managed standby database cancel;

alter database commit to failover to primary;