Backup Database

To be able to survive a disaster each database needs to perform the actions that follow.


  • RMAN backup.
    Daily incrementals and a weekly full if using the traditional method.


  • Backup of your core config files including:
    • An ASCII parameter file (pfile).
      CREATE PFILE='R:\rman\init.ora' FROM SPFILE;
    • Backup of your network config files (listener.ora, tnsnames.ora, sqlnet.ora etc.)
  • Backup of a file that lists all the locations of the database files (.arc, .ctl, .dbf, .rdo etc.).
  • Backup of your essential scripts and logs.


  • RMAN validation operation.

RMAN Backup Methods

Traditional Method

$ORACLE_HOME/bin/rman target sys/MyPassword nocatalog

RMAN> backup database plus archivelog;

Incremental Merge Backup

$ORACLE_HOME/bin/rman target sys/MyPassword nocatalog

RMAN> run {
recover copy of database with tag 'incremental_merge_backup';
backup incremental level 1 cumulative copies=1 
   for recover of copy with tag 'incremental_merge_backup' database;

Click here for detailed info on Incremental Merge Backups.

Completion Status


An RMAN backup is successful when you see this message displayed at the end of the RMAN backup log:

Recovery Manager complete


Here is an example error block header:

RMAN-00571: ======================================================
RMAN-00569: ========= ERROR MESSAGE STACK FOLLOWS ================
RMAN-00571: ======================================================