V$archived_log

List Backup of Archivelog All: Oracle RMAN Command Guide Purpose Which archived redo logs does RMAN know how to restore? The LIST BACKUP OF ARCHIVELOG ALL command answers that question. It reads the RMAN repository and prints every backup that holds archived redo logs, one backup set at a time, with the thread and …

Check Oracle Data Guard Standby Synchronization Status Purpose Is the physical standby caught up with the primary? The fastest first answer is a pair of numbers: the log sequence the primary is writing now, and the newest log sequence the standby has applied. If the two are close, redo is flowing and being applied. If …

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. …

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 …

Oracle SQL Scripts and Database Commands 23c 21c 19c 18c 12c 11g 10g 9i 8i We are in the process of building a list of simple scripts used every day by DBA and others. If you have your own scripts you reuse in a text file on you workstation please send it to us. To look at other scripts see the Oracle Scripts Tag …