oracle 1438错误 日志,[Oracle] 数据库启动报错(REDO日志损坏) ORA-01194

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/home/oracle/app/oradata/orcl/system01.dbf'

先看一下是那个redo损坏

SQL>  recover database using backup controlfile until cancel;

ORA-00279: change 5968525543059generated at 10/26/2015 08:11:31 needed for

thread 1

ORA-00289: suggestion :

/home/oracle/app/flash_recovery_area/ORCL/archivelog/2016_12_28/o1_mf_1_1555_%u_

.arc

ORA-00280: change 5968525543059for thread 1 is in sequence #1555

Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log

'/home/oracle/app/flash_recovery_area/ORCL/archivelog/2016_12_28/o1_mf_1_1555_%u

_.arc'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-10879: error signaled in parallel recovery slave

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: '/home/oracle/app/oradata/orcl/system01.dbf'

查询

SQL> select v1.group#, member, sequence#, first_change#

from v$log v1, v$logfile v2

where v1.group# = v2.group#;  2    3

GROUP#

MEMBER

SEQUENCE# FIRST_CHANGE#

-

1

/home/oracle/app/oradata/orcl/redo01.log

1555    5.9685E+12

3

/home/oracle/app/oradata/orcl/redo03.log

1554    5.9685E+12

GROUP#

MEMBER

SEQUENCE# FIRST_CHANGE#

-

2

/home/oracle/app/oradata/orcl/redo02.log

1553    5.9685E+12

我们知道是redo01.log坏了

然后

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 5968525543059 generated at 10/26/2015 08:11:31 needed for

thread 1

ORA-00289: suggestion :

/home/oracle/app/flash_recovery_area/ORCL/archivelog/2016_12_28/o1_mf_1_1555_%u_

.arc

ORA-00280: change 5968525543059 for thread 1 is in sequence #1555

Specify log: {=suggested | filename | AUTO | CANCEL}

/home/oracle/app/oradata/orcl/redo01.log  这里输入损坏的REDO日志名

Log applied.

Media recovery complete.

最后打开数据库

SQL> alter database open resetlogs;

Database altered.