A failover is performed only when the primary database becomes unavailable, and there is no possibility of recovering the primary database.
Steps involve in failover
- Connect to Physical Standby
- Cancel the MRP process
- Finish applying all received redo data
- Activate the physical standby to become a primary database
- Shutdown and startup database database
Step 1: Connect to Physical Standby
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
REYNO MOUNTED PHYSICAL STANDBY
Step 2: Cancel the MRP process.
SQL> alter database recover managed standby database cancel;
Database altered.
Step 3: Finish applying all received redo data.
SQL> alter database recover managed standby database finish;
Database altered.
Step 4: Activate the physical standby to become a primary database.
SQL> alter database activate standby database;
Database altered.
Step 5: Shutdown and startup the database
SQL> startup
ORACLE instance started.
Total System Global Area 1543500144 bytes
Fixed Size 8896880 bytes
Variable Size 889192448 bytes
Database Buffers 637534208 bytes
Redo Buffers 7876608 bytes
Database mounted.
Database opened.
Check the database role
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
REYNO READ WRITE PRIMARY
