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 this post Share on Facebook2Share on Google+0Share on LinkedIn1Share on Reddit0Tweet about this on Twitter

Gokhan Atil is a database architect who has hands-on experience with both RDBMS and noSQL databases (Oracle, PostgreSQL, Microsoft SQL Server, Sybase IQ, MySQL, Cassandra, MongoDB and ElasticSearch), and strong background on software development. He is certified as Oracle Certified Professional (OCP) and is awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for his continuous contributions to the Oracle users community.


  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. Required fields are marked *