How to start standby database

In this blog, we will learn about how to start the standby database in dataguard environment.

First we need to start the primary database and also start the listener services

Primary Side

sqlplus / as sysdba

startup

Start the listener on primary server

lsnrctl start

lsnrctl status

Standby Side

Start the listener and database.Database will be in mount stage as its physical standby database

lsnrctl start

lsnrctl status

sqlplus / as sysdba

startup nomount
alter database mount standby database;
alter database recover managed standby database disconnect from session;

Check the database status on primary and standby

select status,instance_name,database_role,protection_mode from v$database,v$instance;

TO check if dataguard in synchronizing with standby.

select thread#,max(sequence#) from v$archived_log where applied=’YES’ group by thread#;

Leave a Reply