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