ACTIVE日志损坏（有归档）(二)

SQL> recover database;

ORA-00283: recovery session canceled due toerrors

ORA-00313: open failed for members of log group 1 ofthread 1

ORA-00312: online log 1 thread 1:'/u01/tiger/oradata/orcl/redo01.log'

ORA-27046: file size is not a multiple oflogical block size

Additional information: 1

------当恢复读取日志组1的redo01.dbf的时候格式不对打开失败

因为有归档但是数据不认为此次恢复需要归档，我们手工提供归档

SQL> recover database until cancel;

ORA-00279: change 460765 generated at09/07/2012 13:32:38 needed for thread 1

ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL/archivelog/2012_09_07/o1_mf_1_2_%u_.arc

ORA-00280: change 460765 for thread 1 is insequence #2

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

ORA-00279: change 460767 generated at09/07/2012 13:32:40 needed for thread 1

ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL/archivelog/2012_09_07/o1_mf_1_3_%u_.arc

ORA-00280: change 460767 for thread 1 is insequence #3

ORA-00278: log file'/u01/tiger/flash_recovery_area/ORCL/archivelog/2012_09_07/o1_mf_1_2_84m1qrxr_.arc'no longer neededfor this recovery

------2号文件我们没有用到因为刚才recover databas恢复的时候应用了2号日志文件对应的是第三组下一个是3号日志文件实际上就是current日志还没有来得及切换就已经崩溃了所以没有归档我们提供在线的current日志，我们的在线日志是第二组里的日志文件

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

/u01/tiger/oradata/orcl/redo02.log

Log applied.

Media recovery complete.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS orNORESETLOGS option for database open

SQL> alter database open resetlogs;

Database altered.