Archive

Archive for May, 2011

HOW TO CATALOG TAPE BACKUP PIECES

May 15, 2011 2 comments
 Applicable Versions: Release 10.1 to 11.1
Starting with 10g, it's possible to use the rman CATALOG command to add backup 
pieces stored in DISK to the rman repository.

You may need to catalog backup pieces in different situations like
. Copy or move a backup piece with OS command
. The RMAN Metadata information was removed and Piece still exist
. Take NOCATALOG Backup on one server and moved to another server fro restore
. Recreate controlfile and lost all backup information
. When controlfile autobackup is off, and you backup the controlfile and then 
archivelog file. In this case you can restore the controlfile and not 
all archivelogs.

Catalog from TAPE is not possible, But there is undocumented command that 
allows to catalog TAPE backup piece

From 10.1 Onwards 

rman> catalog device type 'SBT_TAPE' backuppiece  'handle';
To apply this command we have to do automatic channel configuration.
Its mandatory to do automatic configuration.
rman> show all;
rman> configure channel device type 'SBT_TAPE' parms <mml parameters>
example: configure channel device type 'SBT_TAPE' parms 'env=(env_client=
'xxx', env_server='xxx');
Follow

Get every new post delivered to your Inbox.