dg之主备切换

主备切换前，一定要注意日志全都应用

主备切换报错，如何切换回去？

1. 现备库（原主库）切回主库

QL> select database_role,switchover_status from v$database;

DATABASE_ROLE

SWITCHOVER_STATUS

PHYSICAL STANDBY
SESSIONS ACTIVE

SQL> alter database commit to switchover to primary with session shutdown;

Database altered.

SQL> select status from v$instance;

STATUS

MOUNTED

SQL> alter database open ;

Database altered.

SQL> select status from v$instance;

STATUS

OPEN

SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE

SWITCHOVER_STATUS

PRIMARY
SESSIONS ACTIVE

2. 备库
   SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE SWITCHOVER_STATUS

PHYSICAL STANDBY RECOVERY NEEDED

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE SWITCHOVER_STATUS

PHYSICAL STANDBY NOT ALL