Introduction
Archive logging is a critical feature in Oracle databases that enables database recovery and online backups. When the database runs in ARCHIVELOG mode, Oracle archives redo log files before they are overwritten. These archived logs can later be used for point-in-time recovery and disaster recovery.
In this article, we will walk through:
-
Checking the current archive log status
-
Enabling ARCHIVELOG mode
-
Configuring the Fast Recovery Area (FRA)
-
Changing the archive log destination
-
Verifying archive log generation
This guide applies to Oracle 19c running on Linux.
Step 1: Check the Current Archive Log Location and Archive Log Status
First, connect to the database and verify the current archive log destination.
Explanation
-
Database log mode:
No Archive Mode– The database is not archiving redo logs. Automatic archival:
Disabled– Archive log generation is turned off.-
Archive destination: Default location where archive logs will be stored once archiving is enabled.
-
Log sequence numbers: Show the redo log sequence currently in use.
Since the database is in NOARCHIVELOG mode, you cannot perform point-in-time recovery or hot backups.
Step 2: Steps to Enable ARCHIVELOG Mode
Start Database in Mount Mode
Enable ARCHIVELOG Mode
Open the Database
Step 3: Verify Archive Log Mode
Step 4: Configure Fast Recovery Area (FRA)
The Fast Recovery Area (FRA) is a central location where Oracle stores:
-
Archive logs
-
Flashback logs
-
Backup files
-
Control file backups
Check the FRA parameters.
Set FRA Size
Step 5: Set Archive Log Destination
Step 6: Confirm Archive Destination
Step 7: Generate Archive Logs
Caution: Your use of any information or materials on this Blog is entirely at your own risk. It is provided for educational purposes only.