Backup and Recovery Best Practices

Here are the best practices for backup and recovery for Oracle Databases. Although most of them are basic principles and can be applied to all Oracle versions, some of them are only valid for Oracle 10g and newer databases:

1) No need to explain: You must always run your DB in Archivelog mode!

2) Multiplex the controlfile at least 3 different locations. Be sure that they are located in different partitions (if possible different physical disks).

3) Multiplex the online redo log groups and members, be sure that putting them in different partitions (if possible different physical disks):

4) Take regular backups and verify that they work! Use validate command of RMAN or restore them to a test environment periodically:

5) Automatically backup your control file, it’s also recommended to set the format of your autobackup file:

6) Use RMAN catalog. When you use a recovery catalog, RMAN can perform a wider variety of automated backup and recovery functions than when you use the control file in the target database as the sole repository of metadata.

7) Turn on block checking to detect corrupt blocks in the database.

8&#41 Use the ‘check logical’ parameter to detect logical corruptions in data blocks:

9) Use Flashback Technologies. Turn on recyclebin, size undo tablespace according to your undo retention policy and if your system has no IO and disk space problem, turn on flashback logs and set Flashback Database target retention:

10) Use compression for RMAN backups. Oracle backup compression usually improves backup and recovery time (unless your system has CPU bottlenecks) and reduces usage of storage:

Please share

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.


  1. Pingback: Backups and a Clever Student - Steve Karam :: The Oracle Alchemist

  2. kenneth

    Hi sir

    Thank you for sharing the above information, i really appreciate it!

    Im still new in the field of IT and there are some things which are not so clear to me. I am currently working on a project and we were told to make a research regarding ” WHICH TIMING SLOTS OR TIMING PARAMETERS ARE CRUCIAL WHEN MAKING DATABASE BACKUPS COPIES?”

    Your help will be much appreciated


Leave Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.