ORACLE数据库恢复演练报告 下载本文

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 \ and \ \ UNIXes this can be accomplished by editing the /etc/group file.

2) The .profile of each database user must contains a \ 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 \

Adjusting modes and permissions of Simpana files

Successfully installed CVGxOrIDA.

37

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

38

? 点击高级,设置DBID

? 点击ctrl和sp文件,选择从自动备份恢复到时间点

39

? 确定提交后,开始恢复控制文件和sp文件

Rman Script:

[SET DBID 483182049; run {

allocate channel ch1 type 'sbt_tape'

PARMS=\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 = \17:45:56','MM/DD/YYYY HH24:MI:SS')\

restore controlfile from autobackup until time = \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>

40