ORACLE数据库恢复演练报告资料

Oracle数据库异机恢复
测试报告
北京宝利信通有限公司
2009年11月
目录
一.测试背景 (3)
二.测试概况 (3)
●时间、地点 (3)
●测试主要目的 (3)
●主要工作内容 (3)
三.测试环境 (3)
3.1测试主机环境 (3)
3.2测试系统结构图 (4)
四.测试步骤及结果 (4)
4.1 恢复环境准备 (4)
4.2 建立CommVault 8.0备份服务器 (4)
4.4安装Oracle 10.0.2.0 for AIX和HPUX数据库 (24)
4.4.1 硬件环境 (24)
4.4.2 软件环境 (24)
4.4.3 软件安装 (24)
4.5安装Commvault Media agent ,oracle ida for AIX 和HP-UX (25)
4.6使用磁带进行Oracle数据库的全库恢复 (38)
4.6.1对核心数据库（AIX）进行恢复 (38)
➢数据库的物理恢复(restore) (38)
➢数据库的逻辑恢复 (47)
➢打开数据库(open) (47)
4.6.2对财务数据库（HP-UX）进行恢复 (48)
➢数据库的物理恢复(restore) (48)
➢数据库的逻辑恢复(recover) (55)
➢打开数据库(open) (55)
4.7数据库恢复后的校验 (56)
➢数据库基本参数检查 (56)
➢应用数据检查 (58)
一.测试背景
XX公司核心数据库采用AIX系统和ORACLE10G数据库；ERP数据库系统采用HP-UX 系统和ORACLE10G数据库,采用CommVault备份软件,结合LANfree备份方式将Oracle数据备份到ADIC Scalar i500磁带库中.
此次测试模拟CommVault备份服务器、数据库主机发生灾难后的数据恢复全过程, 为灾难恢复提供经验
二.测试概况
●时间、地点
2009年11月16日~11月25日，XX公司
●测试主要目的
验证CommVault备份软件在主机发生灾难后的可恢复性
验证使用CommVault 软件备份到磁带上的数据的有效性。

