EMC-Networker備份測(cè)試報(bào)告

1、白鴿學(xué)吧Networker數(shù)據(jù)備份方案測(cè)試報(bào)告2016年03月1. 備份測(cè)試環(huán)境1.1測(cè)試內(nèi)容文件備份：通過(guò)NetWorker備份軟件以VTL方式和NAS方式進(jìn)行數(shù)據(jù)備份，并進(jìn)行文件數(shù)據(jù)備份和恢復(fù)；Oracle RMAN通過(guò)DDBoost方式直接進(jìn)行數(shù)據(jù)庫(kù)備份，測(cè)試Oracle自身備份和源端數(shù)據(jù)重刪功能；Oracle Export通過(guò)NAS方式將數(shù)據(jù)直接寫入DataDomain備份介質(zhì)，模擬核心應(yīng)用備份；在Vmware環(huán)境中通過(guò)vSphere VDPA備份/恢復(fù)虛擬機(jī)，驗(yàn)證虛擬化環(huán)境下的備份；查看整體數(shù)據(jù)去重比；DataDomain 遠(yuǎn)程數(shù)據(jù)復(fù)制；1.2 測(cè)試環(huán)境備份服務(wù)器：CentOS 6.

2、4 Oracle數(shù)據(jù)庫(kù)服務(wù)器，CentOS，Oracle 11g 兩臺(tái)DD4200ESXi Server2. VTL方式進(jìn)行數(shù)據(jù)備份測(cè)試目的測(cè)試DataDomain虛擬磁帶庫(kù)功能；測(cè)試Networker中VTL協(xié)議功能；測(cè)試VTL協(xié)議在光線鏈路上運(yùn)行；預(yù)置條件Networker軟件部署完成；DD設(shè)備正常；光線線路聯(lián)通；測(cè)試步驟將DD設(shè)備虛擬成磁帶庫(kù)使用在NetWorker中識(shí)別虛擬磁帶需要備份的文件在NetWorker中進(jìn)行備份測(cè)試結(jié)果DataDomain虛擬磁帶庫(kù)可以模擬磁帶庫(kù)；Networker中VTL協(xié)議功能運(yùn)行正常；在光線鏈路上顯現(xiàn)Lanfree備份；備 注3.Oracle RMAN

3、備份測(cè)試目的測(cè)試DDBoost功能與Oracle的結(jié)合；Oracle可以識(shí)別到DD直接進(jìn)行備份；DDBOOST具有源端去重功能，可以實(shí)現(xiàn)快速數(shù)據(jù)備份。預(yù)置條件Oracle數(shù)據(jù)庫(kù)開(kāi)啟歸檔，可以進(jìn)行Rman備份；DD和DDBoost正常；測(cè)試步驟RMAN backup database;Starting backup at 31-MAR-16using target database control file instead of recovery catalogallocated channel: ORA_SBT_TAPE_1channel ORA_SBT_TAPE_1: SID=161 dev

4、ice 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 datafile file number=00002 name=

5、/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/oradata/oratest/users01.dbfchann

6、el 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 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35channel ORA_SBT_TAPE_1: starting full datafile

7、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-16piece handle=3cr1s9q0_1_1 tag=TAG20160331T

8、150916 comment=API Version 2.0,MMS Version channel 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- - - - - - - - - -57 B F A SBT_TAPE 31-MAR-16 1 1 NO TAG20160331T

9、09404358 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 TAG20160331T150916BS Key Type LV Size Device Ty

10、pe 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 Time Name - - - - - - 1 Full 1981918 31-MAR-16 /

11、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.dbf 5 Full 1981918 31-MAR-16 /home/app/oracle/

12、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 SPFILE Included: Modification time: 31-MAR-16 SPF

13、ILE 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: TAG20160331T150916 Handle: 3br1s9ot_1_1 Media: dd

14、storage 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-16 /home/app/oracle/oradata/oratest/undotbs01.

15、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-MAR-16 BP Key: 75 Status: AVAILABLE Compressed

16、: 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測(cè)試結(jié)果Oracle使用Rman識(shí)別到DD，并可以進(jìn)行數(shù)據(jù)備份備 注 4. NAS方式進(jìn)行Oracle Export 數(shù)據(jù)備份測(cè)試目的驗(yàn)證NAS功能，Oracle可以直接將數(shù)據(jù)Expor

17、t到DD預(yù)置條件Oracle正常；DD正常；測(cè)試步驟將DD通過(guò)NAS方式NFS將備份空間共享給Linux主機(jī)，Oracle 使用Export命令將數(shù)據(jù)備份到DD上面。再DD上創(chuàng)建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 39M 421M 9% /boot/dev/mapper/VolGroup-lv_home 81

