ORACLE數(shù)據(jù)庫(kù)恢復(fù)演練報(bào)告

Oracle數(shù)據(jù)庫(kù)異機(jī)恢復(fù)測(cè)試報(bào)告北京寶利信通有限公司2009年11月目 錄一.測(cè)試背景3二.測(cè)試概況3l時(shí)間、地點(diǎn)3l測(cè)試主要目的3l主要工作內(nèi)容3三.測(cè)試環(huán)境33.1測(cè)試主機(jī)環(huán)境33.2測(cè)試系統(tǒng)結(jié)構(gòu)圖4四.測(cè)試步驟及結(jié)果44.1 恢復(fù)環(huán)境準(zhǔn)備44.2 建立CommVault 8.0備份服務(wù)器44.4安裝Oracle for AIX和HPUX數(shù)據(jù)庫(kù)244.4.1 硬件環(huán)境244.4.2 軟件環(huán)境244.4.3 軟件安裝244.5安裝Commvault Media agent ,oracle ida for AIX 和HP-UX254.6使用磁帶進(jìn)行Oracle數(shù)據(jù)庫(kù)的全庫(kù)恢復(fù)384.6.1對(duì)核心數(shù)據(jù)庫(kù)（AIX）進(jìn)行恢復(fù)38數(shù)據(jù)庫(kù)的物理恢復(fù)(restore)38數(shù)據(jù)庫(kù)的邏輯恢復(fù)47打開數(shù)據(jù)庫(kù)(open)474.6.2對(duì)財(cái)務(wù)數(shù)據(jù)庫(kù)（HP-UX）進(jìn)行恢復(fù)48數(shù)據(jù)庫(kù)的物理恢復(fù)(restore)48數(shù)據(jù)庫(kù)的邏輯恢復(fù)(recover)55打開數(shù)據(jù)庫(kù)(open)554.7數(shù)據(jù)庫(kù)恢復(fù)后的校驗(yàn)56數(shù)據(jù)庫(kù)基本參數(shù)檢查56應(yīng)用數(shù)據(jù)檢查58一. 測(cè)試背景XX公司核心數(shù)據(jù)庫(kù)采用AIX系統(tǒng)和ORACLE10G數(shù)據(jù)庫(kù)；ERP數(shù)據(jù)庫(kù)系統(tǒng)采用HP-UX 系統(tǒng)和ORACLE10G數(shù)據(jù)庫(kù),采用CommVault備份軟件,結(jié)合LANfree備份方式將Oracle數(shù)據(jù)備份到ADIC Scalar i500磁帶庫(kù)中.此次測(cè)試模擬CommVault備份服務(wù)器、數(shù)據(jù)庫(kù)主機(jī)發(fā)生災(zāi)難后的數(shù)據(jù)恢復(fù)全過(guò)程, 為災(zāi)難恢復(fù)提供經(jīng)驗(yàn)二. 測(cè)試概況l 時(shí)間、地點(diǎn)2009年11月16日11月25日，XX公司l 測(cè)試主要目的驗(yàn)證CommVault備份軟件在主機(jī)發(fā)生災(zāi)難后的可恢復(fù)性驗(yàn)證使用CommVault 軟件備份到磁帶上的數(shù)據(jù)的有效性。l 主要工作內(nèi)容1. 安裝Win2003 Server sp2，建立CommVault 8.0備份服務(wù)器2. 使用CommVault DR工具恢復(fù)備份軟件的配置信息3. 準(zhǔn)備AIX5.3和 HPUX 11.23 操作系統(tǒng)4. 安裝Oracle for AIX和HP-UX 數(shù)據(jù)庫(kù)5. 使用磁帶進(jìn)行Oracle數(shù)據(jù)庫(kù)的全庫(kù)恢復(fù)三. 測(cè)試環(huán)境3.1測(cè)試主機(jī)環(huán)境機(jī)器類型OS版本主機(jī)名IP地址備注IBM AIX5.3P595_3Oracle數(shù)據(jù)庫(kù)(目標(biāo)機(jī))HPUX11.11Lisserv5Oracle數(shù)據(jù)庫(kù)(目標(biāo)機(jī))惠普PC ServerWin 2003ServerCommserv25520CommVault備份服務(wù)器3.2測(cè)試系統(tǒng)結(jié)構(gòu)圖硬件拓?fù)鋱D和軟件分布圖:四. 測(cè)試步驟及結(jié)果4.1 恢復(fù)環(huán)境準(zhǔn)備Commserver 服務(wù)器要求windows 2003sp2AIX 主機(jī)要求和源主機(jī)操作系統(tǒng)一致，oracle 版本和以前一致。HP 主機(jī)要求和源主機(jī)操作系統(tǒng)一致，oracle 版本和以前一致。4.2 建立CommVault 8.0備份服務(wù)器以下過(guò)程是安裝CommServe的詳細(xì)步驟： 1. 將CommServe安裝光盤插入主機(jī)光驅(qū) 2. 在“我的電腦”中，右鍵選擇“自動(dòng)播放”或雙擊光驅(qū)圖標(biāo) 3. 出現(xiàn)如下安裝界面： 4. 選擇“中文”或“英文”均可，選擇“下一步”開始安裝軟件，出現(xiàn)如下界面： 5. 選擇“Install QiNetix on this computer”，開始安裝軟件 6. 在“Welcome”界面中，選擇“Next”，然后在接下來(lái)出現(xiàn)的界面中選擇“OK”確認(rèn)即可 7. 在“License Agreement”中，選擇“I accept the terms in the license agreement”接受許可 8. 在“Select Platforms”中選擇在CommServe上需要安裝的模塊 9. CommVault軟件的安裝需要一些特殊權(quán)限，軟件安裝中會(huì)提示你是否同意設(shè)置這些權(quán)限，選擇“Yes”確定即可 10. 在安裝數(shù)據(jù)實(shí)例的提示界面中，選擇“Yes”開始安裝數(shù)據(jù)庫(kù)實(shí)例 11. 在“Database Engine Installation Path”界面中，確定數(shù)據(jù)庫(kù)引擎的安裝路徑，選擇“Browse”可以修改數(shù)據(jù)庫(kù)引擎安裝路徑 12. 在“MSSQL Database Installation Path”界面中，確定MSSQL數(shù)據(jù)庫(kù)安裝路徑，選擇“Browse”可以修改MSSQL數(shù)據(jù)庫(kù)的安裝路徑 13. 開始安裝數(shù)據(jù)庫(kù)引擎 14. 在“SQL User Password”界面中設(shè)置SQL用戶的口令 15. 如果你的系統(tǒng)中已經(jīng)安裝了其它版本的JRE，安裝程序會(huì)推薦你安裝一個(gè)高版本的JRE 16. 如果接受推薦，軟件開始安裝Java環(huán)境 17. 在“Destination Folder”界面中選擇軟件的安裝路徑，選擇“Browes”可以修改軟件的安裝路徑 18. 在“CommServe Database Path”界面中確定CommServe數(shù)據(jù)庫(kù)的路徑，選擇“Browse”可以修改CommServe數(shù)據(jù)庫(kù)的安裝路徑 19. 在“CommServe Name”中指定CommServe的客戶端名稱和主機(jī)名 20. 在“CommServe Disaster Recovery Path”界面中指定災(zāi)難恢復(fù)文件的路徑，選擇“Browse”指定災(zāi)難恢復(fù)文件的路徑 21. 在“Firewall Configuration”界面中可以配置防火墻，通常選擇不配置防火墻 22. 在“Apply a License”中指定正式許可證文件的路徑或選擇使用Demo許可證 23. 在“Administrator Account”中配置登錄CommCell Console的“帳戶”和“口令” 24. 在“Media Password”中輸入訪問(wèn)介質(zhì)的口令 25. 選擇“Yes”確認(rèn)配置CommCell Console Web管理 26. 在“Web Administration”中輸入一個(gè)別名 27. 在“MediaAgent Index Cache Path”中配置Index Cache的路徑，選擇“Browse”可以修改Index Cache的存放路徑 28. 在“Job Results Path”界面中配置客戶端的作業(yè)結(jié)果存放路徑，選擇“Browse”可以修改存放路進(jìn) 29. 在“Snap Driver Default Volume”界面中配置存儲(chǔ)snap位圖的分區(qū)或卷 30. 在“Summary”界面中選擇“Next”確認(rèn)你的配置并繼續(xù)安裝 31. 軟件安裝到這個(gè)過(guò)程，系統(tǒng)會(huì)提示需要注銷一次，選擇“LogOff”確認(rèn)注銷 32. 系統(tǒng)注銷完成后，軟件的安裝過(guò)程會(huì)自動(dòng)進(jìn)行，如如下界面所示： 33. 在“Automatic Updates schedule”界面中，如果需要配置自動(dòng)更新的調(diào)度計(jì)劃，可以選中“Schedule FTP Download of Automatic Updates”并配置時(shí)間表，建議不要配置 34. 軟件安裝到這里，系統(tǒng)會(huì)提示你是否刪除先前安裝中設(shè)置的特殊權(quán)限，選擇“Yes”確認(rèn)刪除 35. 在“Install Updates schedule”界面中選擇不配置“Schedule Install of Automatic Updates” 36. 在系統(tǒng)提示軟件安裝后需要重啟服務(wù)器界面中，選擇“OK”確定 37. 在“Schedule Reminder”界面中選擇“Next”即可 38. 在“Completion Report”界面出現(xiàn)后，選擇“Reboot Now”或“Finish”完成軟件的安裝 39. 軟件安裝完成，重啟服務(wù)器。 4.4安裝Oracle for AIX和HPUX數(shù)據(jù)庫(kù)4.4.1 硬件環(huán)境主機(jī)Ap595a24 CPU93696M Memmary主機(jī)Bp595b24 CPU93696M Memmary4.4.2 軟件環(huán)境操作系統(tǒng)AIX 5300-09集群軟件HACMP 數(shù)據(jù)庫(kù)Oracle 升級(jí)補(bǔ)丁4.4.3 軟件安裝1.安裝前準(zhǔn)備：操作系統(tǒng)環(huán)境；HACMP 需求環(huán)境；JDK,C+需求環(huán)境2.創(chuàng)建oracle用戶創(chuàng)建用戶組組名組IDoinstall300dba301hagsuser302創(chuàng)建用戶用戶名oracle用戶ID300屬組dba oinstall hagsuser用戶目錄/oracle3.Oracle 軟件安裝4.5安裝Commvault Media agent ,oracle ida for AIX 和HP-UX1.運(yùn)行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 協(xié)議：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.開始安裝軟件到物理結(jié)點(diǎn)上：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.選擇相應(yīng)的網(wǎng)卡作為備份接口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