22、海尔690智慧运营系统恢复演练报告

1、海尔 690 智慧运营数据库异机恢复演练智信云通科技2014 年 12 月目 录一.二.测试背景3测试概况3测试主要目的3主要工作内容3测试环境32.12.2三.测试主机环境3测试系统结构图4测试步骤及结果4恢复环境准备4建立 CommVault 8.0 备份服务器44.4 安装 Oracle for AIX 和 HPUX 数据库24四..24.4.3硬件环境24环境24安装24安装 CommvaultMedia agent ,oracle ida for AIX 和 HP-UX25使用磁带进行 Oracle 数据库的全库恢复384.6.1 对数据库（AIX）进行恢复38数据库

2、的物理恢复(restore)38数据库的逻辑恢复41打开数据库(open)424.7 数据库恢复后的校验42数据库基本参数检查42应用数据检查44一. 测试背景数据库采用 AIX 系统和 ORACLE10G 数据库；海尔数据库系统采用HP-UX 系统和 ORACLE10G 数据库,采用 CommVault 备份,结合 LANfree 备份方式将Oracle 数据备份到 ADIC Scalar i500 磁带库中.此次测试模拟 CommVault 备份服务器、数据库主机发生恢复提供经验后的数据恢复全过程,为二. 测试概况2.1 测试主要目的验证 CommVault 备份验证使用 CommVaul

3、t在主机发生后的可恢复性备份到磁带上的数据的有效性。2.2 主要工作内容.5.安装Win2003 Server sp2，建立CommVault 8.0备份服务器使用CommVauR工具恢复备份的配置信息准备AIX5.3和 HPUX 11.23 操作系统安装Oracle for AIX和HP-UX 数据库使用磁带进行Oracle数据库的全库恢复三. 测试环境3.1 测试主机环境IBMAIX5.3P595_23Oracle 数据库(目标机)HPUX11.11Lisserv5Oracle 数据库(目标机)惠普 PC ServerWin 2003ServerCommserv25520Co

4、mmVault备份服务器3.2 测试系统结构图硬件拓扑图和分布图:四. 测试步骤及结果4.1 恢复环境准备Commserver 服务器要求 windows 2003sp2AIX 主机要求和源主机操作系HP 主机要求和源主机操作系致，oracle版本和以前一致。致，oracle 版本和以前一致。4.2 建立 CommVault 8.0 备份服务器以下过程是安装CommServe的详细步骤：1.2.3.将CommServe安装光盘主机光驱在“电脑”中，右键选择“自动”或双击光驱图标出现如下安装界面：4. 选择“中文”或“英文”均可，选择“下一步”开始安装面：，出现如下界5. 选择“InstallQ

5、iNetix on this computer”，开始安装6. 在“e”界面中，选择“Next”，然后在接下来出现的界面中选择“OK”确认即可7. 在“License Agreement”中，选择“I accept the terms agreement”接受he license8. 在“Select Platforms”中选择在CommServe上需要安装的模块9. CommVault的安装需要一些特殊权限，安装中会提示你是否同意设置这些权限，选择“Yes”确定即可10. 在安装数据实例的提示界面中，选择“Yes”开始安装数据库实例11. 在“Database Engine Installa

6、tion Path”界面中，确定数据库引擎的安装路径，选择“Browse”可以修改数据库引擎安装路径12. 在“MSSQL Database Installation Path”界面中，确定MSSQL数据库安装路径，选择“Browse”可以修改MSSQL数据库的安装路径13.开始安装数据库引擎14.在“SQL Usassword”界面中设置SQL用户的口令15. 如果你的系统中已经安装了其它版本的JRE，安装程序会版本的JRE你安装一个高16. 如果接受，开始安装Java环境17. 在“Destination Folder”界面中选择的安装路径，选择“Browes”可以修改的安装路径18. 在

7、“CommServe Database Path”界面中确定CommServe数据库的路径，选择“Browse”可以修改CommServe数据库的安装路径19.在“CommServeName”中指定CommServe的客户端名称和主机名20.在“CommServeDisaster Recovery Path”界面中指定恢复文件的路径，选择“Browse”指定恢复文件的路径21. 在“Firewall Configuration”界面中可以配置火墙，通常选择不配置防22. 在“Applya License”中指定正式证文件的路径或选择使用Demo证23. 在“Administrator “口令”

