Home > Oracle > HOW TO CATALOG TAPE BACKUP PIECES

HOW TO CATALOG TAPE BACKUP PIECES

 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');
  1. Anoop
    December 19, 2011 at 3:32 PM | #1

    Dear Sarith,

    its good to see your blog.

    Warm regards, P S Anoop

  2. December 19, 2011 at 10:26 PM | #2

    Anoop, Thank you very much…

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.