RMAN Example: Performing Oracle Archive Log Backups

Updated

On this page

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 Oracle Agentless 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;

}