Oracle Database
Oracle RMAN Reset Database After RESETLOGS Recovery
Jan 9, 2026 / · 8 min read · Oracle Database RMAN Database Recovery Backup and Restore Recovery Catalog Database Administration Incomplete Recovery RESETLOGS ·Oracle RMAN Reset Database After RESETLOGS Recovery Purpose In the Oracle 19c documentation, opening a database with RESETLOGS needs no manual step to register the new incarnation. Oracle creates the incarnation record in the recovery catalog and makes it the current incarnation for you. The RESET DATABASE command in …
Read MoreHow to Register an Oracle Database with RMAN Catalog
Jan 7, 2026 / · 10 min read · Oracle Database RMAN Database Backup Recovery Catalog Database Administration Password File Oracle Scripts Database Registration v$database ·How to Register an Oracle Database with RMAN Catalog Purpose The RMAN register database command adds a target database to the recovery catalog so that Recovery Manager can track and maintain backup metadata. This allows RMAN to store backup information, recovery points, and database structure details in a central …
Read MoreOracle Data Guard: V$ARCHIVE_DEST Log Destinations
Jan 5, 2026 / · 4 min read · Oracle Database Data Guard Database Administration Archive Logs Primary Database Monitoring Scripts SQL Queries High Availability v$archive_dest ·Display Log Destinations Options for Oracle Data Guard Primary Database Purpose This SQL script displays detailed information about all configured archive log destinations on an Oracle Data Guard primary database. The query retrieves critical configuration parameters from the V$ARCHIVE_DEST view, allowing database …
Read MoreOracle Logical Standby Apply Stop and Start Commands
Jan 2, 2026 / · 4 min read · Oracle Database Data Guard Logical Standby SQL Apply Database Administration Backup Recovery High Availability DBA Commands ·Oracle Logical Standby Apply Stop and Start Commands Purpose The logical standby apply commands control the SQL Apply process in Oracle Data Guard logical standby databases. These commands allow database administrators to stop and start the application of redo log data from the primary database to the logical standby …
Read MoreOracle Data Guard Standby Redo Log Query: Groups and Members
Jan 1, 2026 / · 11 min read · Oracle Database Data Guard Standby Logs SQL Scripts Database Administration Redo Logs Oracle Views DBA Tools v$standby_log v$logfile ·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 …
Read MoreOracle Data Guard: Stop Broker with ALTER SYSTEM
Nov 29, 2025 / · 5 min read · Oracle Database Data Guard Database Administration Oracle Broker SQL Commands Database Management Oracle DBA Backup and Recovery ·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 …
Read MoreOracle Enable FAL Tracing on Primary Database
Nov 28, 2025 / · 4 min read · Oracle Database Data Guard Backup and Recovery Database Administration Troubleshooting Archive Logs FAL Redo Transport ·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 …
Read MoreHow to Disable and Enable Oracle Archive Log Destinations
Nov 27, 2025 / · 9 min read · Oracle Database Data Guard Archive Log DBA Commands Database Administration Standby Database Oracle Backup Database Maintenance v$archive_dest ·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 …
Read MoreRegister Missing Log File in Oracle Data Guard Database
Oct 26, 2025 / · 6 min read · Oracle Database Data Guard Archive Logs Physical Standby Database Recovery DBA Scripts Gap Resolution Log Management V$ARCHIVED_LOG v$managed_standby ·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 …
Read MoreOracle ASH Report: Generate with ashrpt.sql
Generate Active Session History ASH Report in Oracle Database Users say the application froze for four minutes at 10:42 and then recovered. An hourly AWR report will average that spike away. An Active Session History (ASH) report built for 10:40 to 10:50 shows which sessions, SQL statements and wait events were active …
Read More