Oracle Standby Commands
Quick reference to monitor, start and stop a physical standby database
Always test these oracle standby commands on a test server before implementing them on a production server.
Starting a physical standby database:
startup nomount;
alter database mount standby database;
alter database mount standby database;
Starting the managed recovery:
alter database recover managed standby database
disconnect from session;
Stop the managed recovery:
alter database recover managed standby database
cancel;
Shutdown the physical standby database:
shutdown immediate;
Monitor primary's archive destination status:
select destination, status, archived_thread#,
archived_seq# from v$archive_dest_status
where status <> 'deferred' and status <> 'inactive';
where status <> 'deferred' and status <> 'inactive';
Check if archived logs are synching OK, compare both results:
- on primary db
select max(sequence#) from v$log_history;
- on standby db:
select max(sequence#) from v$archived_log;
Check Dataguard processes status:
- on standby db:
select process, status, thread#, sequence#, block#,
blocks from v$managed_standby;
