Oracle Backups Using the CommCell Console

You can back up Oracle databases, the control file, log files, the server parameter file, or Oracle datafiles and tablespaces. You can back up the database when it is online or offline. If the database must be accessible and you have a small backup window, run a series of online backups for different database portions.

Full Backups

Oracle full backups include the entire database and the control file. A full backup is the most comprehensive backup and is the baseline for incremental backups. Full backups of online databases include the log files. An offline full backup is a cold backup for Oracle databases.

Incremental Backups

An Oracle incremental backup contains the changed data from the last full backup. Incremental backups use less media and resources than full backups.

In a cumulative level n backup, only the data that differs from the most recent backup at level n-1 or lower, is backed up.

Selective Online Backups

A selective online full backup is a backup 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 is disaster recovery scenarios because the data and logs are stored together.

Performing Backups

You can perform backups immediately or schedule them through the CommCell Console.

When you use the SnapProtect job scheduler for backup, you have the following advantages:

  • Minimize your reliance on scripting
  • Restart jobs from the point-of-failure
  • Suspend jobs
  • Schedule jobs with different priorities
  • Identify the status of your data protection environment, through the SnapProtect reporting software, including:
    • where hot spots may be developing
    • where resources are consumed
  • Data security is available through the built-in role-based access operation

The SnapProtect creates and runs RMAN scripts, by using the configured options.

You can save your backup options as an RMAN backup script. If the SnapProtect interface does not support the RMAN commands, or options, you can modify the script. The Oracle Agent runs the backup script by using the SBT module in SnapProtect to back up the files to the media manager.