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.