RMAN CATALOG命令手动注册磁带库中的备份片

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 – Production www.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

[root@nbu71 ~]# bpgetconfig -s nbu71MasterLinux, RedHat2.67.1.0NetBackup7.1710000/usr/openv/netbackup/binLinux 2.6.18-308.el5

[root@www.htz.pw ~]#bp.kill_all Looking 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…

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_862118335 Do 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 objects RMAN> list backup device type sbt_tape; specification does not match any backup in the repository

[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

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 stored RMAN> 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 catalog RMAN-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

[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

[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

[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: TAG20141028T051855 Handle: cntrl_65_1_862118335 Media: /opt/mhvtl/nbu//orcl9i_1400020705_C1_F1 Control File Included: Ckp SCN: 6199953 Ckp time: 28-OCT-14 BS 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: TAG20141028T051838 Handle: al_64_1_862118319 Media: /opt/mhvtl/nbu//orcl9i_1400020689_C1_F1 List of Archived Logs in backup set 45 Thrd Seq Low SCN Low Time Next SCN Next Time —- ——- ———- ——— ———- ——— 1 1293 6199886 28-OCT-14 6199914 28-OCT-14 BS 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: TAG20141028T051838 Handle: al_63_1_862118319 Media: /opt/mhvtl/nbu//orcl9i_1400020688_C1_F1 List of Archived Logs in backup set 46 Thrd Seq Low SCN Low Time Next SCN Next Time —- ——- ———- ——— ———- ——— 1 1292 6199366 28-OCT-14 6199886 28-OCT-14 BS 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_LEVEL0 Handle: bk_62_1_862117982 Media: /opt/mhvtl/nbu//orcl9i_1400020351_C1_F1 SPFILE Included: Modification time: 28-OCT-14 SPFILE db_unique_name: ORCL1123 BS 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_LEVEL0 Handle: bk_61_1_862117965 Media: /opt/mhvtl/nbu//orcl9i_1400020339_C1_F1 Control File Included: Ckp SCN: 6199571 Ckp time: 28-OCT-14 BS 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_LEVEL0 Handle: bk_60_1_862117780 Media: /opt/mhvtl/nbu//orcl9i_1400020150_C1_F1 List of Datafiles in backup set 49 File LV Type Ckp SCN Ckp Time Name —- — —- ———- ——— —- 1 0 Incr 6199448 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/system01.dbf 2 0 Incr 6199448 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/sysaux01.dbf 6 0 Incr 6199448 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/htz01.dbf BS 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_LEVEL0 Handle: bk_59_1_862117780 Media: /opt/mhvtl/nbu//orcl9i_1400020149_C1_F1 List of Datafiles in backup set 50 File LV Type Ckp SCN Ckp Time Name —- — —- ———- ——— —- 3 0 Incr 6199447 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/undotbs01.dbf 5 0 Incr 6199447 28-OCT-14 /oracle/app/oracle/oradata/orcl1123/undotbs2.dbf