8、Account”中配置登录CommCell Console的“帐户”和24.在“Medisword”中输入介质的口令25.选择“Yes”确认配置CommCellConsole Web管理26.在“WebAdministration”中输入一个别名27.在“MediaAgent Index Cache Path” 中配置Index “Browse”可以修改Index Cache的存放路径Cache 的路径， 选择28. 在“Job Results Path”界面中配置客户端的作业结果存放路径，选择 “Browse”可以修改存放路进29. 在“Snap Driver Default Volume”

9、界面中配置snap位图的分区或卷30.在“Summary”界面中选择“Next”确认你的配置并继续安装31.安装到这个过程，系统会提示需要注销一次，选择“LogOff”确认注销32. 系统注销完成后，的安装过程会自动进行，如如下界面所示：33. 在“Automatic Updates schedule”界面中，如果需要配置自动更新的调度计划，可以选中“Schedule FTP Download of Automatic Updates”并配置时间表，建议不要配置34.安装到这里，系统会提示你是否删除先前安装中设置的特殊权限，选择 “Yes”确认删除35. 在“Install Updates s

10、chedule”界面中选择不配置“Schedule Install ofAutomaticUpdates”36. 在系统提示安装后需要重启服务器界面中，选择“OK”确定37.在“ScheduleReminder”界面中选择“Next”即可38. 在“Completion Report” 界面出现后， 选择“RebootNow” 或“Finish”完成的安装39.安装完成，重启服务器。4.4 安装 Oracle for AIX 和 HPUX 数据库4.4.1 硬件环境4.4.2环境4.4.3安装安装前准备：操作系统环境；HACMP 需求环境；JDK,C+需求环境创建oracle 用户创建用户组组

11、名组 IDoinstall300操作系统AIX 5300-09集群HACMP 数据库Oracle 升级补丁主机 Ap595a24 CPU93696M Memmary主机 Bp595b24 CPU93696M Memmary创建用户3.Oracle安装4.5 安装 CommvaultMedia agent ,oracle ida for AIX 和 HP-UX1.运行cvpkgadd 命令： p595_2/mnt#./cvpkgadd Restarting in pdksh-v5.2.14.Simpana8.0.0 (BUILD68)AIX5.3CommVault _/ _(_)_ _ _ _

