1、EMCNetworker备份测试报告Networker数据备份方案测试报告2016年03月1. 备份测试环境1.1测试内容1.文件备份:通过NetWorker备份软件以VTL方式和NAS方式进行数据备份,并进行文件数据备份和恢复;2.Oracle RMAN通过DDBoost方式直接进行数据库备份,测试Oracle自身备份和源端数据重删功能;3.Oracle Export通过NAS方式将数据直接写入DataDomain备份介质,模拟核心应用备份;4.在Vmware环境中通过vSphere VDPA备份/恢复虚拟机,验证虚拟化环境下的备份;5.查看整体数据去重比;6.DataDomain 远程数据
2、复制;1.2 测试环境备份服务器:CentOS 6.4 Oracle数据库服务器,CentOS,Oracle 11g 两台DD4200ESXi Server2. VTL方式进行数据备份测试目的1、测试DataDomain虚拟磁带库功能;2、测试Networker中VTL协议功能;3、测试VTL协议在光线链路上运行;预置条件Networker软件部署完成;DD设备正常;光线线路联通;测试步骤将DD设备虚拟成磁带库使用在NetWorker中识别虚拟磁带需要备份的文件在NetWorker中进行备份测试结果DataDomain虚拟磁带库可以模拟磁带库;Networker中VTL协议功能运行正常;在光线
3、链路上显现Lanfree备份;备 注3.Oracle RMAN 备份测试目的测试DDBoost功能与Oracle的结合;Oracle可以识别到DD直接进行备份;DDBOOST具有源端去重功能,可以实现快速数据备份。预置条件Oracle数据库开启归档,可以进行Rman备份;DD和DDBoost正常;测试步骤RMAN backup database;Starting backup at 31-MAR-16using target database control file instead of recovery catalogallocated channel: ORA_SBT_TAPE_1cha
4、nnel ORA_SBT_TAPE_1: SID=161 device type=SBT_TAPEchannel ORA_SBT_TAPE_1: Data Domain Boost APIchannel ORA_SBT_TAPE_1: starting full datafile backup setchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup setinput datafile file number=00001 name=/home/app/oracle/oradata/oratest/system01.dbfinput
5、datafile file number=00002 name=/home/app/oracle/oradata/oratest/sysaux01.dbfinput datafile file number=00005 name=/home/app/oracle/oradata/oratest/example01.dbfinput datafile file number=00003 name=/home/app/oracle/oradata/oratest/undotbs01.dbfinput datafile file number=00004 name=/home/app/oracle/
6、oradata/oratest/users01.dbfchannel ORA_SBT_TAPE_1: starting piece 1 at 31-MAR-16channel ORA_SBT_TAPE_1: finished piece 1 at 31-MAR-16piece handle=3br1s9ot_1_1 tag=TAG20160331T150916 comment=API Version 2.0,MMS Version 1.1.1.0channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35channel
7、ORA_SBT_TAPE_1: starting full datafile backup setchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup setincluding current control file in backup setincluding current SPFILE in backup setchannel ORA_SBT_TAPE_1: starting piece 1 at 31-MAR-16channel ORA_SBT_TAPE_1: finished piece 1 at 31-MAR-16pie
8、ce handle=3cr1s9q0_1_1 tag=TAG20160331T150916 comment=API Version 2.0,MMS Version 1.1.1.0channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03Finished backup at 31-MAR-16RMAN list backup summary;=Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag- - - - - - - - - -5
9、7 B F A SBT_TAPE 31-MAR-16 1 1 NO TAG20160331T09404358 B F A SBT_TAPE 31-MAR-16 1 1 NO TAG20160331T09404359 B F A SBT_TAPE 31-MAR-16 1 1 NO TAG20160331T09435160 B F A SBT_TAPE 31-MAR-16 1 1 NO TAG20160331T09435161 B F A SBT_TAPE 31-MAR-16 1 1 NO TAG20160331T15091662 B F A SBT_TAPE 31-MAR-16 1 1 NO T
10、AG20160331T150916BS Key Type LV Size Device Type Elapsed Time Completion Time- - - - - - -59 Full 1.37G SBT_TAPE 00:00:14 31-MAR-16 BP Key: 72 Status: AVAILABLE Compressed: NO Tag: TAG20160331T094351 Handle: 39r1rmmn_1_1 Media: ddstorage List of Datafiles in backup set 59 File LV Type Ckp SCN Ckp Ti
11、me Name - - - - - - 1 Full 1981918 31-MAR-16 /home/app/oracle/oradata/oratest/system01.dbf 2 Full 1981918 31-MAR-16 /home/app/oracle/oradata/oratest/sysaux01.dbf 3 Full 1981918 31-MAR-16 /home/app/oracle/oradata/oratest/undotbs01.dbf 4 Full 1981918 31-MAR-16 /home/app/oracle/oradata/oratest/users01.
12、dbf 5 Full 1981918 31-MAR-16 /home/app/oracle/oradata/oratest/example01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time- - - - - - -60 Full 10.00M SBT_TAPE 00:00:03 31-MAR-16 BP Key: 73 Status: AVAILABLE Compressed: NO Tag: TAG20160331T094351 Handle: 3ar1rmn6_1_1 Media: ddstorage SPF
13、ILE Included: Modification time: 31-MAR-16 SPFILE db_unique_name: ORATEST Control File Included: Ckp SCN: 1981940 Ckp time: 31-MAR-16BS Key Type LV Size Device Type Elapsed Time Completion Time- - - - - - -61 Full 1.37G SBT_TAPE 00:00:27 31-MAR-16 BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG
14、20160331T150916 Handle: 3br1s9ot_1_1 Media: ddstorage List of Datafiles in backup set 61 File LV Type Ckp SCN Ckp Time Name - - - - - - 1 Full 2008080 31-MAR-16 /home/app/oracle/oradata/oratest/system01.dbf 2 Full 2008080 31-MAR-16 /home/app/oracle/oradata/oratest/sysaux01.dbf 3 Full 2008080 31-MAR-
15、16 /home/app/oracle/oradata/oratest/undotbs01.dbf 4 Full 2008080 31-MAR-16 /home/app/oracle/oradata/oratest/users01.dbf 5 Full 2008080 31-MAR-16 /home/app/oracle/oradata/oratest/example01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time- - - - - - -62 Full 10.00M SBT_TAPE 00:00:03 31-
16、MAR-16 BP Key: 75 Status: AVAILABLE Compressed: NO Tag: TAG20160331T150916 Handle: 3cr1s9q0_1_1 Media: ddstorage SPFILE Included: Modification time: 31-MAR-16 SPFILE db_unique_name: ORATEST Control File Included: Ckp SCN: 2008863 Ckp time: 31-MAR-16RMAN测试结果Oracle使用Rman识别到DD,并可以进行数据备份备 注 4. NAS方式进行Or
17、acle Export 数据备份测试目的验证NAS功能,Oracle可以直接将数据Export到DD预置条件Oracle正常;DD正常;测试步骤将DD通过NAS方式NFS将备份空间共享给Linux主机,Oracle 使用Export命令将数据备份到DD上面。再DD上创建NFS共享oraclerhelser2 $ df -hFilesystem Size Used Avail Use% Mounted on/dev/mapper/VolGroup-lv_root 50G 16G 32G 34% /tmpfs 4.0G 597M 3.5G 15% /dev/shm/dev/sda1 485M 39
18、M 421M 9% /boot/dev/mapper/VolGroup-lv_home 81G 13G 64G 17% /home/usr/local/src/rhel-server-6.4-x86_64-dvdED2000.COM.iso 3.5G 3.5G 0 100% /media10.32.32.111:/data/col1/backup 21T 54G 21T 1% /backuporaclerhelser2 $ oraclerhelser2 $ expdp system/password directory=dump_test_dir dumpfile=test1545.dmpEx
19、port: Release 11.2.0.4.0 - Production on Thu Mar 31 15:45:35 2016Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing
20、 optionsStarting SYSTEM.SYS_EXPORT_SCHEMA_01: system/* directory=dump_test_dir dumpfile=test1545.dmp Estimate in progress using BLOCKS method.Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 320 KBProcessing object type SCHEMA_EXPORT/USERProcessing object ty
21、pe SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/SYNONYM/SYNONYMProcessing object type SCHEMA_EXPORT/TYPE/TYPE_SPECProcessing
22、 object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/PRE_TABLE_ACTIONProcessing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANTProcessing object type SCHEMA_EXPORT/TABLE/COMMENTProcessing object type SCH
23、EMA_EXPORT/PACKAGE/PACKAGE_SPECProcessing object type SCHEMA_EXPORT/FUNCTION/FUNCTIONProcessing object type SCHEMA_EXPORT/PROCEDURE/PROCEDUREProcessing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPECProcessing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTIONProcess
24、ing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDUREProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/VIEW/VIEWProce
25、ssing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANTProcessing object type SCHEMA_EXPORT/VIEW/COMMENTProcessing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODYProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/TRIGGERProcessin
26、g object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTIONProcessing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA. . exported SYSTEM.REPCAT$_AUDIT_ATTRIBUTE 6.328 KB 2 rows. . exported SYSTEM.REPCAT$_OBJECT_TYPES 6.882 KB 28 rows
27、. . exported SYSTEM.REPCAT$_RESOLUTION_METHOD 5.835 KB 19 rows. . exported SYSTEM.REPCAT$_TEMPLATE_STATUS 5.484 KB 3 rows. . exported SYSTEM.REPCAT$_TEMPLATE_TYPES 6.289 KB 2 rows. . exported SYSTEM.DEF$_AQCALL 0 KB 0 rows. . exported SYSTEM.DEF$_AQERROR 0 KB 0 rows. . exported SYSTEM.DEF$_CALLDEST
28、0 KB 0 rows. . exported SYSTEM.DEF$_DEFAULTDEST 0 KB 0 rows. . exported SYSTEM.DEF$_DESTINATION 0 KB 0 rows. . exported SYSTEM.DEF$_ERROR 0 KB 0 rows. . exported SYSTEM.DEF$_LOB 0 KB 0 rows. . exported SYSTEM.DEF$_ORIGIN 0 KB 0 rows. . exported SYSTEM.DEF$_PROPAGATOR 0 KB 0 rows. . exported SYSTEM.D
29、EF$_PUSHED_TRANSACTIONS 0 KB 0 rows. . exported SYSTEM.MVIEW$_ADV_INDEX 0 KB 0 rows. . exported SYSTEM.MVIEW$_ADV_PARTITION 0 KB 0 rows. . exported SYSTEM.REPCAT$_AUDIT_COLUMN 0 KB 0 rows. . exported SYSTEM.REPCAT$_COLUMN_GROUP 0 KB 0 rows. . exported SYSTEM.REPCAT$_CONFLICT 0 KB 0 rows. . exported
30、SYSTEM.REPCAT$_DDL 0 KB 0 rows. . exported SYSTEM.REPCAT$_EXCEPTIONS 0 KB 0 rows. . exported SYSTEM.REPCAT$_EXTENSION 0 KB 0 rows. . exported SYSTEM.REPCAT$_FLAVORS 0 KB 0 rows. . exported SYSTEM.REPCAT$_FLAVOR_OBJECTS 0 KB 0 rows. . exported SYSTEM.REPCAT$_GENERATED 0 KB 0 rows. . exported SYSTEM.REPCAT$_GROUPED_COLUMN 0 KB 0 rows. . exported SYSTEM.REPCAT$_I
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1