Posted inDataGuard Oracle

Monitor Standby Database with Lag Time Report

vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh #!/bin/ksh export ORACLE_SID=<Target_ORACLE_SID> export ORACLE_HOME=/u01/oracle/product/11.2.0.4/db /u01/oracle/product/11.2.0.4/db/bin/sqlplus -s / as sysdba << NACHO > /tmp/standbylag.log set feedback off select 'Standby thread '|| thread# || ' is '|| round((sysdate -…
No Comments
Posted inDataGuard Oracle

De-configure MRP in Standby

On Source, as Oracle user: export ORACLE_SID=<source_sid> sqlplus '/as sysdba' alter system set log_archive_dest_state_<whatever_#_used>='DEFER' scope=both sid='*'; alter system set log_archive_dest_<whatever_#_used>='' scope=both sid='*'; alter system set log_archive_config='dg_config=(<only the db_unique_name's needed>)' scope=both…
No Comments
Posted inDataGuard Oracle

RollForward Standby Database using rman service

Overview:As we are already aware that the rolling forward an physical standby database via an incremental SCN based backup method is one of the easiest way of getting your standby database with lag into sync with the primary database.The lag can be due to missing archives on the primary which haven’t been shipped or applied on the standby.In 12c, this…
No Comments
Posted inDataGuard Oracle Scripts

Oracle Dataguard Scripts

1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To display current status for Physical Standby Database background processes. SQL>…
No Comments
Posted inDataGuard Oracle

Standby : Unnamed file issue

Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185 is unknown - rename to correct file ORA-0111: data file 185: '/u01/oracle/product/19/db/dbs/UNNAMED00185' ORA-01157: cannot identify/lock…
No Comments