# Case Study - Primary Is Lost
Summary
1. managed standbt database finsh
2. activate physical standby database
3. open database
Step 1:
> select open_mode,protection_mode,database_role from v$database;
open_mode protection_mode database_role
---------- -------------------- ----------------
mounted maximum performance physical standby
Step 2:
> recover standby database;
ora-01153: an incompatible media recovery is active
Step 3:
> alter database recover managed standby database finish;
database altered.
Step 4:
> alter database activate physical standby database;
database altered.
Step 5:
> select open_mode,protection_mode,database_role from v$database;
open_mode protection_mode database_role
---------- -------------------- ----------------
mounted maximum performance primary
Step 6:
> alter database open;
database altered.
Step 7:
> select open_mode,protection_mode,database_role from v$database;
open_mode protection_mode database_role
---------- -------------------- ----------------
read write maximum performance primary
Hope this Helps! Rupam
