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#;