Dataguard

Useful SQL script for Data guard environment Check the data guard information on primary and Standby SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE Check the error or …

Check the archive log status in Oracle Data guard Check the received and applied archive log on the Oracle Dataguard environment select ‘Last Log applied : ‘ Logs, to_char(next_time,’DD-MON-YY:HH24:MI:SS’) Time …

Monitor lag in standby database using dgmgrl Script to monitor lag in standby database and send mail. #!/bin/bash export ORACLE_HOME=/u02/app/oracle/product/12.1.0/dbhome_1 export ORACLE_SID=primdb export PATH=$ORACLE_HOME/bin:$PATH echo -e “show database stydb”|${ORACLE_HOME}/bin/dgmgrl sys/orcl1234 …

 Check the Generated archive log in Primary Database –Run on Primary Server: select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by …

 What is Active DataGuard DML Redirection? Active Dataguard DML Redirection feature present in Oracle 19c. In this feature DML(insert/update/delete) operation can performed on Standby Database which redirected to Primary Database …

  Check physical Standby is in sync Dataguard The following command will help to check the Standby is synced with Primary Database in Oracle Dataguard Environment. On Primary Server: Check …

  ORA-19527: physical standby redo log must be renamed Error:ORA-19527: physical standby redo log must be renamedORA-00312: online log 7 thread 0: ‘G:ORACLEORADATASTANDBY05.LOG’ At DR site, we got the error …

  Steps verify for Switchover Dataguard to physical standby Before Switchover the Dataguard in production Server. You need to check the value of switch over column in v$database.If it having …

  Step to resize standby redolog files In Data-guard, if we recreate or add the standby redolog files due to thread number issue or Size mentioned wrong then in that …

 LOG_ARCHIVE_DEST_n: this parameter is used to transfer the archived redo from the primary database to standby database. Standby to primary in case of switchover. Note: LOG_ARCHIVE_DEST_n destination must have either …