关注我们获得更多内容
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 Production PL/SQL Release 11.2.0.3.0 – Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 – Production NLSRTL Version 11.2.0.3.0 – Production
www.htz.pw > !lsb_release -a LSB Version: :core-3.0-amd64:core-3.0-ia32:core-3.0-noarch:graphics-3.0-amd64:graphics-3.0-ia32:graphics-3.0-noarch Distributor ID: RedHatEnterpriseAS Description: Red Hat Enterprise Linux AS release 4 (Nahant Update 8) Release: 4 Codename: NahantUpdate8 |
NBU环境
[root@nbu71 ~]# bpgetconfig -s nbu71 Master Linux, RedHat2.6 7.1.0 NetBackup 7.1 710000 /usr/openv/netbackup/bin Linux 2.6.18-308.el5 |
2,备份数据库
这里通过 NBU 发起对 ORACLE 的备份,略。
3,停客户端 NBU 进程
这里关闭客户端,本来是想手动通过 rman 来删除备份集,不更新 nbu 服务器上的备份信息,结果失败,就算关闭 nbu 客户端的进程,NBU 服务器上面的信息还是更新了。
[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 active oracle 6332 1 0 05:18 ? 00:00:00 usr/openv/netbackup/bin/bpcd -standalone oracle 6336 1 0 05:18 ? 00:00:00 usr/openv/netbackup/bin/bpcd -standalone Do you want this script to attempt to kill them? [y,n] (y) y Killing 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_2 channel ORA_MAINT_SBT_TAPE_2: SID=40 device type=SBT_TAPE channel ORA_MAINT_SBT_TAPE_2: Veritas NetBackup for Oracle – Release 7.1 (2011020316)
RMAN> delete backupset device type SBT_TAPE;
List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ——- ——- — — ———– ———– ———- 37 37 1 1 AVAILABLE SBT_TAPE bk_60_1_862117780 38 38 1 1 AVAILABLE SBT_TAPE bk_61_1_862117965 39 39 1 1 AVAILABLE SBT_TAPE bk_62_1_862117982 40 40 1 1 AVAILABLE SBT_TAPE bk_59_1_862117780 41 41 1 1 AVAILABLE SBT_TAPE al_63_1_862118319 42 42 1 1 AVAILABLE SBT_TAPE al_64_1_862118319 43 43 1 1 AVAILABLE SBT_TAPE cntrl_65_1_862118335
Do you really want to delete the above objects (enter YES or NO)? yes deleted backup piece backup piece handle=bk_60_1_862117780 RECID=37 STAMP=862117780 deleted backup piece backup piece handle=bk_61_1_862117965 RECID=38 STAMP=862117966 deleted backup piece backup piece handle=bk_62_1_862117982 RECID=39 STAMP=862117982 deleted backup piece backup piece handle=bk_59_1_862117780 RECID=40 STAMP=862117780 deleted backup piece backup piece handle=al_63_1_862118319 RECID=41 STAMP=862118319 deleted backup piece backup piece handle=al_64_1_862118319 RECID=42 STAMP=862118319 deleted backup piece backup piece handle=cntrl_65_1_862118335 RECID=43 STAMP=862118336 Deleted 7 objects
RMAN> list backup device type sbt_tape;
specification does not match any backup in the repository |
5 在 NBU 中查看备份信息
这里不能发现 orcl9i 的任何备份集的信息
[root@www.htz.pw ~]#bp.start_all Starting 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 orcl9i no 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 stored
RMAN> CATALOG DEVICE TYPE ‘SBT_TAPE’ BACKUPPIECE ‘bk_62_1_862117982’;
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) ORA-19870: error while restoring backup piece bk_62_1_862117982 ORA-19507: failed to retrieve sequential file, handle=”bk_62_1_862117982″, parms=”” ORA-27029: skgfrtrv: sbtrestore returned error ORA-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:11 RMAN-06209: List of failed objects RMAN-06211: ========================== RMAN-06212: Object Type Filename/Handle RMAN-06213: ————— ————————————————— RMAN-06214: Backup Piece bk_62_1_862117982 |
7 在 NBU 服务器上面查看备份文件信息
这里将备份文件存在在磁盘目录中的,对 ORACLE 客户端来说,是没有影响的,通道仍然是配置是 TAPE。这里可以看到 NBU 的备份文件还存在,只要备份文件还存在,一切都好办了。
[root@nbu71 nbu]# ls -lrt total 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.log Import phase 1 started Wed 14 May 2014 07:44:02 AM CST 07: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/nbu Import phase 2 started Wed 14 May 2014 07:01:06 AM CST DONE 0 INF – 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 CST INF – 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]# ls 1400000000 [root@nbu71 orcl9i]# cd 1400000000/ [root@nbu71 1400000000]# ls catstore orcl9i_oracle_database_1400020150_UBAK.f orcl9i_oracle_database_1400020351_UBAK.f orcl9i_oracle_database_1400020689_UBAK.f orcl9i_oracle_database_1400020149_UBAK orcl9i_oracle_database_1400020339_UBAK orcl9i_oracle_database_1400020688_UBAK orcl9i_oracle_database_1400020705_UBAK orcl9i_oracle_database_1400020149_UBAK.f orcl9i_oracle_database_1400020339_UBAK.f orcl9i_oracle_database_1400020688_UBAK.f orcl9i_oracle_database_1400020705_UBAK.f orcl9i_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: 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 |
10 整个测试结束 。
原创:黄廷忠。
投稿:有投稿意向技术人请在公众号对话框留言。
转载:意向文章下方留言。
更多精彩请关注 “数据和云” 公众号 。