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.
Best Practice: Schedule an Oracle RAC archive log backup every 20 minutes on busy databases.
Before You Begin
-
If you run the RMAN script on a UNIX environment, use PARMS in the Allocate Channel Command.
-
Use a unique backup piece format to avoid conflicting backup piece names.
-
Place the database in ARCHIVELOG mode.
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' PARMS="SBT_LIBRARY=software_install_path/Base/libobk.so,BLKSIZE=262144, ENV=(CVOraRacDBName=rac_database_name, CvInstanceName=instance_name, -hn=host_name)"; allocate channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=software_install_path/Base/libobk.so,BLKSIZE=262144, ENV=(CVOraRacDBName=$[rac_database_name], CvInstanceName=$[instance_name], -hn=<host_name>)"; allocate channel ch3 type 'sbt_tape' PARMS="SBT_LIBRARY=software_install_path/Base/libobk.so,BLKSIZE=262144, ENV=(CVOraRacDBName=rac_database_name, CvInstanceName=instance_name, -hn=host_name)"; allocate channel ch4 type 'sbt_tape' PARMS="SBT_LIBRARY=software_install_path/Base/libobk.so,BLKSIZE=262144, ENV=(CVOraRacDBName=rac_database_name, CvInstanceName=instance_name, -hn=host_name)"; setlimit channel ch1 maxopenfiles 1; setlimit channel ch2 maxopenfiles 1; backup filesperset =8 (archivelog all delete input); }