Oracle Scripts

How to Check Oracle Database Role Using V$DATABASE View Purpose The SQL query SELECT database_role FROM v$database is a fundamental Oracle Database command used to determine the current operational role of a database instance. This query is essential for Database Administrators (DBAs) working with Oracle Data Guard …

List All Standby Redo Logs in Oracle Data Guard Purpose A switchover attempted on a busy Friday afternoon reveals the gap: the standby has been synchronized for months, but no standby redo log group was sized to match the primary's 500 MB online redo logs. The configuration worked fine for the archived-log transport …

How to Stop Oracle Data Guard Broker Using ALTER SYSTEM Command Purpose The command ALTER SYSTEM SET dg_broker_start=false stops the Oracle Data Guard broker by shutting down the Data Guard monitor (DMON) background process. This command is essential when you need to disable broker management temporarily for …

Oracle Enable FAL Tracing on Primary Database Purpose Enabling FAL (Fetch Archive Log) tracing on the primary database helps database administrators monitor and troubleshoot archive log gap resolution between primary and standby databases in Oracle Data Guard environments. This command activates detailed trace logging …

How to Disable and Enable Oracle Archive Log Destinations Purpose Coordinating redo shipping around a standby maintenance window is an operational task every Data Guard DBA runs into: the standby is about to go down for patching, storage work, or a network change, and the primary database needs to keep generating and …

Check Missing Archive Logs in Oracle Data Guard Standby Database Purpose This SQL query helps database administrators identify missing archive logs on an Oracle Data Guard standby database. When archive logs fail to transfer from the primary to the standby database, it creates gaps that prevent proper synchronization. …

Troubleshooting Oracle Data Guard FAL and Physical Logfile Registration Issues Oracle Data Guard environments sometimes encounter issues when the Fetch Archive Log (FAL) process fails to automatically transfer missing archive logs to standby databases. When FAL reports that a log is already registered or cannot …

Register Missing Log File in Oracle Database The ALTER DATABASE REGISTER PHYSICAL LOGFILE command is used to manually register archived redo log files in an Oracle Data Guard environment, specifically for physical standby databases. This command becomes essential when automatic log registration fails or when gaps occur …

How to Cancel Oracle Data Guard Managed Recovery Overview The ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL command stops the Managed Recovery Process (MRP) on an Oracle Data Guard physical standby database. This command is essential when you need to perform maintenance operations, open the database in …

Removing Standby Database Apply Delay in Oracle Data Guard Purpose This script removes the apply delay from an Oracle Data Guard physical standby database. Apply delays are safety features that create a time lag between when redo data arrives at the standby database and when it is applied, protecting against corrupted …