记一次数据库在线日志全部丢失故障恢复处理
数据库版本为
BANNER
----------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
运行在linux系统中
[ora10g@hzmc admin]$ uname -a
Linux hzmc 2.6.18-53.el5xen #1 SMP Mon Nov 12 03:26:12 EST 2007 i686 i686 i386 GNU/Linux
由于数据库的online redolog全部丢掉,导致数据库在open阶段时出现以下错误
alter database open
Thu Nov 3 16:55:02 2011
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Thu Nov 3 16:55:02 2011
Started redo scan
Thu Nov 3 16:55:02 2011
Errors in file /ora10g/admin/drb/udump/drb_ora_14761.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/Tbackup/drb/redo01_1.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3