18、G 13G 64G 17% /home/usr/local/src/rhel-server-6.4-x86_64-dvdED2000.COM.iso 3.5G 3.5G 0 100% /media11:/data/col1/backup 21T 54G 21T 1% /backuporaclerhelser2 $ oraclerhelser2 $ expdp system/password directory=dump_test_dir dumpfile=test1545.dmpExport: Release .0 - Production on Thu Mar 31 15:45:35 201

19、6Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release .0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsStarting SYSTEM.SYS_EXPORT_SCHEMA_01: system/* directory=dump_te

20、st_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 type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_G

21、RANTProcessing 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 object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessing object type SCHEM

22、A_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 SCHEMA_EXPORT/PACKAGE/PACKAGE_SPECProcessing object type SCHEMA_EXPORT/FUNC

23、TION/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_FUNCTIONProcessing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDUREProcessing object

24、 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/VIEWProcessing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANTProce

25、ssing 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/TRIGGERProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSProcessing

26、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. . exported SYSTEM.REPCAT$_RESOLUTION_METHOD 5.835 KB 19 rows. . export

27、ed 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 0 KB 0 rows. . exported SYSTEM.DEF$_DEFAULTDEST 0 KB 0 rows. . exported

28、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.DEF$_PUSHED_TRANSACTIONS 0 KB 0 rows. . exported SYSTEM.MVIEW$_ADV_INDEX

29、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 SYSTEM.REPCAT$_DDL 0 KB 0 rows. . exported SYSTEM.REPCAT$_EXCEPTIONS 0 K

30、B 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$_INSTANTIATI

31、ON_DDL 0 KB 0 rows. . exported SYSTEM.REPCAT$_KEY_COLUMNS 0 KB 0 rows. . exported SYSTEM.REPCAT$_OBJECT_PARMS 0 KB 0 rows. . exported SYSTEM.REPCAT$_PARAMETER_COLUMN 0 KB 0 rows. . exported SYSTEM.REPCAT$_PRIORITY 0 KB 0 rows. . exported SYSTEM.REPCAT$_PRIORITY_GROUP 0 KB 0 rows. . exported SYSTEM.R

32、EPCAT$_REFRESH_TEMPLATES 0 KB 0 rows. . exported SYSTEM.REPCAT$_REPCAT 0 KB 0 rows. . exported SYSTEM.REPCAT$_REPCATLOG 0 KB 0 rows. . exported SYSTEM.REPCAT$_REPCOLUMN 0 KB 0 rows. . exported SYSTEM.REPCAT$_REPGROUP_PRIVS 0 KB 0 rows. . exported SYSTEM.REPCAT$_REPOBJECT 0 KB 0 rows. . exported SYST

33、EM.REPCAT$_REPPROP 0 KB 0 rows. . exported SYSTEM.REPCAT$_REPSCHEMA 0 KB 0 rows. . exported SYSTEM.REPCAT$_RESOLUTION 0 KB 0 rows. . exported SYSTEM.REPCAT$_RESOLUTION_STATISTICS 0 KB 0 rows. . exported SYSTEM.REPCAT$_RESOL_STATS_CONTROL 0 KB 0 rows. . exported SYSTEM.REPCAT$_RUNTIME_PARMS 0 KB 0 ro

34、ws. . exported SYSTEM.REPCAT$_SITES_NEW 0 KB 0 rows. . exported SYSTEM.REPCAT$_SITE_OBJECTS 0 KB 0 rows. . exported SYSTEM.REPCAT$_SNAPGROUP 0 KB 0 rows. . exported SYSTEM.REPCAT$_TEMPLATE_OBJECTS 0 KB 0 rows. . exported SYSTEM.REPCAT$_TEMPLATE_PARMS 0 KB 0 rows. . exported SYSTEM.REPCAT$_TEMPLATE_R

35、EFGROUPS 0 KB 0 rows. . exported SYSTEM.REPCAT$_TEMPLATE_SITES 0 KB 0 rows. . exported SYSTEM.REPCAT$_TEMPLATE_TARGETS 0 KB 0 rows. . exported SYSTEM.REPCAT$_USER_AUTHORIZATIONS 0 KB 0 rows. . exported SYSTEM.REPCAT$_USER_PARM_VALUES 0 KB 0 rows. . exported SYSTEM.SQLPLUS_PRODUCT_PROFILE 0 KB 0 rowsMaster table SYSTEM.SYS_EXPORT_SCHEMA_01 successfully loaded/unloaded*Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /backup/test1545.dmpJob SYSTEM.SYS_EXPORT_SCHEMA_01 su