Thursday, March 17, 2011

Dataguard a case study - what to do when Primary database is lost ?

# 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