日期:2014-05-16  浏览次数:20497 次

记一次数据库在线日志全部丢失故障恢复处理
数据库版本为
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