12、_ | | _ _ | _ / _ | _ / _ |_ | | | | | | | |_) | (_| | | | | (_| | /|_|_|_| |_| . / ,_|_| |_| ,_|_|8.0.0(BUILD68)etoCommVault Systems, Inc. Simpana.For support please visit, or/support, or send ancall US/CANADA (Toll Free) (877) 780-3077;toERNATIONAL (732) 571-2160.This script will install Simpana b

13、ackup system on this machine.Log messages will be sent to /tmp/.gxsetup/cvpkgadd.log.757882.Press to start .2.接受license 协议：Simpana8.0.0 (BUILD68)AIX5.3EULA用户名oracle用户 ID300属组dbaoinstallhagsuser用户目录/oracledba301hagsuser302Press to review Simpana End User License Agreement .Simpana8.0.0 (BUILD68)AIX5.

14、3CommVault Systems, Inc.End User License and Limited Warranty AgreementCommVault(r) Simpana(r) Software Release 8.0.0(including(r) SQL Server(tm) 2005 Entrise Edition, SQL Server(tm) 2005 Express Edition andWindows Pre-Installation Environment)End User License AgreementIMPORTANT- READ CAREFULLY: THI

15、S END USER LICENSE AGREEMENT (EU-LA) IS A LEGAL AGREEMENT BETN YOU (EITHER AS AN INDIVIDUAL ORENTITY) (YOU ) AND COMMVAULT SYSTEMS, INC.THE ABOVE-REFERENCED SOFTWARE PRODUCT(S), WHICH(COMMVAULT) FORINCLUDES COMPUTER ONLINE OR ELEC-SOFTWARE AND MAY INCLUDE ASSOTED MEDIA, ANDTRONICATION (SOFTWARE). BY

16、 INSTALLING, COPYING OR OTH-ERWISE USING THE THIS EULA. IF YOUINSTALL OR USESOFTWARE, YOU AGREE TO BE BOUND BY THE TERMS OFDO NOT AGREE TO THE TERMS OF THIS EULA, DO NOTTHE SOFTWARE. YOU SHALL INFORM ALLUSERS OF THESOFTWARE OF THE TERMS AND CONDITIONS OF THIS EULA.Copyright Acknowledgment(c)1997-200

17、8 CommVault Systems, Inc.s.Do youacceptthe terms of thislicense agreement?Yes3.开始安装到物理结点上：Simpana8.0.0 (BUILD68)AIX5.3ClusterSupportCertainSimpana packages can beassoted wivirtualIP, or in otherwords, installed on a virtual machine belonging to some cluster. At anygiven time the virtual machines ser

18、viand IP address are active on onlyone of the clusters servers. The virtual machinecan fail-over from one and deactivating IPaddress/servion theserver to another, which includes stopserviaddress on theother server.server and activating the IPYou now have a choice of performing a regular Simpana inst

19、all on the physical host or installing Simpana on a virtual machine for operation within acluster.Most users should select Install on a physical machine here.Install on aInstall on aExit thisphysical machinevirtualmachineYour choice: 1Simpana8.0.0 (BUILD68)AIX 5.3PhysicalMachineHost NameNetworkerfaw

20、ith thefollowing IPs have been found available on yoursystem. One of theseerfashould be assoted with the physical machinebeing installed. It will also be used by the CommServe to initiate connectionsto the physical machine. Notet you will be able to additionallycustomizehe SimpanaDatapipeJava GUI.er

21、face Pairs used for the backup daraffic later4.选择相应的网卡作为备份接口Please selectthe correct networkerface below.1) p595_22)(3)(04)erfaceSimpananumber: 18.0.0(BUILD68)AIX 5.3Physical Machine Host NamePlease verify the physical machineerface name below. Make itsible.ascomplete(with fully qualifiedname) asPhy

22、sical Machine Host Name: p595_2Simpana8.0.0 (BUILD68)AIX 5.3Physical Machine Cnt NamePlease specify the cnt name for this machine.It does nowithout spa CommServe.ve to. Thebe the network host name: you can enter any word hereonly requirement ist it must be unique on thePhysical Machine CSimpanant Na

23、me: p595_28.0.0 (BUILD68)AIX5.3Install Simpana on physicalmachine p595_25.选择需要安装的模块：Selectthe Simpana modulet youwould like to install.1)3)5)7)9)11)13)15)17)19)21)23)ModuleMedia AgentProxy FileSystem IDA2)4)6)8)10)12)14)16)18)20)22)FileSystem IDA Oracle IDA SAPMAXDB IDASybase IDALotus Notes DB IDA C

24、ontinuous Data Replicator Image IDA for UNIXNDMP Restore Enabler1-Touch Boot Server AgentOracle SA Informix IDADB2 IDAAData Archiver forQsnap DriverUNIXNDMP Remote Server Quick Recovery AgentRecovery Director forUNIXSRMDFile System AgentlassificationUNIX ImageLevel Exitnumber: 1ProxyHost IDASimpana8

25、.0.0 (BUILD68)CVGxMA for AIX5.3Dependency CheckHere is a list and susofthedependentmodules:Base0 ModuleBase ModuleNOT installedNOT installedProceeding with install/upgradeof the dependent modules.CVGxBase0 for AIX 5.3Simpana8.0.0 (BUILD68)Verifying binary compatibility .done.SimpanaCVGxBase0 for AIX

26、 5.3Simpana Installation DirectoryPlease specify where you want us to install Simpana binaries.It must be a local directory and there should beeast 180MB of free spaceavailable. All files will be installed in a simpana subdirectory, so if youenter /opt, the files will actually be placedo /opt/simpan

