V11 SP8
Loading...

RMAN Example: Performing Oracle Full Backups

Backups for any instance start with a full backup. The full backup is the baseline for other backups. For example, a full backup must be performed before an archive log backup can be initiated.

Perform a full backup of an online or offline database. If the database is in NOARCHIVELOG mode, perform an offline backup.

Best Practice: Use separate scripts for data and logs because only one data type can be passed through the argument file. This system uses the data type to mark the archive files created by the backups as DATA or LOG in the CommServe database. If you have scripts containing both data and logs, the archive files are marked as either DATA or LOG, depending on the data type that is defined in the argument file.

Best Practice: The drive reservation retry mechanism works more efficiently when you use separate RMAN scripts for data and log backups.

Before You Begin

  1. If you run the RMAN script on a UNIX environment, relink the SBT library or use PARMS in the Allocate Channel Command.
  2. Use a unique backup piece format to avoid conflicting backup piece names.
  3. Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

About This Task

An RMAN full database backup includes all data blocks in the specified file and can also include the control file.

If you do not use the incremental option, the backup is treated as an Oracle full backup and is not used in incremental strategies. If you specify the incremental level=0 command, the backup is used as the base for the incremental level backups.

Procedure

  • On the RMAN command line, run the following sample script, substituting any required or optional Oracle SBT parameters.

    For information on required and optional SBT parameters, see SBT Parameters.

run {
allocate channel ch1 type 'sbt_tape';
allocate channel ch2 type 'sbt_tape';
allocate channel ch3 type 'sbt_tape';
allocate channel ch4 type 'sbt_tape';

setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
setlimit channel ch3 maxopenfiles 8;
setlimit channel ch4 maxopenfiles 8;

backup incremental level = 0
filesperset = 4 format '%d_%U_%t'
database include current controlfile;
}