1218316 bytes

Variable Size              88082676 bytes

Database Buffers           75497472 bytes

Redo Buffers                2973696 bytes

Database mounted.

ORA-01122: database file 1 failed verification check

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

ORA-01207: file is more recent than control file - old control file

执行恢复：

 

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 891145 generated at 11/18/2006 06:02:11 needed for thread 1

ORA-00289: suggestion :

/free/oracle/flash_recovery_area/ORCL/archivelog/2006_11_19/o1_mf_1_47_%u_.arc

IXDBA.NET技术社区

ORA-00280: change 891145 for thread 1 is in sequence #47

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto （由于o1_mf_1_47_%u_.arc这个归档日志，我这里有这个文件，所以指定auto，此时应用了一些归档日志）

ORA-00279: change 911145 generated at 11/19/2006 13:49:24 needed for thread 1

ORA-00289: suggestion :

/free/oracle/flash_recovery_area/ORCL/archivelog/2006_11_19/o1_mf_1_48_%u_.arc

ORA-00280: change 911145 for thread 1 is in sequence #48

ORA-00278: log file

'/free/oracle/flash_recovery_area/ORCL/archivelog/2006_11_19/o1_mf_1_47_2ozw355r

_.arc' no longer needed for this recovery

 

ORA-00279: change 911687 generated at 11/19/2006 13:54:36 needed for thread 1

ORA-00289: suggestion :

/free/oracle/flash_recovery_area/ORCL/archivelog/2006_11_19/o1_mf_1_49_%u_.arc

ORA-00280: change 911687 for thread 1 is in sequence #49

ORA-00278: log file

'/free/oracle/flash_recovery_area/ORCL/archivelog/2006_11_19/o1_mf_1_48_2ozwf289

_.arc' no longer needed for this recovery

 

 

ORA-00308: cannot open archived log

'/free/oracle/flash_recovery_area/ORCL/archivelog/2006_11_19/o1_mf_1_49_%u_.arc'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

 

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup

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

 

 

这种恢复方式，不会自动去找联机redo文件，所以必须要手工指定！

 

 

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 911687 generated at 11/19/2006 13:54:36 needed for thread 1

ORA-00289: suggestion :

/free/oracle/flash_recovery_area/ORCL/archivelog/2006_11_19/o1_mf_1_49_%u_.arc

ORA-00280: change 911687 for thread 1 is in sequence #49

 

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/free/oracle/oradata/orcl/redo01.log

ORA-00310: archived log contains sequence 47; sequence 49 required

ORA-00334: archived log: '/free/oracle/oradata/orcl/redo01.log'

 

 

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup