rman catalog disk start with ,磁带如何catalog 呢

GOAL

Starting with 10g, it's possible to use the rman CATALOG command to add backuppieces stored in 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 note explains how to add backuppieces stored in TAPE to the repository

SOLUTION

From 10.1, there is an undocumented command that allows to catalog tape backup pieces:

 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;

 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.

* How to

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:
  
       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';

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值