How to restart Oracle Standby Database(DR Database)
1. First stop the managed recovery with the below command. in standby database
alter database recover managed standby database cancel;
2. Once it is done you have to stop the database using the srvctl or by sqlplus.
3. Startup standby database to mount stage
startup mount;
4. Then you have to start the managed recovery.
alter database recover managed standby database using current logfile disconnect from session;
1. First stop the managed recovery with the below command. in standby database
alter database recover managed standby database cancel;
2. Once it is done you have to stop the database using the srvctl or by sqlplus.
3. Startup standby database to mount stage
startup mount;
4. Then you have to start the managed recovery.
alter database recover managed standby database using current logfile disconnect from session;
No comments:
Post a Comment