How to open Standby DB when Primary is lost
Case: The primary is lost, we need to open the standby database.
sqlplus / as sysdba
STARTUP MOUNT
-- Check the status of DB
SELECT DB_UNIQUE_NAME, OPEN_MODE, PROTECTION_MODE, DATABASE_ROLE FROM V$DATABASE;
RECOVER STANDBY DATABASE;
==> CANCEL
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;
ALTER DATABASE OPEN;
-- Check the status of DB
SELECT DB_UNIQUE_NAME, OPEN_MODE, PROTECTION_MODE, DATABASE_ROLE FROM V$DATABASE;