SAP for Oracle

Updated

You can use the Commvault software to back up and restore SAP for Oracle.

Backups

Data You Can Back Up

  • Database

  • Log files

  • Control file

  • Archived redo logs

Data That You Cannot Back Up

  • Application files that are associated with the SAP on Oracle installation

You can use a file server to back up the application files.

Backups You Can Perform

  • Full backups: Full backups include the entire database and the control file. Full backups of online databases include the log files.

  • Selective online full backups: Selective online full backups are taken when the database is online. The backed-up data is copied to a selective copy, which you can use for a restore. This backup is useful in disaster recovery scenarios because the data and the logs are stored together.

  • Incremental backups: Incremental backups include the data that changed after the most recent backup.

Backup Devices

  • util_file

  • rman_util

  • util_file_online

When You Can Perform Backups

  • On a schedule: The server plan that you assign manages scheduled backups

  • On demand: You can perform on-demand backups at any time

Restores

Data You Can Restore

  • The entire database: Restores all database files, the control file, and the server parameter file

  • Part of the database: Restores any combination of the following files:

    • Archive logs

    • Oracle control file

    • Individual datafiles and tablespaces

    • Database archived redo logs

Backups You Can Use for Restores

  • The most recent backup: For example, restore the most recent backup to secondary storage, such as tape, for long-term storage

  • A backup from a specific date: For example, restore data to a point in time before it became unusable

  • Backups from a date range: For example, restore data that was accidentally deleted

Destinations You Can Restore To

  • To the same server and instance (in place)

  • To a database copy (out of place)