27、a.6.选择安装路径：Installation Directory: /optSimpanawill be installed in /opt/simpana.SimpanaCVGxBase0 for AIX 5.3Simpog DirectoryPlease specify where you want tokeep Simpogfiles.It must be a local directory andavailable. All log files will bethere should beeast 100MB of free spacecreated in a simpog_File

28、ssubdirectory, so if you enter /var/log, the logswill actually be placedo /var/log/simpog_Files.Log Directory: /var/logSimpog files will becreated in /var/log/simpog_Files.SimpanaCVGxBase0 for AIX 5.3SimpanaGroupMost ofSimpana prosesrun with root privileges,but some are launched bydatabases and inhe

29、rit database acs rights. To make suret registry andlog files can be written to files world-writeable or weto a particular group, e.g.by both kinds of procan grant write acses we can either make suchs only to proses belonginga simpana or a dbagroup.We highlymend nowt you create a new useryou choose n

30、ot to assigngroup and enter its name in a dedicated group tofiles will be created withthe next setup screen. IfSimpana proses, all temporary and configuration-rw-rw-rw permiss.If youreplanning to backup Oracle DB you should use dba group.Would youSimpanalike to assign a specific group to8.0.0 (BUILD

31、68)Simpana? yes noCVGxBase0 for AIX 5.3Binary Copy7.开始安装BASE模块：Copying binaries .100% Unpacking Base64/libSnooper.so .100% Verifying CRC32 for Base/cvfwd .Sucsfully copied 250 filesSimpanaCVGxBase0 for AIX 5.3Creating registry tree underInstalling startup scriptsmVaultRegistryo /etc and modifying. d

32、one./etc/inittab .done.Creating Creating Creating Creating Creating CreatingCreating/opt/simpana/Base/simpana .done./usr/bin/simpana .done./usr/bin/cvpkgrm .done./usr/bin/cvpkgcheck .done./usr/sbin/simpana .done./usr/sbin/cvpkgrm .done./usr/sbin/cvpkgcheck .done.Adjusting modes and permiss of Simpan

33、a filesSucsfully installed CVGxBase0ProceedingSimpanawithCVGxBase install .8.0.0 (BUILD68)CVGxBasefor AIX5.3Simpana8.0.0 (BUILD68)CVGxBasefor AIX5.3InstancePort NumbersEvery instance of Simpana should use a uniquesetof network ports to avoiderfering with other instanrunning on the same machine.The p

34、ort numberected must be from theport number range and havenot been registered by another application on this machine.Please enter the port numbers.Port Number forCVD: 8400Port Number forSimpanaEvMgrC: 84028.0.0 (BUILD68)CVGxBase for AIX 5.3SimpanaFirewall ConfigVariousSimpanacomponents need to commu

35、nicate with each other: iDataAgents establish connections to CommServe and talk to each other asthe involved parties are situated on the opite sides of aand MediaAgentswell. If any offirewall, Simpana should be made aware of it sot it could bind its pipeline sockets to open ports and could establish

36、 tunnels for controltraffic.You must configure Simpana firewall serviif there are other Simpanamachines, which are expected to communicate with this one.Do you want toSimpanaconfigure Simpana firewall servi8.0.0 (BUILD68)?noCVGxBase for AIX 5.3CommServe HostNamePlease enter the hostname of the Simpa

37、na CommServe.It can be either short orlong; the only requirement isconfigured on this machine.t it must be resolvaby the name serviCommServeSimpanaName: commserv2558.0.0 (BUILD68)CVGxBase for AIX 5.3CommServeCheckCommServe: commserv255Trying to contact CommServe commserv255 1 of 3 .done. Validating

38、cnt name and hostname from CommServe .done.Checking if CS is enabled Getting CommServe ver Verifying CommServe verGetting CommServe Servicefor install authentication.done.done.Pack Level .done.done.VerifyingSimpanaCommServeService Pack Level . done.CVGxBase for AIX 5.3SimpanaCVGxBase for AIX 5.3Simp

39、anaJob ResultsDirectoryPlease specify the name for the JobResults directory.It must be a local directory and there should beeast 20MB of free spacehat should be passedavailable. It will befrom one backup phaseused to storeto another.ermediate daJobResults Directory:/opt/simpana/iDataAgent/jobResults

