Loading...

RMAN Example: Performing Oracle Archive Log Backups

You can use archive log backups to recover database transactions that have been lost due to an operating system or disk failure. Apply the archive logs to an online backup to recover a database.

By default, full backups include both data and archive logs, but you can also perform separate archive log backups.

Procedure

On the RMAN command line, run the following sample script, substituting any required or optional Oracle parameters. For information on required and optional parameters, see SBT Parameters for RMAN Jobs.

Example

RMAN>configure controlfile autobackup on;
run
{
allocate channel ch1 type sbt
PARMS="SBT_LIBRARY=<Oracle plugin location>/libcvobk_thinlibrary.so";
allocate channel ch2 type sbt
PARMS="SBT_LIBRARY=<Oracle plugin location>/libcvobk_thinlibrary.so";
send "--cv-host <Backup host hostname> --cv-clientname <Pseudo client name> --cv-bkplvl INCR";
backup format='%d_%u' archivelog all delete input;
}

Last modified: 4/26/2019 1:58:05 PM