Disaster Recovery Scenarios

Planning your backup methodology in advance is critical for protecting your database against failures, and for quick recovery of your database server in case of disaster.

For most efficient disaster recovery, implement the following backup strategy:

• Perform a full offline backup of your Oracle data files, configuration files, and registry information so you can restore an offline image of Oracle server.
• Perform a full offline or online backup each time there is a major schema change in your databases (for example, when you delete a tablespace, create a new one, or add a data file). A full offline backup is not required, but it is highly recommended.
• Perform full online backups regularly; for example, once a week. You can choose to back up only the archive redo log files for the remaining days of the week, if the time needed for a full online backup prohibits a full backup.