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) 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:

No Responses to “Backup and Recovery Best Practices”

Trackbacks/Pingbacks

  1. Backups and a Clever Student - Steve Karam :: The Oracle Alchemist - [...] I would help them out a bit by putting up a list of recommended practices. Set your backup parameters …

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">