data guard commands cheat sheet

Learnomate Technologies > data guard commands cheat sheet
Oracle Dataguard Important Command
02
Jan

In this blog, We will look some important oracle dataguard command.Following command will be useful for dataguard administration Check the Dataguard database status on primary and standby select status,instance_name,database_role,protection_mode from v$database,v$instance; Query to apply redo log on standby. Following command useful for real time apply ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE; To […]

Posted in: Oracle DBA ,
Tags: check data guard broker status , data guard commands cheat sheet , dgmgrl status , how to check if archive logs are applied to standby database , how to check primary and standby database in oracle , how to check standby database status from primary , how to sync primary and standby database in oracle , Oracle Dataguard Important Command , physical standby database not applying logs , v$archive_dest_status error ,