How to shutdown and startup Oracle physical standby database and enable recovery.
You can do it with automatic or disconnecting you from the session.
1) Without disconnecting from the session.
sqlplus "/ as sysdba"
shutdown immediate
startup nomount
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER AUTOMATIC STANDBY DATABASE;
2) Disconnecting from the session.
sqlplus "/ as sysdba"
shutdown immediate
startup nomount
ALTER DATABASE MOUNT STANDBY DATABASE;
alter database recover managed standby database disconnect from session;
Comments