Tuesday, July 11, 2017

Convert standby DB to snapshot standby DB and Revert Back



Convert standby database to Snapshot database

1.       Shutdown immediate;
       2.       startup mount;
       3.       alter database recover managed standby database cancel;
       4.       select flashback_on from v$database;  --  Answer should be NO
       5.       alter database convert to snapshot standby;
6.       alter database open;
7.    select open_mode from v$database;





Convert  Back to Physical standby DB

1.   Shutdown immediate;
      2.     startup mount;
      3       alter database convert to physical standby;
      4.     Shutdown immediate;
      5.     startup mount;
      6.    select open_mode from v$database;
      7.     alter database recover managed standby database disconnect  from session;
     


No comments:

Post a Comment