40、Directory /opt/simpana/iDataAgent/jobResults doesDo you want us to create it? yesnotexist.Simpana job results files will be created in/opt/simpana/iDataAgent/jobResults.SimpanaCVGxBase for AIX5.3Fetching CreatingCreatingcnt GUID from the CommServe mon registry underregistry tree undermon . done.done

41、.mVaultRegistry.Trying to contact CommServe commserv255 1 of 3 .done.Creating Job Results directory . done.Adjusting modes and permiss of Simpana filesSucsfully installed CVGxBase8.开始安装Media Agent模块Proceeding with CVGxMAinstall .done.8.0.0 (BUILD68)StopSimpanaSimpana serviCVGxMA forAIX5.3GettingComm

42、Serve ver.done.done.Pack Level .done.Verifying CommServe verGetting CommServe ServiceVerifyingVerifying SimpanaCommServe Service Pack Level . done.CVGxMAlicense on the CommServe .done.CVGxMA forAIX 5.3Simpana8.0.0 (BUILD68)CVGxMA forAIX 5.3Binary CopyCopying binaries.100% Unpacking MediaAgent/locate

43、devih .100% Verifying CRC32for MediaAgent/locatedevih .Sucsfully copied 92filesCVGxMA for AIX 5.3Adding service CvMountd to /etc/servi. done.Updating registry tree underPreconfiguring MediaAgent onmVaultRegistry. done.the CommServe . done.tinstall -Simpana-CVGxMA for AIX 5.3Index Cache DirectoryMedi

44、aAgent maains a cacheof indifor completed backups. Normallytheyre stored in /opt/simpana/MediaAgent/IndexCache directory, but you cankeep them anywhere. You can evenmore MediaAgents.make an IndexCache directory shared by two orIndexCache directory should haveeast 256MB of free space.Please specify w

45、here you want usto store the Index Cache.Index Cache Directory: /opt/simpana/MediaAgent/IndexCacheDirectory /opt/simpana/MediaAgent/IndexCache does not exist. Do you want us to create it? yesConfiguring IndexCache directory /opt/simpana/MediaAgent/IndexCacheCreating CvMountd service . done.done.Dete

46、cting media changer devi. Please be patient.Preconfiguring CVGxBase0 on the CommServe .done.Preconfiguring CVGxBase on the CommServe .done.Adjusting modes and permiss of Simpana filesSucsfully installed CVGxMA.Press ENTER to continue .Simpana8.0.0 (BUILD68)AIX 5.3Install Simpana on physical machine

47、p595_29.开始安装Filesystem Agent模块Selectthe Simpana modulet youwould like to install.1)3)5)7)9)11)13)15)17)19)21)FileSystem IDA Oracle IDA SAPMAXDB IDASybase IDALotus Notes DB2)4)6)8)10)12)14)16)18)20)22)Proxy FileSystem IDA Oracle SAA Informix IDADB2 IDAData Archiver for UNIX Qsnap DriverNDMP Remote Se

48、rver Quick Recovery AgentRecovery Director for UNIXIDAContinuous Data Replicator Image IDA for UNIXNDMP Restore Enabler1-Touch Boot Server Agent SRM File System AgentUNIX ImageLevelExitProxyHost IDADlassificationModuleStopnumber: 1Simpana servi.done.8.0.0 (BUILD68)SimpanaCVGxIDA for AIX5.3GettingCom

49、mServe ver.done.done.Pack Level .done.Verifying CommServe verGetting CommServe ServiceVerifyingVerifying SimpanaCommServe Service Pack Level . done.CVGxIDA licenseon the CommServe .done.CVGxIDA for AIX5.3Simpana8.0.0 (BUILD68)CVGxIDA for AIX 5.3Binary CopyCopying binaries.100% UnpackingBase/libudccn

50、t.so .100% VerifyingCRC32for Base/libudccnt.so .Sucsfully copied 22filesCVGxIDA for AIX 5.3Updating registry treeundermVaultRegistry .done.database .done.done.Preinstalling ICommitting GUIDn the CommServeo the CommServePreconfiguring CVGxBase0 on the CommServe .done.Preconfiguring CVGxBase on the Co

