Oracle Database RMAN Backup & Recovery – Step by Step Guide

Introduction:
This guide provides a practical, step-by-step approach to configuring RMAN backups in Oracle Database.

Prerequisites:
– Oracle Database 19c installed
– ARCHIVELOG mode enabled
– Proper disk space available

Step 1: Verify ARCHIVELOG Mode
SQL> archive log list;

If not enabled:
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;

Step 2: Configure RMAN Environment
$ rman target /

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

Step 3: Take Full Backup (Level 0)
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG;

Step 4: Take Incremental Backup (Level 1)
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;

Step 5: Validate Backup
RMAN> RESTORE VALIDATE DATABASE;

Step 6: Restore Database (Simulation)
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN resetlogs;

Best Practices:
– Always test restore
– Store backups offsite
– Monitor backup logs

Conclusion:
RMAN is a powerful tool for Oracle DBAs. Proper configuration ensures data safety and quick recovery.