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 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 its original location
-
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)