Introducing Arcserve Backup Agents and Options › Using Options › Enterprise Option for SAP R/3 for Oracle › Best Practices › Backup and Recovery Strategies

Backup and Recovery Strategies

Plan your backup and recovery strategies for a database before you create the database, and maintain a regular backup schedule to ensure smooth recovery in case of database or media failure. If such planning is not considered before database creation, database recovery may not be possible in certain cases.

Note: For more information about disaster recovery planning, see Disaster Recovery Scenarios.

When you develop your backup and recovery strategy, consider the following:

• Full backups—Full database backups should be performed regularly; it is easier to recover a database from a full backup.
• Tablespace-level backups—Recoverable databases allow tablespace-level backups, which can be done online or offline. For an isolated application error, it is easier to restore from a tablespace-level backup image.
• Online or offline backups—Offline backups are usually faster, but require exclusive access to the database. Online backups reduce the database downtime; however, they allow other connections to the database while the backup is taking place.