Oracle RMAN Pocket Reference

Backing Up Archived Redo Log Files

With Oracle9i, the syntax for backing up archived redo log files is fairly simple:

RMAN> backup archivelog all;

Another Oracle9i technique is to use the backup command’s plus archivelog clause to include the archive redo log files as part of a backup. This creates at least two backup pieces, one for the datafiles, and one for the archived redo log files:

RMAN> backup database format 
2> '/d00/backup/rman_%U.bus' plus archivelog;

Here’s a simple script that works with both Oracle8i and Oracle9i to back up all the archived redo log files for a target:

RMAN> run {
2> allocate channel t1 type 'sbt_tape';
3> backup filesperset 5 format
4> '/d0100/backup/ar_%d_%t.bus' (archivelog all );
5> }

Note

One nice feature of RMAN is that it knows when an archived redo file has been completely written to disk. Therefore, RMAN will not attempt to back up any partially written archived redo log files.

Here’s another example that uses a shell script to execute the RMAN commands to back up the archived redo log files. When executed, all archived redo log files generated within a three-day period will be included in the backup set.

#!/bin/ksh # File: backup_arch.ksh #---------------------------------------------- export ORACLE_HOME=/d00/app/oracle/product/9.0.0 export ORACLE_SID=brdstn export PATH=/usr/sbin:/usr/bin:$ORACLE_HOME/bin export MAILX="/usr/ucb/Mail" export MAIL_LIST="[e-mail]" #---------------------------------------------- BOX=`uname -a | awk '{print$2}'` ...