[ORACLE DATAGUARD] Switchover process

1. Check the status of the main library:

Sql> SELECT switchover_status from V$database;

Switchover_status

--------------------

To STANDBY

2. 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. The original primary library is executed:

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

This article is from the "three countries Cold jokes" blog, please be sure to keep this source http://myhwj.blog.51cto.com/9763975/1789388

[ORACLE DATAGUARD] Switchover process