用Oracle的热备份重建数据库(二)
志文件恢复数据库
下面开始用控制文件和归档日志文件恢复数据库：
SVRMGR>recover database using backup controlfile until cancel;
出现如下提示：
ORA-00279: change 50971 generated at 08/23/2002 09:21:27 needed for thread 1
www.2cto.com
ORA-00289: suggestion: /home/oracle/app/oracle/admin/ora8/arch/arch_1_399.arc
ORA-00280: change 50971 for thread 1 is in sequence #399
Specify log: {=suggested | filename | AUTO | CANCEL}输入：
auto
如果有如下提示，则表示成功。
ORA-00279: change 51007 generated at 08/23/2002 11:23:13 needed for thread 1
ORA-00289: suggestion: /home/oracle/app/oracle/admin/ora8/arch/arch_1_400.arc
ORA-00280: change 51007 for thread 1 is in sequence #400
ORA-00278: log file '/home/oracle/app/oracle/admin/ora8/arch/arch_1_399.arc' noy
Log applied.
意外处理：如果其它提示可能是需要的日志文件不存在，检查ORA-00289中该文件是否存在。
直到出现如下提示：
ORA-00279: change 51011 generated at 08/23/2002 11:23:45 needed for thread 1
ORA-00289: suggestion: /home/oracle/app/oracle/admin/ora8/arch/arch_1_401.arc
ORA-00280: change 51011 for thread 1 is in sequence #401
ORA-00278: log file '/home/oracle/app/oracle/admin/ora8/arch/arch_1_400.arc' noy
ORA-00308: cannot open archived log '/home/oracle/app/oracle/admin/ora8/arch
/arch_1_401.arc'
ORA-27037: unable to obtain file status
www.2cto.com
Intel SVR4 UNIX Error: 2: No such file or directory
Additional information: 3
<4> 重置日志
SVRMGR>alter database open resetlogs;
意外处理：如果提示创建日志的路径不存在，按提示路径创建目录。然后再重置日志。
<5> 重启数据库，完成恢复
SVRMGR>shutdown immediate
SVRMGR>startup
ORACLE instance started.
Total System Global Area 123437040 bytes
Fixed Size 69616 bytes
Variable Size 106418176 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
www.2cto.com
Database mounted.
Database opened.
数据库正常打开，数据库重建恢复成功。
作者 tbwshc