EMCNetworker备份测试报告.docx
《EMCNetworker备份测试报告.docx》由会员分享,可在线阅读,更多相关《EMCNetworker备份测试报告.docx(31页珍藏版)》请在冰豆网上搜索。
EMCNetworker备份测试报告
Networker数据备份方案
测试报告
2016年03月
1.备份测试环境
1.1测试内容
1.文件备份:
通过NetWorker备份软件以VTL方式和NAS方式进行数据备份,并进行文件数据备份和恢复;
2.OracleRMAN通过DDBoost方式直接进行数据库备份,测试Oracle自身备份和源端数据重删功能;
3.OracleExport通过NAS方式将数据直接写入DataDomain备份介质,模拟核心应用备份;
4.在Vmware环境中通过vSphereVDPA备份/恢复虚拟机,验证虚拟化环境下的备份;
5.查看整体数据去重比;
6.DataDomain远程数据复制;
1.2测试环境
备份服务器:
CentOS6.4
Oracle数据库服务器,CentOS,Oracle11g
两台DD4200
ESXiServer
2.VTL方式进行数据备份
测试目的
1、测试DataDomain虚拟磁带库功能;
2、测试Networker中VTL协议功能;
3、测试VTL协议在光线链路上运行;
预置条件
Networker软件部署完成;
DD设备正常;
光线线路联通;
测试步骤
将DD设备虚拟成磁带库使用
在NetWorker中识别虚拟磁带
需要备份的文件
在NetWorker中进行备份
测试结果
DataDomain虚拟磁带库可以模拟磁带库;
Networker中VTL协议功能运行正常;
在光线链路上显现Lanfree备份;
备注
3.OracleRMAN备份
测试目的
测试DDBoost功能与Oracle的结合;
Oracle可以识别到DD直接进行备份;
DDBOOST具有源端去重功能,可以实现快速数据备份。
预置条件
Oracle数据库开启归档,可以进行Rman备份;
DD和DDBoost正常;
测试步骤
RMAN>backupdatabase;
Startingbackupat31-MAR-16
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_SBT_TAPE_1
channelORA_SBT_TAPE_1:
SID=161devicetype=SBT_TAPE
channelORA_SBT_TAPE_1:
DataDomainBoostAPI
channelORA_SBT_TAPE_1:
startingfulldatafilebackupset
channelORA_SBT_TAPE_1:
specifyingdatafile(s)inbackupset
inputdatafilefilenumber=00001name=/home/app/oracle/oradata/oratest/system01.dbf
inputdatafilefilenumber=00002name=/home/app/oracle/oradata/oratest/sysaux01.dbf
inputdatafilefilenumber=00005name=/home/app/oracle/oradata/oratest/example01.dbf
inputdatafilefilenumber=00003name=/home/app/oracle/oradata/oratest/undotbs01.dbf
inputdatafilefilenumber=00004name=/home/app/oracle/oradata/oratest/users01.dbf
channelORA_SBT_TAPE_1:
startingpiece1at31-MAR-16
channelORA_SBT_TAPE_1:
finishedpiece1at31-MAR-16
piecehandle=3br1s9ot_1_1tag=TAG20160331T150916comment=APIVersion2.0,MMSVersion1.1.1.0
channelORA_SBT_TAPE_1:
backupsetcomplete,elapsedtime:
00:
00:
35
channelORA_SBT_TAPE_1:
startingfulldatafilebackupset
channelORA_SBT_TAPE_1:
specifyingdatafile(s)inbackupset
includingcurrentcontrolfileinbackupset
includingcurrentSPFILEinbackupset
channelORA_SBT_TAPE_1:
startingpiece1at31-MAR-16
channelORA_SBT_TAPE_1:
finishedpiece1at31-MAR-16
piecehandle=3cr1s9q0_1_1tag=TAG20160331T150916comment=APIVersion2.0,MMSVersion1.1.1.0
channelORA_SBT_TAPE_1:
backupsetcomplete,elapsedtime:
00:
00:
03
Finishedbackupat31-MAR-16
RMAN>listbackupsummary;
====
KeyTYLVSDeviceTypeCompletionTime#Pieces#CopiesCompressedTag
-----------------------------------------------------------------
57BFASBT_TAPE31-MAR-1611NOTAG20160331T094043
58BFASBT_TAPE31-MAR-1611NOTAG20160331T094043
59BFASBT_TAPE31-MAR-1611NOTAG20160331T094351
60BFASBT_TAPE31-MAR-1611NOTAG20160331T094351
61BFASBT_TAPE31-MAR-1611NOTAG20160331T150916
62BFASBT_TAPE31-MAR-1611NOTAG20160331T150916
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
59Full1.37GSBT_TAPE00:
00:
1431-MAR-16
BPKey:
72Status:
AVAILABLECompressed:
NOTag:
TAG20160331T094351
Handle:
39r1rmmn_1_1Media:
ddstorage
ListofDatafilesinbackupset59
FileLVTypeCkpSCNCkpTimeName
---------------------------------
1Full198191831-MAR-16/home/app/oracle/oradata/oratest/system01.dbf
2Full198191831-MAR-16/home/app/oracle/oradata/oratest/sysaux01.dbf
3Full198191831-MAR-16/home/app/oracle/oradata/oratest/undotbs01.dbf
4Full198191831-MAR-16/home/app/oracle/oradata/oratest/users01.dbf
5Full198191831-MAR-16/home/app/oracle/oradata/oratest/example01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
60Full10.00MSBT_TAPE00:
00:
0331-MAR-16
BPKey:
73Status:
AVAILABLECompressed:
NOTag:
TAG20160331T094351
Handle:
3ar1rmn6_1_1Media:
ddstorage
SPFILEIncluded:
Modificationtime:
31-MAR-16
SPFILEdb_unique_name:
ORATEST
ControlFileIncluded:
CkpSCN:
1981940Ckptime:
31-MAR-16
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
61Full1.37GSBT_TAPE00:
00:
2731-MAR-16
BPKey:
74Status:
AVAILABLECompressed:
NOTag:
TAG20160331T150916
Handle:
3br1s9ot_1_1Media:
ddstorage
ListofDatafilesinbackupset61
FileLVTypeCkpSCNCkpTimeName
---------------------------------
1Full200808031-MAR-16/home/app/oracle/oradata/oratest/system01.dbf
2Full200808031-MAR-16/home/app/oracle/oradata/oratest/sysaux01.dbf
3Full200808031-MAR-16/home/app/oracle/oradata/oratest/undotbs01.dbf
4Full200808031-MAR-16/home/app/oracle/oradata/oratest/users01.dbf
5Full200808031-MAR-16/home/app/oracle/oradata/oratest/example01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
-------------------------------------------------------------
62Full10.00MSBT_TAPE00:
00:
0331-MAR-16
BPKey:
75Status:
AVAILABLECompressed:
NOTag:
TAG20160331T150916
Handle:
3cr1s9q0_1_1Media:
ddstorage
SPFILEIncluded:
Modificationtime:
31-MAR-16
SPFILEdb_unique_name:
ORATEST
ControlFileIncluded:
CkpSCN:
2008863Ckptime:
31-MAR-16
RMAN>
测试结果
Oracle使用Rman识别到DD,并可以进行数据备份
备注
4.NAS方式进行OracleExport数据备份
测试目的
验证NAS功能,Oracle可以直接将数据Export到DD
预置条件
Oracle正常;
DD正常;
测试步骤
将DD通过NAS方式NFS将备份空间共享给Linux主机,Oracle使用Export命令将数据备份到DD上面。
再DD上创建NFS共享
[oracle@rhelser2~]$df-h
FilesystemSizeUsedAvailUse%Mountedon
/dev/mapper/VolGroup-lv_root
50G16G32G34%/
tmpfs4.0G597M3.5G15%/dev/shm
/dev/sda1485M39M421M9%/boot
/dev/mapper/VolGroup-lv_home
81G13G64G17%/home
/usr/local/src/rhel-server-6.4-x86_64-dvdED2000.COM.iso
3.5G3.5G0100%/media
10.32.32.111:
/data/col1/backup
21T54G21T1%/backup
[oracle@rhelser2~]$
[oracle@rhelser2~]$expdpsystem/passworddirectory=dump_test_dirdumpfile=test1545.dmp
Export:
Release11.2.0.4.0-ProductiononThuMar3115:
45:
352016
Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
Starting"SYSTEM"."SYS_EXPORT_SCHEMA_01":
system/********directory=dump_test_dirdumpfile=test1545.dmp
EstimateinprogressusingBLOCKSmethod...
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/TABLE_DATA
TotalestimationusingBLOCKSmethod:
320KB
ProcessingobjecttypeSCHEMA_EXPORT/USER
ProcessingobjecttypeSCHEMA_EXPORT/SYSTEM_GRANT
ProcessingobjecttypeSCHEMA_EXPORT/ROLE_GRANT
ProcessingobjecttypeSCHEMA_EXPORT/DEFAULT_ROLE
ProcessingobjecttypeSCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ProcessingobjecttypeSCHEMA_EXPORT/SYNONYM/SYNONYM
ProcessingobjecttypeSCHEMA_EXPORT/TYPE/TYPE_SPEC
ProcessingobjecttypeSCHEMA_EXPORT/SEQUENCE/SEQUENCE
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/TABLE
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/PRE_TABLE_ACTION
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/COMMENT
ProcessingobjecttypeSCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
ProcessingobjecttypeSCHEMA_EXPORT/FUNCTION/FUNCTION
ProcessingobjecttypeSCHEMA_EXPORT/PROCEDURE/PROCEDURE
ProcessingobjecttypeSCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
ProcessingobjecttypeSCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
ProcessingobjecttypeSCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/INDEX/INDEX
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ProcessingobjecttypeSCHEMA_EXPORT/VIEW/VIEW
ProcessingobjecttypeSCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
ProcessingobjecttypeSCHEMA_EXPORT/VIEW/COMMENT
ProcessingobjecttypeSCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/TRIGGER
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ProcessingobjecttypeSCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
ProcessingobjecttypeSCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
..exported"SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE"6.328KB2rows
..exported"SYSTEM"."REPCAT$_OBJECT_TYPES"6.882KB28rows
..exported"SYSTEM"."REPCAT$_RESOLUTION_METHOD"5.835KB19rows
..exported"SYSTEM"."REPCAT$_TEMPLATE_STATUS"5.484KB3rows
..exported"SYSTEM"."REPCAT$_TEMPLATE_TYPES"6.289KB2rows
..exported"SYSTEM"."DEF$_AQCALL"0KB0rows
..exported"SYSTEM"."DEF$_AQERROR"0KB0rows
..exported"SYSTEM"."DEF$_CALLDEST"0KB0rows
..exported"SYSTEM"."DEF$_DEFAULTDEST"0KB0rows
..exported"SYSTEM"."DEF$_DESTINATION"0KB0rows
..exported"SYSTEM"."DEF$_ERROR"0KB0rows
..exported"SYSTEM"."DEF$_LOB"0KB0rows
..exported"SYSTEM"."DEF$_ORIGIN"0KB0rows
..exported"SYSTEM"."DEF$_PROPAGATOR"0KB0rows
..exported"SYSTEM"."DEF$_PUSHED_TRANSACTIONS"0KB0rows
..exported"SYSTEM"."MVIEW$_ADV_INDEX"0KB0rows
..exported"SYSTEM"."MVIEW$_ADV_PARTITION"0KB0rows
..exported"SYSTEM"."REPCAT$_AUDIT_COLUMN"0KB0rows
..exported"SYSTEM"."REPCAT$_COLUMN_GROUP"0KB0rows
..exported"SYSTEM"."REPCAT$_CONFLICT"0KB0rows
..exported"SYSTEM"."REPCAT$_DDL"0KB0rows
..exported"SYSTEM"."REPCAT$_EXCEPTIONS"0KB0rows
..exported"SYSTEM"."REPCAT$_EXTENSION"0KB0rows
..exported"SYSTEM"."REPCAT$_FLAVORS"0KB0rows
..exported"SYSTEM"."REPCAT$_FLAVOR_OBJECTS"0KB0rows
..exported"SYSTEM"."REPCAT$_GENERATED"0KB0rows
..exported"SYSTEM"."REPCAT$_GROUPED_COLUMN"0KB0rows
..exported"SYSTEM"."REPCAT$_I