●主要工作内容
1. 安装Win2003 Server sp2，建立CommVault 8.0备份服务器
2. 使用CommVault DR工具恢复备份软件的配置信息
3. 准备AIX5.3和HPUX 11.23 操作系统
4. 安装Oracle 10.0.2.0 for AIX和HP-UX 数据库
5. 使用磁带进行Oracle数据库的全库恢复
三.测试环境
3.1测试主机环境
惠普PC Server Win 2003Server Commserv255 10.0.5.120 CommVault
备份服务器3.2测试系统结构图
硬件拓扑图和软件分布图:
四.测试步骤及结果
4.1 恢复环境准备
Commserver 服务器要求windows 2003sp2
AIX 主机要求和源主机操作系统一致，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 10.0.2.0 for AIX和HPUX数据库
4.4.1 硬件环境
主机A p595a 24 CPU 93696M Memmary 主机B p595b 24 CPU 93696M Memmary
4.4.2 软件环境
操作系统AIX 5300-09 集群软件HACMP 5.4.1.3
数据库Oracle 10.2.0.1 升级补丁10.2.0.4
4.4.3 软件安装
1.安装前准备：操作系统环境；HACMP 需求环境；JDK,C++需求环境
2.创建oracle用户
创建用户组
组名组ID
oinstall 300
创建用户
4.5安装Commvault Media agent ,oracle ida for AIX 和HP-UX
1.运行cvpkgadd 命令：
[p595_2][/mnt]#./cvpkgadd
Restarting 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 to *********************,orcallUS/CANADA(TollFree)(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.757882.
Press <ENTER> to start ...
2.接受license 协议：
Simpana 8.0.0 (BUILD68) AIX 5.3 ------------------------------------------------------------------------------- EULA
Press <ENTER> 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? Yes
3.开始安装软件到物理结点上：
Simpana 8.0.0 (BUILD68) AIX 5.3 ------------------------------------------------------------------------------- Cluster Support
Certain 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 machine's services and IP address are active on only one of the cluster's 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 menu
Your choice: [1]
Simpana 8.0.0 (BUILD68) AIX 5.3 ------------------------------------------------------------------------------- Physical Machine Host Name
Network interfaces with the following IPs have been found available on your system. One of these interfaces should be associated with the physical machine being installed. It will also be used by the CommServe to initiate connections to the physical machine. Note that you will be able to additionally customize Datapipe Interface Pairs used for the backup data traffic later in the Simpana Java GUI.
4.选择相应的网卡作为备份接口
Please select the correct network interface below.
1) p595_2 (10.0.5.53)
2) p595_com (192.168.2.104)
Interface number: [1]
Simpana 8.0.0 (BUILD68) AIX 5.3 ------------------------------------------------------------------------------- Physical Machine Host Name
Please 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 Name
Please 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_2
5.选择需要安装的模块：
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) Exit
Module number: [1]
Simpana 8.0.0 (BUILD68) CVGxMA for AIX 5.3 ------------------------------------------------------------------------------- Dependency Check
Here is a list and status of the dependent modules:
1) Base0 Module NOT installed
2) Base Module NOT installed
Proceeding with install/upgrade of the dependent modules ...
Simpana 8.0.0 (BUILD68) CVGxBase0 for AIX 5.3 ------------------------------------------------------------------------------- Verifying binary compatibility ...done.
Simpana <- config -> CVGxBase0 for AIX 5.3 ------------------------------------------------------------------------------- Simpana Installation Directory
Please 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 <- config -> CVGxBase0 for AIX 5.3 ------------------------------------------------------------------------------- Simpana Log Directory
Please 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 <- config -> CVGxBase0 for AIX 5.3 ------------------------------------------------------------------------------- Simpana Group
Most 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 such files world-writeable or we can grant write access only to processes belonging to 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 in the 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 you're planning to backup Oracle DB you should use "dba" group.
Would you like to assign a specific group to Simpana? [yes] no
Simpana 8.0.0 (BUILD68) CVGxBase0 for AIX 5.3 ------------------------------------------------------------------------------- Binary Copy
7.开始安装软件BASE模块：
Copying binaries ...
[100%] Unpacking Base64/libSnooper.so ... [100%] Verifying CRC32 for Base/cvfwd ...
Successfully copied 250 files
Simpana <- postinstall -> 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 files
Successfully installed CVGxBase0
Proceeding 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 Numbers
Every 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 have not 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 Config
Various 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 Name
Please 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: commserv255
Simpana 8.0.0 (BUILD68) CVGxBase for AIX 5.3 ------------------------------------------------------------------------------- CommServe Check
CommServe: commserv255
Trying 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 <- config -> CVGxBase for AIX 5.3 ------------------------------------------------------------------------------- Simpana <- config -> CVGxBase for AIX 5.3 ------------------------------------------------------------------------------- Simpana Job Results Directory
Please specify the name for the JobResults directory.
It must be a local directory and there should be at least 20MB of free space available. It will be used to store intermediate data that should be passed from one backup phase to another.
JobResults Directory: [/opt/simpana/iDataAgent/jobResults]
Directory "/opt/simpana/iDataAgent/jobResults" does not exist.
Do you want us to create it? [yes]
Simpana job results files will be created in
/opt/simpana/iDataAgent/jobResults.
Simpana <- postinstall -> CVGxBase for AIX 5.3 ------------------------------------------------------------------------------- Fetching client GUID from the CommServe ... done.
Creating common registry under /etc/CommVaultRegistry/Common ... done.
Creating registry tree under /etc/CommVaultRegistry ... done.
Trying to contact CommServe commserv255 [1 of 3] ...done.
Creating Job Results directory ... done.
Adjusting modes and permissions of Simpana files
Successfully installed CVGxBase
8.开始安装软件Media Agent模块
Proceeding with CVGxMA install ...
Stopping Simpana services ...done.
Simpana 8.0.0 (BUILD68) CVGxMA for AIX 5.3 ------------------------------------------------------------------------------- Getting CommServe version ...done.
Verifying CommServe version ...done.
Getting CommServe Service Pack Level ...done.
Verifying CommServe Service Pack Level ... done.
Verifying CVGxMA license on the CommServe ... done.
Simpana <- config -> CVGxMA for AIX 5.3 ------------------------------------------------------------------------------- Simpana 8.0.0 (BUILD68) CVGxMA for AIX 5.3 ------------------------------------------------------------------------------- Binary Copy
Copying binaries ...
[100%] Unpacking MediaAgent/locatedevice.sh ... [100%] Verifying CRC32 for MediaAgent/locatedevice.sh ...
Successfully copied 92 files
Simpana <- postinstall -> CVGxMA for AIX 5.3 ------------------------------------------------------------------------------- Adding service CvMountd to /etc/services ... done.
Updating registry tree under /etc/CommVaultRegistry ... done.
Preconfiguring MediaAgent on the CommServe ... done.
Simpana <- postinstall -> CVGxMA for AIX 5.3 ------------------------------------------------------------------------------- Index Cache Directory
MediaAgent maintains a cache of indices for completed backups. Normally
they're stored in /opt/simpana/MediaAgent/IndexCache directory, but you can keep them anywhere. You can even make an IndexCache directory shared by two or more MediaAgents.
IndexCache directory should have at least 256MB of free space.
Please specify where you want us to store the Index Cache.
Index Cache Directory: [/opt/simpana/MediaAgent/IndexCache]
Directory "/opt/simpana/MediaAgent/IndexCache" does not exist.
Do you want us to create it? [yes]
Configuring IndexCache directory /opt/simpana/MediaAgent/IndexCache ...done. Creating CvMountd service ... done.
Detecting media changer devices. Please be patient...
Preconfiguring CVGxBase0 on the CommServe ...done.
Preconfiguring CVGxBase on the CommServe ...done.
Adjusting modes and permissions of Simpana files
Successfully installed CVGxMA.
Press ENTER to continue ...
Simpana 8.0.0 (BUILD68) AIX 5.3 ------------------------------------------------------------------------------- Install Simpana on physical machine p595_2
9.开始安装软件Filesystem Agent模块
Select the Simpana module that you would like to install.
1) FileSystem IDA 2) Proxy FileSystem IDA
3) Oracle IDA 4) Oracle SAP IDA
5) SAPMAXDB IDA 6) Informix IDA
7) Sybase IDA 8) DB2 IDA
9) Lotus Notes DB IDA 10) Data Archiver for UNIX
11) Continuous Data Replicator 12) Qsnap Driver
13) Image IDA for UNIX 14) NDMP Remote Server
15) NDMP Restore Enabler 16) Quick Recovery Agent
17) 1-Touch Boot Server Agent 18) Recovery Director for UNIX
19) SRM File System Agent 20) UNIX ImageLevel ProxyHost IDA
21) Data Classification 22) Exit
Module number: [1]
Stopping Simpana services ...done.
Simpana 8.0.0 (BUILD68) CVGxIDA for AIX 5.3 ------------------------------------------------------------------------------- Getting CommServe version ...done.
Verifying CommServe version ...done.
Getting CommServe Service Pack Level ...done.
Verifying CommServe Service Pack Level ... done.
Verifying CVGxIDA license on the CommServe ... done.
Simpana <- config -> CVGxIDA for AIX 5.3 ------------------------------------------------------------------------------- Simpana 8.0.0 (BUILD68) CVGxIDA for AIX 5.3 ------------------------------------------------------------------------------- Binary Copy
Copying binaries ...
[100%] Unpacking Base/libudcclient.so ...
[100%] Verifying CRC32 for Base/libudcclient.so ...
Successfully copied 22 files
Simpana <- postinstall -> CVGxIDA for AIX 5.3 ------------------------------------------------------------------------------- Updating registry tree under /etc/CommVaultRegistry ... done.
Preinstalling IDA on the CommServe ...done.
Committing GUID into the CommServe database ...done.
Preconfiguring CVGxBase0 on the CommServe ...done.
Preconfiguring CVGxBase on the CommServe ...done.
Simpana <- postinstall -> CVGxIDA for AIX 5.3 ------------------------------------------------------------------------------- Please select one storage policy for this IDA from the list below:
1) WebLogic14D 2) ora_keep_lisdb1 3) ora_recycle_lisdb1
4) ora_keep_lisdb2 5) ora_recycle_lisdb2 6) weblogicpolicy
7) oracledir 8) applog 9) appdata
10) lin_bk_oracle 11) test 12) lissvr2 oralcedir
13) AppSvr1_7days_2wee 14) AppSvr1_infinite 15) AppSvr1_7days_1wee
16) LisSvr1_2days_2yea 17) LisSvr2_7days 18) msfs_7days_2weeks
19) msfs_7days_2years 20) msfs_7days_8days 21) mscbs_7days_2month
22) imagedata 23) mscbs_7days_2month 24) msdata_7days_2week
25) proxy_log_infinite 26) ER_infinite 27) FWlogs_works_infin
28) work_infinit 29) mscbs_infinit 30) weblogic_nohuplog_
31) weblogic_nohuplog_ 32) OA_msdata_7days_2w 33) mantains_bak_infin
34) p595_2days_infinit 35) p595_cs 36) p595_arch
37) AppSvr1_upgrade_i5 38) Lisdb1_upgrade_i50 39) Lisdb1_other_upgra
40) ERPSVR_DX30 41) StatApp_image_7day 42) StatApp_image_infi
43) StatApp_weblogic_l 44) StatApp_weblogic_l 45) StatApp_recyle_1we
46) NDMP
Storage Policy: [1] 11
Preconfiguring CVGxIDA on the CommServe ...done.
Simpana <- postinstall -> CVGxIDA for AIX 5.3 ------------------------------------------------------------------------------- Commcell Level Global Filters
Commcell Level Global Filters are set through Simpana GUI's Control Panel in order to filter out certain directories or files from backup Commcell-widely. If you turn on the Global filters, they will be effective to the default subclient. There are three options you can choose to set the filters.
1) Use Cell level policy
2) Always use Global filters
3) Do not use Global filters
Please select how to set the Global Filters for the default subclient? [1]
Setting selected option for the Global Filters ...done.
IMPORTANT:
In addition to installing Simpana on this computer, you will also need to
create a Job Schedule for each iDataAgent that has been installed on this client computer.
Job Schedules are required to allow the Simpana iDataAgents to perform automated backup and restore operations.
Job Schedule creation can be accomplished through the Simpana CommCell Console administration interface.
Adjusting modes and permissions of Simpana files
Successfully installed CVGxIDA.
10.开始安装软件Oracle Agent模块
Press ENTER to continue ...
Simpana 8.0.0 (BUILD68) AIX 5.3 ------------------------------------------------------------------------------- Install Simpana on physical machine p595_2
Select the Simpana module that you would like to install.
1) Proxy FileSystem IDA 2) Oracle IDA
3) Oracle SAP IDA 4) SAPMAXDB IDA
5) Informix IDA 6) Sybase IDA
7) DB2 IDA 8) Lotus Notes DB IDA
9) Data Archiver for UNIX 10) Continuous Data Replicator
11) Qsnap Driver 12) Image IDA for UNIX
13) NDMP Remote Server 14) NDMP Restore Enabler
15) Quick Recovery Agent 16) 1-Touch Boot Server Agent
17) Recovery Director for UNIX 18) SRM File System Agent
19) UNIX ImageLevel ProxyHost IDA 20) Data Classification
21) Exit
Module number: [1] 2
Stopping Simpana services ...done.
Simpana 8.0.0 (BUILD68) CVGxOrIDA for AIX 5.3 ------------------------------------------------------------------------------- Getting CommServe version ...done.
Verifying CommServe version ...done.
Getting CommServe Service Pack Level ...done.
Verifying CommServe Service Pack Level ... done.
Verifying CVGxOrIDA license on the CommServe ... done.
Simpana <- config -> CVGxOrIDA for AIX 5.3 -------------------------------------------------------------------------------
Simpana 8.0.0 (BUILD68) CVGxOrIDA for AIX 5.3 ------------------------------------------------------------------------------- Binary Copy
Copying binaries ...
[100%] Unpacking Base64/libobk.a ...
[100%] Verifying CRC32 for Base64/libobk.a ...
Successfully copied 27 files
Simpana <- postinstall -> CVGxOrIDA for AIX 5.3 ------------------------------------------------------------------------------- Updating registry tree under /etc/CommVaultRegistry ... done.
Preconfiguring CVGxOrIDA on the CommServe ...done.
Simpana <- postinstall -> CVGxOrIDA for AIX 5.3 ------------------------------------------------------------------------------- IMPORTANT
If you are planning to use Simpana CVGxOrIDA with several instances of the database, each running on behalf of different UNIX users, you must make sure that:
1) All database users have been added to each of the database groups
involved. For example, if there is a "db2inst1" user from group "dba1"
and "db2inst2" user from group "dba2", then both "db2inst1" and
"db2inst2" should be included into "dba1" and "dba2" groups. On most
UNIXes this can be accomplished by editing the /etc/group file.
2) The .profile of each database user must contains a "umask 002" command
at the end, which will guarantee that all files created by one database user can be open for writing by other database users.
If all of the above requirements are not fulfilled, Simpana will run into various "Permission denied" errors, and backups will not work.
Adjusting modes and permissions of Simpana files
Successfully installed CVGxOrIDA.
4.6使用磁带进行Oracle数据库的全库恢复
4.6.1对核心数据库（AIX）进行恢复
➢数据库的物理恢复(restore)
1. 启动Oracle数据库到nomount状态(新建pfile文件lisdbinit.ora)
#su – oracle
$sqlplus “/ as sysdba”
SQL> shutdown immediate;
SQL> startup nomount from pfile =‘/home/oracle/lisdbinit.ora’;
2.restore控制文件 & SPFILE文件
●浏览原数据库的备份数据
●选择“目标客户端”、“恢复控制文件”和“恢复SP文件”，由于此数据库没
有catalog数据库，因此选择“无目册”；选择“高级”选项，确定恢复数据库的控制文件时间。

