ORACLE数据库恢复演练报告

Oracle数据库异机恢复测试报告北京宝利信通有限公司2009年11月目 录一.测试背景3二.测试概况3l时间、地点3l测试主要目的3l主要工作内容3三.测试环境33.1测试主机环境33.2测试系统结构图4四.测试步骤及结果44.1 恢复环境准备44.2 建立CommVault 8.0备份服务器44.4安装Oracle for AIX和HPUX数据库244.4.1 硬件环境244.4.2 软件环境244.4.3 软件安装244.5安装Commvault Media agent ,oracle ida for AIX 和HP-UX254.6使用磁带进行Oracle数据库的全库恢复384.6.1对核心数据库（AIX）进行恢复38数据库的物理恢复(restore)38数据库的逻辑恢复47打开数据库(open)474.6.2对财务数据库（HP-UX）进行恢复48数据库的物理恢复(restore)48数据库的逻辑恢复(recover)55打开数据库(open)554.7数据库恢复后的校验56数据库基本参数检查56应用数据检查58一. 测试背景XX公司核心数据库采用AIX系统和ORACLE10G数据库；ERP数据库系统采用HP-UX 系统和ORACLE10G数据库,采用CommVault备份软件,结合LANfree备份方式将Oracle数据备份到ADIC Scalar i500磁带库中.此次测试模拟CommVault备份服务器、数据库主机发生灾难后的数据恢复全过程, 为灾难恢复提供经验二. 测试概况l 时间、地点2009年11月16日11月25日，XX公司l 测试主要目的验证CommVault备份软件在主机发生灾难后的可恢复性验证使用CommVault 软件备份到磁带上的数据的有效性。l 主要工作内容1. 安装Win2003 Server sp2，建立CommVault 8.0备份服务器2. 使用CommVault DR工具恢复备份软件的配置信息3. 准备AIX5.3和 HPUX 11.23 操作系统4. 安装Oracle for AIX和HP-UX 数据库5. 使用磁带进行Oracle数据库的全库恢复三. 测试环境3.1测试主机环境机器类型OS版本主机名IP地址备注IBM AIX5.3P595_3Oracle数据库(目标机)HPUX11.11Lisserv5Oracle数据库(目标机)惠普PC ServerWin 2003ServerCommserv25520CommVault备份服务器3.2测试系统结构图硬件拓扑图和软件分布图:四. 测试步骤及结果4.1 恢复环境准备Commserver 服务器要求windows 2003sp2AIX 主机要求和源主机操作系统一致，oracle 版本和以前一致。HP 主机要求和源主机操作系统一致，oracle 版本和以前一致。4.2 建立CommVault 8.0备份服务器以下过程是安装CommServe的详细步骤： 1. 将CommServe安装光盘插入主机光驱 2. 在“我的电脑”中，右键选择“自动播放”或双击光驱图标 3. 出现如下安装界面： 4. 选择“中文”或“英文”均可，选择“下一步”开始安装软件，出现如下界面： 5. 选择“Install QiNetix on this computer”，开始安装软件 6. 在“Welcome”界面中，选择“Next”，然后在接下来出现的界面中选择“OK”确认即可 7. 在“License Agreement”中，选择“I accept the terms in the license agreement”接受许可 8. 在“Select Platforms”中选择在CommServe上需要安装的模块 9. CommVault软件的安装需要一些特殊权限，软件安装中会提示你是否同意设置这些权限，选择“Yes”确定即可 10. 在安装数据实例的提示界面中，选择“Yes”开始安装数据库实例 11. 在“Database Engine Installation Path”界面中，确定数据库引擎的安装路径，选择“Browse”可以修改数据库引擎安装路径 12. 在“MSSQL Database Installation Path”界面中，确定MSSQL数据库安装路径，选择“Browse”可以修改MSSQL数据库的安装路径 13. 开始安装数据库引擎 14. 在“SQL User Password”界面中设置SQL用户的口令 15. 如果你的系统中已经安装了其它版本的JRE，安装程序会推荐你安装一个高版本的JRE 16. 如果接受推荐，软件开始安装Java环境 17. 在“Destination Folder”界面中选择软件的安装路径，选择“Browes”可以修改软件的安装路径 18. 在“CommServe Database Path”界面中确定CommServe数据库的路径，选择“Browse”可以修改CommServe数据库的安装路径 19. 在“CommServe Name”中指定CommServe的客户端名称和主机名 20. 在“CommServe Disaster Recovery Path”界面中指定灾难恢复文件的路径，选择“Browse”指定灾难恢复文件的路径 21. 在“Firewall Configuration”界面中可以配置防火墙，通常选择不配置防火墙 22. 在“Apply a License”中指定正式许可证文件的路径或选择使用Demo许可证 23. 在“Administrator Account”中配置登录CommCell Console的“帐户”和“口令” 24. 在“Media Password”中输入访问介质的口令 25. 选择“Yes”确认配置CommCell Console Web管理 26. 在“Web Administration”中输入一个别名 27. 在“MediaAgent Index Cache Path”中配置Index Cache的路径，选择“Browse”可以修改Index Cache的存放路径 28. 在“Job Results Path”界面中配置客户端的作业结果存放路径，选择“Browse”可以修改存放路进 29. 在“Snap Driver Default Volume”界面中配置存储snap位图的分区或卷 30. 在“Summary”界面中选择“Next”确认你的配置并继续安装 31. 软件安装到这个过程，系统会提示需要注销一次，选择“LogOff”确认注销 32. 系统注销完成后，软件的安装过程会自动进行，如如下界面所示： 33. 在“Automatic Updates schedule”界面中，如果需要配置自动更新的调度计划，可以选中“Schedule FTP Download of Automatic Updates”并配置时间表，建议不要配置 34. 软件安装到这里，系统会提示你是否删除先前安装中设置的特殊权限，选择“Yes”确认删除 35. 在“Install Updates schedule”界面中选择不配置“Schedule Install of Automatic Updates” 36. 在系统提示软件安装后需要重启服务器界面中，选择“OK”确定 37. 在“Schedule Reminder”界面中选择“Next”即可 38. 在“Completion Report”界面出现后，选择“Reboot Now”或“Finish”完成软件的安装 39. 软件安装完成，重启服务器。 4.4安装Oracle for AIX和HPUX数据库4.4.1 硬件环境主机Ap595a24 CPU93696M Memmary主机Bp595b24 CPU93696M Memmary4.4.2 软件环境操作系统AIX 5300-09集群软件HACMP 数据库Oracle 升级补丁4.4.3 软件安装1.安装前准备：操作系统环境；HACMP 需求环境；JDK,C+需求环境2.创建oracle用户创建用户组组名组IDoinstall300dba301hagsuser302创建用户用户名oracle用户ID300属组dba oinstall hagsuser用户目录/oracle3.Oracle 软件安装4.5安装Commvault Media agent ,oracle ida for AIX 和HP-UX1.运行cvpkgadd 命令：p595_2/mnt#./cvpkgaddRestarting in pdksh-v5.2.14. Simpana 8.0.0 (BUILD68) AIX 5.3- CommVault _ _ / _(_)_ _ _ _ _ _ _ _ _ _ _ | | _ _ | _ / _ | _ / _ | _ | | | | | | | |_) | (_| | | | | (_| | _/|_|_| |_| |_| ._/ _,_|_| |_|_,_| |_| 8.0.0(BUILD68) Welcome to CommVault Systems, Inc. Simpana.For support please visit /support, or send an email , or call US/CANADA (Toll Free) (877) 780-3077; INTERNATIONAL (732) 571-2160. This script will install Simpana backup system on this machine. Log messages will be sent to /tmp/.gxsetup/cvpkgadd.log. Press to start . 2.接受license 协议：Simpana 8.0.0 (BUILD68) AIX 5.3-EULA Press to review Simpana End User License Agreement . Simpana 8.0.0 (BUILD68) AIX 5.3- CommVault Systems, Inc. End User License and Limited Warranty Agreement CommVault(r) Simpana(r) Software Release 8.0.0 (including Microsoft(r) SQL Server(tm) 2005 Enterprise Edition, SQL Server(tm) 2005 Express Edition and Windows Pre-Installation Environment) End User License Agreement IMPORTANT- READ CAREFULLY: THIS END USER LICENSE AGREEMENT (EU- LA) IS A LEGAL AGREEMENT BETWEEN YOU (EITHER AS AN INDIVIDUAL OR ENTITY) (YOU ) AND COMMVAULT SYSTEMS, INC. (COMMVAULT) FOR THE ABOVE-REFERENCED SOFTWARE PRODUCT(S), WHICH INCLUDES COMPUTER SOFTWARE AND MAY INCLUDE ASSOCIATED MEDIA, AND ONLINE OR ELEC- TRONIC DOCUMENTATION (SOFTWARE). BY INSTALLING, COPYING OR OTH- ERWISE USING THE SOFTWARE, YOU AGREE TO BE BOUND BY THE TERMS OF THIS EULA. IF YOU DO NOT AGREE TO THE TERMS OF THIS EULA, DO NOT INSTALL OR USE THE SOFTWARE. YOU SHALL INFORM ALL USERS OF THE SOFTWARE OF THE TERMS AND CONDITIONS OF THIS EULA. Copyright Acknowledgment (c)1997-2008 CommVault Systems, Inc. All rights reserved.Do you accept the terms of this license agreement? Yes3.开始安装软件到物理结点上：Simpana 8.0.0 (BUILD68) AIX 5.3-Cluster SupportCertain Simpana packages can be associated with a virtual IP, or in other words, installed on a virtual machine belonging to some cluster. At any given time the virtual machines services and IP address are active on only one of the clusters servers. The virtual machine can fail-over from one server to another, which includes stopping services and deactivating IP address on the first server and activating the IP address/services on the other server.You now have a choice of performing a regular Simpana install on the physical host or installing Simpana on a virtual machine for operation within a cluster.Most users should select Install on a physical machine here. 1) Install on a physical machine 2) Install on a virtual machine 3) Exit this menuYour choice: 1 Simpana 8.0.0 (BUILD68) AIX 5.3-Physical Machine Host NameNetwork interfaces with the following IPs have been found available on your system. One of these interfaces should be associated with the physical machinebeing installed. It will also be used by the CommServe to initiate connectionsto the physical machine. Note that you will be able to additionally customize Datapipe Interface Pairs used for the backup data traffic later in the SimpanaJava GUI.4.选择相应的网卡作为备份接口Please select the correct network interface below. 1) p595_2 (3) 2) p595_com (04)Interface number: 1 Simpana 8.0.0 (BUILD68) AIX 5.3-Physical Machine Host NamePlease verify the physical machine interface name below. Make it as complete (with fully qualified domain name) as possible.Physical Machine Host Name: p595_2 Simpana 8.0.0 (BUILD68) AIX 5.3-Physical Machine Client NamePlease specify the client name for this machine.It does not have to be the network host name: you can enter any word here without spaces. The only requirement is that it must be unique on the CommServe.Physical Machine Client Name: p595_2 Simpana 8.0.0 (BUILD68) AIX 5.3-Install Simpana on physical machine p595_25.选择需要安装的模块：Select the Simpana module that you would like to install. 1) Media Agent 2) FileSystem IDA 3) Proxy FileSystem IDA 4) Oracle IDA 5) Oracle SAP IDA 6) SAPMAXDB IDA 7) Informix IDA 8) Sybase IDA 9) DB2 IDA 10) Lotus Notes DB IDA 11) Data Archiver for UNIX 12) Continuous Data Replicator 13) Qsnap Driver 14) Image IDA for UNIX 15) NDMP Remote Server 16) NDMP Restore Enabler 17) Quick Recovery Agent 18) 1-Touch Boot Server Agent 19) Recovery Director for UNIX 20) SRM File System Agent 21) UNIX ImageLevel ProxyHost IDA 22) Data Classification 23) ExitModule number: 1 Simpana 8.0.0 (BUILD68) CVGxMA for AIX 5.3-Dependency CheckHere is a list and status of the dependent modules: 1) Base0 Module NOT installed 2) Base Module NOT installedProceeding with install/upgrade of the dependent modules .Simpana 8.0.0 (BUILD68) CVGxBase0 for AIX 5.3-Verifying binary compatibility .done.Simpana CVGxBase0 for AIX 5.3-Simpana Installation DirectoryPlease specify where you want us to install Simpana binaries.It must be a local directory and there should be at least 180MB of free space available. All files will be installed in a simpana subdirectory, so if you enter /opt, the files will actually be placed into /opt/simpana.6.选择安装路径：Installation Directory: /opt Simpana will be installed in /opt/simpana.Simpana CVGxBase0 for AIX 5.3-Simpana Log DirectoryPlease specify where you want to keep Simpana log files.It must be a local directory and there should be at least 100MB of free space available. All log files will be created in a simpana/Log_Files subdirectory, so if you enter /var/log, the logs will actually be placed into /var/log/simpana/Log_Files.Log Directory: /var/log Simpana log files will be created in /var/log/simpana/Log_Files.Simpana CVGxBase0 for AIX 5.3-Simpana GroupMost of Simpana processes run with root privileges, but some are launched by databases and inherit database access rights. To make sure that registry and log files can be written to by both kinds of processes we can either make suchfiles world-writeable or we can grant write access only to processes belongingto a particular group, e.g. a simpana or a dba group.We highly recommend now that you create a new user group and enter its name inthe next setup screen. If you choose not to assign a dedicated group to Simpana processes, all temporary and configuration files will be created with -rw-rw-rw permissions.If youre planning to backup Oracle DB you should use dba group.Would you like to assign a specific group to Simpana? yes noSimpana 8.0.0 (BUILD68) CVGxBase0 for AIX 5.3-Binary Copy7.开始安装软件BASE模块：Copying binaries .100% Unpacking Base64/libSnooper.so . 100% Verifying CRC32 for Base/cvfwd . Successfully copied 250 filesSimpana CVGxBase0 for AIX 5.3-Creating registry tree under /etc/CommVaultRegistry . done.Installing startup scripts into /etc and modifying /etc/inittab . done.Creating /opt/simpana/Base/simpana .done.Creating /usr/bin/simpana .done.Creating /usr/bin/cvpkgrm .done.Creating /usr/bin/cvpkgcheck .done.Creating /usr/sbin/simpana .done.Creating /usr/sbin/cvpkgrm .done.Creating /usr/sbin/cvpkgcheck .done.Adjusting modes and permissions of Simpana filesSuccessfully installed CVGxBase0Proceeding with CVGxBase install . Simpana 8.0.0 (BUILD68) CVGxBase for AIX 5.3-Simpana 8.0.0 (BUILD68) CVGxBase for AIX 5.3-Instance Port NumbersEvery instance of Simpana should use a unique set of network ports to avoid interfering with other instances running on the same machine.The port numbers selected must be from the reserved port number range and havenot been registered by another application on this machine.Please enter the port numbers.Port Number for CVD : 8400 Port Number for EvMgrC: 8402 Simpana 8.0.0 (BUILD68) CVGxBase for AIX 5.3-Simpana Firewall ConfigVarious Simpana components need to communicate with each other: iDataAgents and MediaAgents establish connections to CommServe and talk to each other as well. If any of the involved parties are situated on the opposite sides of a firewall, Simpana should be made aware of it so that it could bind its pipeline sockets to open ports and could establish tunnels for control traffic.You must configure Simpana firewall services if there are other Simpana machines, which are expected to communicate with this one.Do you want to configure Simpana firewall services? no Simpana 8.0.0 (BUILD68) CVGxBase for AIX 5.3-CommServe Host NamePlease enter the hostname of the Simpana CommServe. It can be either short or long; the only requirement is that it must be resolvable by the name services configured on this machine.CommServe Name: commserv255Simpana 8.0.0 (BUILD68) CVGxBase for AIX 5.3-CommServe CheckCommServe: commserv255Trying to contact CommServe commserv255 1 of 3 .done.Validating client name and hostname from CommServe .done.Checking if CS is enabled for install authentication .done.Getting CommServe version .done.Verifying CommServe version .done.Getting CommServe Service Pack Level .done.Verifying CommServe Service Pack Level . done.Simpana CVGxBase for AIX 5.3-Simpana CVGxBase for AIX 5.3-Simpana Job Results DirectoryPlease specify the name for the JobResults directory.It must be a local directory and there should