我们的文章会在微信公众号IT民工的龙马人生和博客网站( www.htz.pw )同步更新 ，欢迎关注收藏，也欢迎大家转载，但是请在文章开始地方标注文章出处，谢谢！
由于博客中有大量代码，通过页面浏览效果更佳。
RMAN CATALOG命令手动注册磁带库中的备份片
ORACLE官方文档中介绍CATALOG命令只能注册在磁盘中的备份片，在现在多数环境中备份时，备份集都是放到磁带库中，那么CATALOG命令真就不支持注册磁带库中的备份片？其实是支持的，MOS也有相当的文档介绍。下面就是11.2.0.3+NBU 7.1的环境中来测试一把。
1，环境介绍
这里由于要使用磁带，所以使用NBU来备份ORACLE数据库。
数据库环境
www.htz.pw > select * from V$version;BANNER——————————————————————————–Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit ProductionPL/SQL Release 11.2.0.3.0 – ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 – ProductionNLSRTL Version 11.2.0.3.0 – Productionwww.htz.pw > !lsb_release -aLSB Version: :core-3.0-amd64:core-3.0-ia32:core-3.0-noarch:graphics-3.0-amd64:graphics-3.0-ia32:graphics-3.0-noarchDistributor ID: RedHatEnterpriseASDescription: Red Hat Enterprise Linux AS release 4 (Nahant Update 8)Release: 4Codename: NahantUpdate8
NBU环境
[root@nbu71 ~]# bpgetconfig -s nbu71MasterLinux, RedHat2.67.1.0NetBackup7.1710000/usr/openv/netbackup/binLinux 2.6.18-308.el5
2，备份数据库
这里通过NBU发起对ORACLE的备份，略
3，停客户端NBU进程
这里关闭客户端，本来是想手动通过rman来删除备份集，不更新nbu服务器上的备份信息，结果失败，就算关闭nbu客户端的进程，NBU服务器上面的信息还是更新了。
[root@www.htz.pw ~]#bp.kill_allLooking for NetBackup processes that need to be terminated.Looking for more NetBackup processes that need to be terminated.Stopping bpcd…Stopping vnetd…The following processes are still activeoracle 6332 1 0 05:18 ? 00:00:00 /usr/openv/netbackup/bin/bpcd -standaloneoracle 6336 1 0 05:18 ? 00:00:00 /usr/openv/netbackup/bin/bpcd -standaloneDo you want this script to attempt to kill them? [y,n] (y) yKilling remaining processes…Waiting for processes to terminate…
4，在ORACLE中删除备份集
这里需要注意在RMAN中通过delete删除备份集，会自动在NBU中删除相应的备份信息，但是备份集是没有真实的删除的，在后面也可以看到。
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE SBT_TAPE;allocated channel: ORA_MAINT_SBT_TAPE_2channel ORA_MAINT_SBT_TAPE_2: SID=40 device type=SBT_TAPEchannel ORA_MAINT_SBT_TAPE_2: Veritas NetBackup for Oracle – Release 7.1 (2011020316)RMAN> delete backupset device type SBT_TAPE;List of Backup PiecesBP Key BS Key Pc# Cp# Status Device Type Piece Name——- ——- — — ———– ———– ———-37 37 1 1 AVAILABLE SBT_TAPE bk_60_1_86211778038 38 1 1 AVAILABLE SBT_TAPE bk_61_1_86211796539 39 1 1 AVAILABLE SBT_TAPE bk_62_1_86211798240 40 1 1 AVAILABLE SBT_TAPE bk_59_1_86211778041 41 1 1 AVAILABLE SBT_TAPE al_63_1_86211831942 42 1 1 AVAILABLE SBT_TAPE al_64_1_86211831943 43 1 1 AVAILABLE SBT_TAPE cntrl_65_1_862118335Do you really want to delete the above objects (enter YES or NO)? yesdeleted backup piecebackup piece handle=bk_60_1_862117780 RECID=37 STAMP=862117780deleted backup piecebackup piece handle=bk_61_1_862117965 RECID=38 STAMP=862117966deleted backup piecebackup piece handle=bk_62_1_862117982 RECID=39 STAMP=862117982deleted backup piecebackup piece handle=bk_59_1_862117780 RECID=40 STAMP=862117780deleted backup piecebackup piece handle=al_63_1_862118319 RECID=41 STAMP=862118319deleted backup piecebackup piece handle=al_64_1_862118319 RECID=42 STAMP=862118319deleted backup piecebackup piece handle=cntrl_65_1_862118335 RECID=43 STAMP=862118336Deleted 7 objectsRMAN> list backup device type sbt_tape;specification does not match any backup in the repository
5、在NBU中查看备份信息
这里不能发现orcl9i的任何备份集的信息
[root@www.htz.pw ~]#bp.start_allStarting vnetd…Starting bpcd…Starting nbftclnt…Starting bmrbd…
从NBU中已经找不到任何与orcl9i客户端相关的备份集，这里有点想不到，NBU客户端都已经关闭了，为什么RMAN中的操作还是更新了NBU服务器上面的东西
[root@www.htz.pw ~]#bplist -S nbu71 -C orcl9i -t 4 -R -l /EXIT STATUS 227: no entity was found[root@nbu71 nbu]# bpimagelist -client orcl9ino entity was found
6，手动注册备份集
这里会看到注册备份集会报错，因为在NBU中就找不到此备份文件的信息
RMAN> CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NB_ORA_SERV=nbu71,NB_ORA_CLIENT=orcl9i)’;old RMAN configuration parameters:CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ PARMS ‘NB_ORA_SERV=nbu71,NB_ORA_CLIENT=orcl9i’;new RMAN configuration parameters:CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NB_ORA_SERV=nbu71,NB_ORA_CLIENT=orcl9i)’;new RMAN configuration parameters are successfully storedRMAN> CATALOG DEVICE TYPE ‘SBT_TAPE’ BACKUPPIECE ‘bk_62_1_862117982’;allocated channel: ORA_SBT_TAPE_1channel ORA_SBT_TAPE_1: SID=41 device type=SBT_TAPEchannel ORA_SBT_TAPE_1: Veritas NetBackup for Oracle – Release 7.1 (2011020316)ORA-19870: error while restoring backup piece bk_62_1_862117982ORA-19507: failed to retrieve sequential file, handle=”bk_62_1_862117982″, parms=””ORA-27029: skgfrtrv: sbtrestore returned errorORA-19511: Error received from media manager layer, error text:Backup file <bk_62_1_862117982> not found in NetBackup catalogRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of catalog command at 10/28/2014 05:26:11RMAN-06209: List of failed objectsRMAN-06211: ==========================RMAN-06212: Object Type Filename/HandleRMAN-06213: ————— —————————————————RMAN-06214: Backup Piece bk_62_1_862117982
7、在NBU服务器上面查看备份文件信息
这里将备份文件存在在磁盘目录中的，对ORACLE客户端来说，是没有影响的，通道仍然是配置是TAPE。这里可以看到NBU的备份文件还存在，只要备份文件还存在，一切都好办了
[root@nbu71 nbu]# ls -lrttotal 7008276-rw——- 1 root root 4096 May 14 06:29 orcl9i_1400020149_C1_HDR.1400020149.info-rw——- 1 root root 4096 May 14 06:29 orcl9i_1400020149_C1_HDR.1400020149.img-rw——- 1 root root 4096 May 14 06:29 orcl9i_1400020150_C1_HDR.1400020150.info-rw——- 1 root root 4096 May 14 06:29 orcl9i_1400020150_C1_HDR.1400020150.img-rw——- 1 root root 4096 May 14 06:32 orcl9i_1400020150_C1_F1.1400020150.info-rw——- 1 root root 1824817152 May 14 06:32 orcl9i_1400020150_C1_F1.1400020150.img-rw——- 1 root root 4096 May 14 06:32 orcl9i_1400020339_C1_HDR.1400020339.info-rw——- 1 root root 4096 May 14 06:32 orcl9i_1400020339_C1_HDR.1400020339.img-rw——- 1 root root 10780672 May 14 06:32 orcl9i_1400020339_C1_F1.1400020339.img-rw——- 1 root root 4096 May 14 06:32 orcl9i_1400020339_C1_F1.1400020339.info-rw——- 1 root root 4096 May 14 06:32 orcl9i_1400020351_C1_HDR.1400020351.info-rw——- 1 root root 4096 May 14 06:32 orcl9i_1400020351_C1_HDR.1400020351.img-rw——- 1 root root 294912 May 14 06:32 orcl9i_1400020351_C1_F1.1400020351.img-rw——- 1 root root 4096 May 14 06:32 orcl9i_1400020351_C1_F1.1400020351.info-rw——- 1 root root 4096 May 14 06:37 orcl9i_1400020149_C1_F1.1400020149.info-rw——- 1 root root 5321818112 May 14 06:37 orcl9i_1400020149_C1_F1.1400020149.img-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020688_C1_HDR.1400020688.info-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020688_C1_HDR.1400020688.img-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020688_C1_F1.1400020688.info-rw——- 1 root root 557056 May 14 06:38 orcl9i_1400020688_C1_F1.1400020688.img-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020689_C1_HDR.1400020689.info-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020689_C1_HDR.1400020689.img-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020689_C1_F1.1400020689.info-rw——- 1 root root 294912 May 14 06:38 orcl9i_1400020689_C1_F1.1400020689.img-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020705_C1_HDR.1400020705.info-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020705_C1_HDR.1400020705.img-rw——- 1 root root 4096 May 14 06:38 orcl9i_1400020705_C1_F1.1400020705.info-rw——- 1 root root 10780672 May 14 06:38 orcl9i_1400020705_C1_F1.1400020705.img
8、将备份文件重新导致NBU
[root@nbu71 images]# pwd/usr/openv/netbackup/db/images[root@nbu71 images]# rm -rf orcl9i[root@nbu71 images]# bpimport -create_db_info -id /opt/mhvtl/nbu/ -L /tmp/import.log[root@nbu71 images]# cat /tmp/import.logImport phase 1 started Wed 14 May 2014 07:44:02 AM CST07:44:02 INF – Create DB information for path /opt/mhvtl/nbu/.07:44:02 INF – Initiation of bpdm process to phase 1 import path /opt/mhvtl/nbu/ was successful.07:44:02 INF – Recreating image information for client orcl9i, policy orcl9i_oracle_database, and schedule Default-Application-Backup, done on 05/14/2014 06:29:09.07:44:02 INF – Recreating copy 1, fragment 1 information for image.07:44:02 INF – Recreating image information for client orcl9i, policy orcl9i_oracle_database, and schedule Default-Application-Backup, done on 05/14/2014 06:29:10.07:44:02 INF – Recreating copy 1, fragment 1 information for image.07:44:02 INF – Recreating image information for client orcl9i, policy orcl9i_oracle_database, and schedule Default-Application-Backup, done on 05/14/2014 06:32:19.07:44:02 INF – Recreating copy 1, fragment 1 information for image.07:44:03 INF – Recreating image information for client orcl9i, policy orcl9i_oracle_database, and schedule Default-Application-Backup, done on 05/14/2014 06:32:31.07:44:03 INF – Recreating copy 1, fragment 1 information for image.07:44:03 INF – Recreating image information for client orcl9i, policy orcl9i_oracle_database, and schedule Default-Application-Backup, done on 05/14/2014 06:38:08.07:44:03 INF – Recreating copy 1, fragment 1 information for image.07:44:03 INF – Recreating image information for client orcl9i, policy orcl9i_oracle_database, and schedule Default-Application-Backup, done on 05/14/2014 06:38:09.07:44:03 INF – Recreating copy 1, fragment 1 information for image.07:44:03 INF – Recreating image information for client orcl9i, policy orcl9i_oracle_database, and schedule Default-Application-Backup, done on 05/14/2014 06:38:25.07:44:03 INF – Recreating copy 1, fragment 1 information for image.07:44:03 INF – Creation of database information for import of path /opt/mhvtl/nbu/ complete.[root@nbu71 1400000000]# bpimport -client orcl9i -Bidfile /opt/mhvtl/nbuImport phase 2 started Wed 14 May 2014 07:01:06 AM CSTDONE 0INF – Found no images matching the selection criteria that were ready for phase 2 import.[root@nbu71 images]# bpimport -id /opt/mhvtl/nbu/Import phase 2 started Wed 14 May 2014 07:45:19 AM CSTINF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020705), path /opt/mhvtl/nbu/, created on 05/14/2014 06:38:25.INF – Import of policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020705) was successfully completed.INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020689), path /opt/mhvtl/nbu/, created on 05/14/2014 06:38:09.INF – Import of policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020689) was successfully completed.INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020688), path /opt/mhvtl/nbu/, created on 05/14/2014 06:38:08.INF – Import of policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020688) was successfully completed.INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020351), path /opt/mhvtl/nbu/, created on 05/14/2014 06:32:31.INF – Import of policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020351) was successfully completed.INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020339), path /opt/mhvtl/nbu/, created on 05/14/2014 06:32:19.INF – Import of policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020339) was successfully completed.INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020150), path /opt/mhvtl/nbu/, created on 05/14/2014 06:29:10.INF – Import of policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020150) was successfully completed.INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020149), path /opt/mhvtl/nbu/, created on 05/14/2014 06:29:09.INF – Import of policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020149) was successfully completed.INF – Imported 7 of 7 images successfully.[root@nbu71 images]# cd orcl9i[root@nbu71 orcl9i]# ls1400000000[root@nbu71 orcl9i]# cd 1400000000/[root@nbu71 1400000000]# lscatstore orcl9i_oracle_database_1400020150_UBAK.f orcl9i_oracle_database_1400020351_UBAK.f orcl9i_oracle_database_1400020689_UBAK.forcl9i_oracle_database_1400020149_UBAK orcl9i_oracle_database_1400020339_UBAK orcl9i_oracle_database_1400020688_UBAK orcl9i_oracle_database_1400020705_UBAKorcl9i_oracle_database_1400020149_UBAK.f orcl9i_oracle_database_1400020339_UBAK.f orcl9i_oracle_database_1400020688_UBAK.f orcl9i_oracle_database_1400020705_UBAK.forcl9i_oracle_database_1400020150_UBAK orcl9i_oracle_database_1400020351_UBAK orcl9i_oracle_database_1400020689_UBAK tmp
9、RMAN重新注册备份片
使用bplist查看备份文件信息，已经可以看到orcl9i客户端备份片的名字了，NBU备份ORACLE，其实也是备份的文件，RMAN备份使用BACKUP备份生成备份片，NBU在备份备份片。这里我们看到的是备份片的名字。
[root@nbu71 1400000000]# bplist -C orcl9i -t 4 -R -l /-rw-rw—- oracle oinstall 10747904 Oct 28 2014 /cntrl_65_1_862118335-rw-rw—- oracle oinstall 262144 Oct 28 2014 /al_64_1_862118319-rw-rw—- oracle oinstall 524288 Oct 28 2014 /al_63_1_862118319-rw-rw—- oracle oinstall 262144 Oct 28 2014 /bk_62_1_862117982-rw-rw—- oracle oinstall 10747904 Oct 28 2014 /bk_61_1_862117965-rw-rw—- oracle oinstall 1782016K Oct 28 2014 /bk_60_1_862117780-rw-rw—- oracle oinstall 5197056K Oct 28 2014 /bk_59_1_862117780
注册备份片
RMAN> CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NB_ORA_SERV=nbu71,NB_ORA_CLIENT=orcl9i)’;old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NB_ORA_SERV=nbu71,NB_ORA_CLIENT=orcl9i)’; new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NB_ORA_SERV=nbu71,NB_ORA_CLIENT=orcl9i)’; new RMAN configuration parameters are successfully stored released channel: ORA_SBT_TAPE_1 RMAN> CATALOG DEVICE TYPE ‘SBT_TAPE’ BACKUPPIECE ‘cntrl_65_1_862118335’; allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=41 device type=SBT_TAPE channel ORA_SBT_TAPE_1: Veritas NetBackup for Oracle – Release 7.1 (2011020316) cataloged backup piece backup piece handle=cntrl_65_1_862118335 RECID=44 STAMP=862122687
RMAN> CATALOG DEVICE TYPE ‘SBT_TAPE’ BACKUPPIECE ‘al_64_1_862118319’;
released channel: ORA_SBT_TAPE_1 allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=41 device type=SBT_TAPE channel ORA_SBT_TAPE_1: Veritas NetBackup for Oracle – Release 7.1 (2011020316) cataloged backup piece backup piece handle=al_64_1_862118319 RECID=45 STAMP=862122714
……………………………
现在可以在控制文件中查看到相关的备份信息了
RMAN> list backup device type sbt_tape; List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time——- —- — ———- ———– ———— —————44 Full Unknown SBT_TAPE 00:00:00 28-OCT-14 BP Key: 44 Status: AVAILABLE Compressed: NO Tag: TAG20141028T051855Handle: cntrl_65_1_862118335 Media: /opt/mhvtl/nbu//orcl9i_1400020705_C1_F1Control File Included: Ckp SCN: 6199953 Ckp time: 28-OCT-14BS Key Size Device Type Elapsed Time Completion Time——- ———- ———– ———— —————45 Unknown SBT_TAPE 00:00:00 28-OCT-14 BP Key: 45 Status: AVAILABLE Compressed: NO Tag: TAG20141028T051838Handle: al_64_1_862118319 Media: /opt/mhvtl/nbu//orcl9i_1400020689_C1_F1List of Archived Logs in backup set 45Thrd Seq Low SCN Low Time Next SCN Next Time—- ——- ———- ——— ———- ———1 1293 6199886 28-OCT-14 6199914 28-OCT-14BS Key Size Device Type Elapsed Time Completion Time——- ———- ———– ———— —————46 Unknown SBT_TAPE 00:00:00 28-OCT-14 BP Key: 46 Status: AVAILABLE Compressed: NO Tag: TAG20141028T051838Handle: al_63_1_862118319 Media: /opt/mhvtl/nbu//orcl9i_1400020688_C1_F1List of Archived Logs in backup set 46Thrd Seq Low SCN Low Time Next SCN Next Time—- ——- ———- ——— ———- ———1 1292 6199366 28-OCT-14 6199886 28-OCT-14BS Key Type LV Size Device Type Elapsed Time Completion Time——- —- — ———- ———– ———— —————47 Incr 0 Unknown SBT_TAPE 00:00:00 28-OCT-14 BP Key: 47 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL0Handle: bk_62_1_862117982 Media: /opt/mhvtl/nbu//orcl9i_1400020351_C1_F1SPFILE Included: Modification time: 28-OCT-14SPFILE db_unique_name: ORCL1123BS Key Type LV Size Device Type Elapsed Time Completion Time——- —- — ———- ———– ———— —————48 Incr 0 Unknown SBT_TAPE 00:00:00 28-OCT-14 BP Key: 48 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL0Handle: bk_61_1_862117965 Media: /opt/mhvtl/nbu//orcl9i_1400020339_C1_F1Control File Included: Ckp SCN: 6199571 Ckp time: 28-OCT-14BS Key Type LV Size Device Type Elapsed Time Completion Time——- —- — ———- ———– ———— —————49 Incr 0 Unknown SBT_TAPE 00:00:00 28-OCT-14 BP Key: 50 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL0Handle: bk_60_1_862117780 Media: /opt/mhvtl/nbu//orcl9i_1400020150_C1_F1List of Datafiles in backup set 49File LV Type Ckp SCN Ckp Time Name—- — —- ———- ——— —-1 0 Incr 6199448 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/system01.dbf2 0 Incr 6199448 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/sysaux01.dbf6 0 Incr 6199448 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/htz01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time——- —- — ———- ———– ———— —————50 Incr 0 Unknown SBT_TAPE 00:00:00 28-OCT-14 BP Key: 51 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL0Handle: bk_59_1_862117780 Media: /opt/mhvtl/nbu//orcl9i_1400020149_C1_F1List of Datafiles in backup set 50File LV Type Ckp SCN Ckp Time Name—- — —- ———- ——— —-3 0 Incr 6199447 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/undotbs01.dbf5 0 Incr 6199447 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/undotbs2.dbf
------------------作者介绍-----------------------
姓名：黄廷忠
现就职：Oracle中国高级服务团队
曾就职：OceanBase、云和恩墨、东方龙马等
电话、微信、QQ：18081072613
个人博客: (http://www.htz.pw)
CSDN地址: (https://blog.csdn.net/wwwhtzpw)
博客园地址: (https://www.cnblogs.com/www-htz-pw)