在恢复控制文件的时候需要先设置DBID
●点击高级，设置DBID
●点击ctrl和sp文件，选择从自动备份恢复到时间点
确定提交后，开始恢复控制文件和sp文件
Rman Script:
[SET DBID 483182049;
run {
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.a(shr.o),BLKSIZE=262144,ENV=(CV_mmsAp iVsn=2,CV_channelPar=ch1,ThreadCommandLine= RESTORE -jm 10 -a 2:0 -cl 27 -ins 114 -at 0 -j 70090 -bal 0 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -p 1 -cn p595_2 -vm Instance001)" TRACE 0;
restore spfile from autobackup until time = "TO_DATE('11/12/2009
17:45:56','MM/DD/YYYY HH24:MI:SS')" ;
restore controlfile from autobackup until time = "TO_DATE('11/12/2009
17:45:56','MM/DD/YYYY HH24:MI:SS')" ;
}
exit;
]
Rman Log:[
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Nov 20 17:46:12 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
RMAN>
connected to target database: lisdb (not mounted)
using target database control file instead of recovery catalog
RMAN>
executing command: SET DBID
RMAN> 2> 3> 4> 5> 6> 7> 8>
allocated channel: ch1
channel ch1: sid=35 devtype=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 8.0.0(BUILD68)
Starting restore at 20-NOV-09
channel ch1: looking for autobackup on day: 20091112
channel ch1: autobackup found: c-483182049-20091112-01
channel ch1: SPFILE restore from autobackup complete
Finished restore at 20-NOV-09
Starting restore at 20-NOV-09
channel ch1: looking for autobackup on day: 20091112
channel ch1: autobackup found: c-483182049-20091112-01
channel ch1: control file restore from autobackup complete
output filename=/oracle/product/10.2.0/db_1/dbs/cntrllisdb.dbf
Finished restore at 20-NOV-09
控制文件和sp文件数据量：约10MB
恢复耗时：11分钟
3.修改pfile（由恢复回来的spfile生成）文件
由于核心数据库生产机是Oracle RAC，要恢复到的目的机是单机oracle，因此修改pfile文件SQL>create pfile=’/home/oracle/newlisdbinit.ora from spfile;
修改后的newlisdb.ora文件为：
lisdb.__db_cache_size=8192000000
#lisdb2.__db_cache_size=29041360896
lisdb.__java_pool_size=31876710
#lisdb2.__java_pool_size=318767104
lisdb.__large_pool_size=107374182
#lisdb2.__large_pool_size=1073741824
lisdb.__shared_pool_size=1241513984
#lisdb2.__shared_pool_size=151********
lisdb.__streams_pool_size=214748364
#lisdb2.__streams_pool_size=2147483648
#*._complex_view_merging=FALSE
#*._job_queue_interval=1
*._spin_count=5000
*.aq_tm_processes=3。