Thursday, March 6, 2014

RMAN Catalog backuppiece located on Tape

I've recorded backups on tape to RMAN repository several times already, but every next time I needed to do that I was searching through notes to find proper procedure.

This time I will note procedure in form of the blog post.

Note!
Test is performed on Oracle version 11.1.0.7.


These were my unsuccessful attempts:

RMAN> run
2> {
3> allocate channel c1 device type 'sbt_tape';
4> send 'NSR_ENV=(NSR_SERVER=backup_server,NSR_CLIENT=oracle_client,NSR_DATA_VOLUME=OrclPool)';
5> catalog  backuppiece 'ARCH_ORCL_rep2dod5_s128878_p1';
6> }

allocated channel: c1
channel c1: SID=321 device type=SBT_TAPE
channel c1: NMDA Oracle v1.1.0

sent command to channel: c1

ORA-19870: error while restoring backup piece /u01/app/orcl11/product/11.1.0/db_1/dbs/ARCH_ORCL_rep2dod5_s128878_p1
ORA-19505: failed to identify file "/u01/app/orcl11/product/11.1.0/db_1/dbs/ARCH_ORCL_rep2dod5_s128878_p1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 03/05/2014 15:42:23
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece    /u01/app/orcl11/product/11.1.0/db_1/dbs/ARCH_ORCL_rep2dod5_s128878_p1

and

RMAN> run
2> {
3> allocate channel c1 device type 'sbt_tape';
4> send 'NSR_ENV=(NSR_SERVER=backup_server,NSR_CLIENT=oracle_client,NSR_DATA_VOLUME=OrclPool)';
5> catalog device type 'sbt_tape' backuppiece 'ARCH_ORCL_rep2dod5_s128878_p1';
6> }

allocated channel: c1
channel c1: SID=321 device type=SBT_TAPE
channel c1: NMDA Oracle v1.1.0

sent command to channel: c1

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 03/05/2014 15:36:57
RMAN-06470: DEVICE TYPE is supported only when automatic channels are used



How to catalog backuppiece on tape...


Add SBT_TAPE configuration:
RMAN> configure default device type to 'SBT_TAPE';
RMAN> configure channel device type 'SBT_TAPE' send '[MML PARAMETERS]';

Catalog backuppiece:
RMAN> catalog device type 'SBT_TAPE' backuppiece '[BACKUP NAME]';

To clear configuration:
RMAN> configure channel device type ‘SBT_TAPE’ clear;


My example:

Set configuration:
RMAN> configure default device type to 'SBT_TAPE';
RMAN> configure channel device type 'SBT_TAPE'
2> send 'NSR_ENV=(NSR_SERVER=backup_server,NSR_CLIENT=oracle_client,NSR_DATA_VOLUME=OrclPool)';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' SEND  'NSR_ENV=(NSR_SERVER=backup_server,NSR_CLIENT=oracle_client,NSR_DATA_VOLUME=OrclPool)';
new RMAN configuration parameters are successfully stored

Catalog backuppiece:
RMAN> catalog device type 'SBT_TAPE' backuppiece 'ARCH_ORCL_rep2dod5_s128878_p1';

allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=321 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: NMDA Oracle v1.1.0
cataloged backup piece
backup piece handle=ARCH_ORCL_rep2dod5_s128878_p1 RECID=127894 STAMP=841419878

Clear configuration:
RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' SEND  'NSR_ENV=(NSR_SERVER=backup_server,NSR_CLIENT=oracle_client,NSR_DATA_VOLUME=OrclPool)';
old RMAN configuration parameters are successfully deleted



2 comments: