ORACLE数据库恢复演练报告

来源：用户分享时间：2025/5/29 6:34:23 本文由

说明：文章内容仅供预览，部分内容可能不全，需要完整文档或者需要复制内容，请下载word后使用。下载word有问题请添加微信号:xxxxxxx或QQ：xxxxxx 处理（尽可能给您提供完整文档），感谢您的支持与谅解。

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.

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=\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:[

搜索更多关于： ORACLE数据库恢复演练报告的文档

ORACLE数据库恢复演练报告.doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印

下载这篇word文档

本文链接：https://www.diyifanwen.net/c4nhxt3ap1p1oirv32m90_10.html（转载请注明文章来源）