-
Title
Oracle Plug-in: Manual vs Autobackups -
Description
What is the difference in using Manual or Autobackups with the Oracle Plug-in?
-
Resolution
A Manual Control File backup lets you restore a specific copy of a Control File and is ideal when data corruption has occurred and you need to restore the version most recently saved prior to data corruption. You are responsible for ensuring that the Control File is backed up with every RMAN-based backup and after every database structural change. While Manual Control File backups offer the ability to restore specific Control File backups, they cannot be used during disaster recovery or in multi-instance RAC environments.
Control File Autobackups provide the most reliability to ensure that there is always a recent backup of the Control File. In addition, they are required for disaster recovery and in multi-instance RAC environments.