我的oracle数据库有一个日志文件(当前日志)损坏,报错如下:
Tue Jul 19 17:56:55 2005
Errors in file /u/app/oracle/admin/ora8/bdump/ora8_pmon_707.trc:
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 10818 change 7734686368671 time 07/19/05 14
:47:54
ORA-00312: online log 3 thread 1: '/dev/vx/rdsk/dg1/rora8_log_vol03'
Recovery of Online Redo Log: Thread 1 Group 3 Seq 35593 Reading mem 0
Mem# 0 errs 0: /dev/vx/rdsk/dg1/rora8_log_vol03经过如下过程,仍不能解决,请求帮助。
1、shutdown abort
2、startup mount
3、recover database until cancel
提示:ORA-00308: cannot open archived log '/u/app/oracle/product/8.0.5/dbs/arch1_3559'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/dev/vx/rdsk/dg1/rora8_sys_vol01'4、alter database drop logfiles ....
5、alter database open resetlogs
提示:ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/dev/vx/rdsk/dg1/rora8_sys_vol01'
Tue Jul 19 17:56:55 2005
Errors in file /u/app/oracle/admin/ora8/bdump/ora8_pmon_707.trc:
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 10818 change 7734686368671 time 07/19/05 14
:47:54
ORA-00312: online log 3 thread 1: '/dev/vx/rdsk/dg1/rora8_log_vol03'
Recovery of Online Redo Log: Thread 1 Group 3 Seq 35593 Reading mem 0
Mem# 0 errs 0: /dev/vx/rdsk/dg1/rora8_log_vol03经过如下过程,仍不能解决,请求帮助。
1、shutdown abort
2、startup mount
3、recover database until cancel
提示:ORA-00308: cannot open archived log '/u/app/oracle/product/8.0.5/dbs/arch1_3559'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/dev/vx/rdsk/dg1/rora8_sys_vol01'4、alter database drop logfiles ....
5、alter database open resetlogs
提示:ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/dev/vx/rdsk/dg1/rora8_sys_vol01'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货