51、mmServe .done.SimpanaCVGxIDA for AIX 5.3Pleaseselect one storagepolicy for this IDA fromthe list below:1)4)7)WebLogic14D ora_keep_lisdb2oracledir2) ora_keep_lisdb15) ora_recycle_lisdb28) applog3) ora_recycle_lisdb16) weblogicpolicy9) appdata10)13)16)19)22)25)28)31)34)37)40)43)46)lin_bk_oracle AppSvr

52、1_7days_2 LisSvr1_2days_2yea msfs_7days_2years imagedata proxy_log_infinite work_infinit weblogic_nohuplog_ p595_2days_infinit AppSvr1_upgrade_i5SVR_DX3011)14)17)20)23)26)29)32)35)38)41)44)test AppSvr1_infinite LisSvr2_7days msfs_7days_8days mscbs_7days_2month ER_infinite mscbs_infinit OA_msdata_7da

53、ys_2w p595_csLisdb1_upgrade_i5012)15)18)21)24)27)30)33)36)39)42)45)lissvr2 oralcedirAppSvr1_7days_1msfs_7days_2ksmscbs_7days_2monthmsdata_7days_2kFWlogs_works_infin weblogic_nohuplog_ mantains_bak_infin p595_archLisdb1_other_upgraSSApp_image_7dayApp_weblogic_lSSApp_image_infiApp_recyle_1weSApp_weblo

54、gic_lNDMPStoragePolicy: 1 11PreconfiguringSimpanaCVGxIn the CommServe .done.CVGxIDA for AIX 5.3CommcellLevelGlobalFiltersCommcellorder toLevelGlobalFilters are set through Simpana GUIs Control Panel infilter oertain directories or files from backup Commcell-widely.If you turn on the Global filters,

55、they will be effective to the defaultsubcnt. There are three options you can choose to set the filters.1) Use Cell level policyAlwaysDo notuse Global filtersuse Global filtersPlease selecthow to set the Global Filters for the default subcnt? 1Setting selected option for the Global Filters .done.IMPO

56、RTANT:In addition to installing Simpana on this computer, you will also need tocreate a Job Schedule for each iDataAgentcnt computer.s been installed on thisJob Schedules are required to allow the Simpana iDataAgents to performautomated backup and restoreoperations.Job Schedule creation can be admin

57、istrationerface.Adjusting modes and permisplished through the SimpanaCommCellConsoles of Simpana filesSucsfully installed CVGxIDA.10.开始安装Oracle Agent模块Press ENTER to continue .Simpana8.0.0 (BUILD68)AIX5.3Install Simpana on physicalmachine p595_2Selectthe Simpana modulet youwould like to install.1)3)

58、5)7)9)11)13)15)17)19)21)Proxy FileSystemIDA2)4)6)8)10)12)14)16)18)20)Oracle IDA SAPMAXDB IDASybase IDALotus Notes DB IDA Continuous Data Replicator Image IDA for UNIXNDMP Restore Enabler1-Touch Boot Server AgentOracle SA Informix IDADB2 IDAAData ArchiverQsnap Driverfor UNIXNDMP Remote Server Quick R

59、ecovery AgentRecovery Director forUNIXSRMDFile System AgentlassificationUNIX ImageLevel ProxyHost IDAExitModuleStopnumber: 1 2Simpana servi.done.8.0.0 (BUILD68)SimpanaCVGxOrIDA for AIX5.3GettingCommServe ver.done.done.Pack Level .done.Verifying CommServe verGetting CommServe ServiceVerifyingVerifyin

60、g SimpanaCommServeCVGxOrIDAService Pack Level . done. license on the CommServe . done.CVGxOrIDA for AIX 5.3Simpana8.0.0 (BUILD68)CVGxOrIDAfor AIX5.3Binary CopyCopying binaries.100% UnpackingBase64/libobk.a .100% VerifyingCRC32for Base64/libobk.a .Sucsfully copied 27filesSimpanaCVGxOrIDAfor AIX5.3Upd