Backup Recovery

Overview When working with Oracle Database, there are times when you need to look at data from the past — like rewinding a video to see what happened earlier. Oracle gives you a tool called Flashback to do this. But once you are done looking at past data, you must turn Flashback off. The command to do that is: 1EXEC …

Oracle Fast Recovery Area: Set DB Recovery File Dest and Size The Oracle Fast Recovery Area (FRA) is a disk location where Oracle stores and manages files related to backup and recovery. Two dynamic initialization parameters — db_recovery_file_dest and db_recovery_file_dest_size — control its location and maximum size, …

Delete Archive Log Older Than 5 Days in Oracle RMAN Purpose The DELETE NOPROMPT ARCHIVELOG UNTIL TIME command removes old archive log files from your Oracle database to free up disk space and maintain storage efficiency. This RMAN (Recovery Manager) command automatically deletes archive logs that are older than a …

Oracle Database Log Destinations Monitoring Script for Data Guard Purpose This Oracle SQL script monitors all log destinations in a Data Guard configuration from the primary database. The query provides real-time information about archive log destinations, their status, operational modes, and standby redo log activity. …

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 …

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 …