[ORACLE DATAGUARD] the process of switchover
1. Check the status of the main library:
SQL > SELECT SWITCHOVER_STATUS FROM V$DATABASE
SWITCHOVER_STATUS
-
TO STANDBY
two。 Set the main library to standby role
Alter database commit to switchover to physical standby
Shutdown immediate
Startup mount
3. Convert standby to primary
SQL > select NAME, DB_UNIQUE_NAME, open_mode,DATABASE_ROLE from v$database
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
-
ORCL sty MOUNTED PHYSICAL STANDBY
SQL > SELECT SWITCHOVER_STATUS FROM V$DATABASE
SWITCHOVER_STATUS
-
TO PRIMARY
Alter database commit to switchover to primary
Alter database open
SQL > select NAME, DB_UNIQUE_NAME, open_mode,DATABASE_ROLE from v$database
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
-
ORCL sty READ WRITE PRIMARY
4. Execute on the original primary library:
Alter database recover managed standby database disconnect from session
SQL > select NAME, DB_UNIQUE_NAME, open_mode,DATABASE_ROLE from v$database
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
-
ORCL pri MOUNTED PHYSICAL STANDBY
