RMAN Backups: Full, Incremental, Archivelog and PDB

Oracle DBA Certification 14 min min read Updated: Nov 16, 2026 Intermediate
RMAN Backups: Full, Incremental, Archivelog and PDB
Intermediate Topic 3 of 8

Before You Start

  • The database should be in ARCHIVELOG mode for online backups.
  • RMAN settings and the recovery area are configured (previous lesson).
  • You are connected with rman target /.

Full Database Backup

sql RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

This backs up archived logs, the datafiles, then archived logs again (so the backup is consistent) and finally the control file and SPFILE if autobackup is on.

Incremental Backups

LevelWhat it copies
Level 0All used blocks. The base of the strategy.
Level 1 differentialBlocks changed since the last level 0 or 1 (default)
Level 1 cumulativeBlocks changed since the last level 0
sql RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG; RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE PLUS ARCHIVELOG; RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Why incremental? A level 1 backup is much smaller and faster than a full one. Restore uses the level 0 plus the incrementals, then redo.

Backup Archived Redo

sql RMAN> BACKUP ARCHIVELOG ALL NOT BACKED UP 1 TIMES DELETE INPUT;

Run this every 15 to 60 minutes. DELETE INPUT removes the archive after it is safely backed up, which keeps the recovery area from filling.

Back Up Part of the Database

sql RMAN> BACKUP TABLESPACE users, app_data; RMAN> BACKUP DATAFILE 7; RMAN> BACKUP PLUGGABLE DATABASE freepdb1; RMAN> BACKUP CURRENT CONTROLFILE; RMAN> BACKUP SPFILE;

Image Copies

sql RMAN> BACKUP AS COPY DATABASE;

An image copy is an exact copy of each datafile. It restores very fast because it can be used directly, but it needs as much space as the database.

Check Your Backups

sql -- reads the database and checks for corruption, writes nothing RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE; -- checks that existing backups can be restored RMAN> RESTORE DATABASE VALIDATE;
Tip: Run RESTORE DATABASE VALIDATE regularly. It proves RMAN can find and read every file it needs without restoring anything.

A Simple Daily Script

text # backup_daily.rman RUN { BACKUP INCREMENTAL LEVEL 1 DATABASE PLUS ARCHIVELOG; DELETE NOPROMPT OBSOLETE; }
bash # run from cron at 01:00 0 1 * * * rman target / cmdfile=/home/oracle/scripts/backup_daily.rman log=/home/oracle/logs/backup_$(date +\%F).log
Speed-up: On Enterprise Edition you can enable block change tracking so level 1 backups read only the changed blocks instead of scanning every datafile.

Conclusion

Take a level 0 weekly, level 1 daily and archived redo frequently. Always delete obsolete backups and validate them.

Quick Summary: BACKUP DATABASE PLUS ARCHIVELOG, level 0 + level 1, BACKUP ARCHIVELOG often, VALIDATE regularly.

Get Newsletter

Subscibe to our newsletter and we will notify you about the newest updates on Edugators