The Geek Diary

HowTos | Basics | Concepts

Oracle Database: How to catalog tape backup pieces

By

Starting with 10g, it’s possible to use the RMAN CATALOG command to add backuppieces stored in the disk to the RMAN repository. You may need to catalog backup pieces in the following situations:

  • You copy or move a backup piece with an operating system utility and want it to be usable by RMAN.
  • The RMAN metadata for the backup piece was removed, but the backup piece still exists. This situation can occur if you ran the DELETE command on a backup piece that was only temporarily unavailable.
  • You make a NOCATALOG backup on one database host in a Data Guard environment and move the backup piece to the same location on a different database host. In this case, the recovery catalog has no record of the original backup piece.
  • You do not use a recovery catalog and must re-create the control file, thereby losing all RMAN repository data. Cataloging your backups makes them available again.
  • When control file autobackup is disabled, you back up the control file and then back up the archived redo logs. You can restore and mount the control file but must catalog the backup pieces containing the archived redo logs backed up after the control file.

But it’s not possible to use the CATALOG command for backup pieces stored in TAPE. This post explains how to add backuppieces stored in disk to the repository. From 10.1, there is an undocumented command that allows to catalog tape backup pieces:

RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE '[handle]';

Prerequisites

1. Use automatic channel configuration. It’s mandatory to configure one sbt_tape device channel in your rman automatic configuration parameters:

RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS '[MM parameters]'

2. It’s necessary to know the backup piece file name in the tape and the backup piece file needs to be available and accessible.

Steps

Once there is a tape channel configured for accessing to the tape, the rman CATALOG command can be used to insert in RMAN catalog the tape backup piece:

RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE '[handle]';

Examples

This is an example using Oracle Secure Backup (OSB):

1. Define a tape channel in the RMAN automatic configuration:

RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE'
  PARMS 'SBT_LIBRARY=/usr/local/oracle/backup/lib/libobk.so,ENV=(OB_MEDIA_FAMILY=RMAN-DEFAULT)';

2. Check that channel configuration is correct

RMAN> show all;
....
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/usr/local/oracle/backup/lib/libobk.so,ENV=(OB_MEDIA_FAMILY=RMAN-DEFAULT)';
....

3. Catalog the backup piece:

RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE '0pivagf8_1_1';

– The following will catalog a backuppiece on netbackup:

RMAN>CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' 
  PARMS 'ENV=(NB_ORA_CLASS=oraclebkup, SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so)';
RMAN> CATALOG DEVICE TYPE 'SBT_TAPE' BACKUPPIECE 'lij1qaa3_1_1';

You May Also Like