Shutdown abort mode: The redo is lost. Use the implicit parameter to start the database, abortredo
Shutdown abort Mode
Loss of redo log
Unable to open database
Through the alarm error ORA-00354: upt redo log block header from this error can be seen that the current log redo block header problems, resulting in oracle cannot read redo for recovery. The following check shows that the database file headers are consistent and no files need to be recovered. However, the database is not properly closed and the last_change scn is not written. The database determines that the database needs to be restored, the corresponding redo log group 3 is read, but the file is damaged.
SYS@orcl11g>alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01139: RESETLOGS option only valid after an incomplete database recoverySYS@orcl11g>recover database;ORA-00283: recovery session canceled due to errorsORA-00313: open failed for members of log group 3 of thread 1ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/orcl11g/redo03.log'ORA-27046: file size is not a multiple of logical block sizeAdditional information: 1SYS@orcl11g>recover database until cancel;ORA-00279: change 5168496 generated at 10/29/2014 23:48:23 needed for thread 1ORA-00289: suggestion : /opt/oracle/flash_recovery_area/ORCL11G/archivelog/2014_10_29/o1_mf_1_159_%u_.arcORA-00280: change 5168496 for thread 1 is in sequence #159Specify log: {<RET>=suggested | filename | AUTO | CANCEL}ORA-00308: cannot open archived log '/opt/oracle/flash_recovery_area/ORCL11G/archivelog/2014_10_29/o1_mf_1_159_%u_.arc'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01194: file 1 needs more recovery to be consistentORA-01110: data file 1: '/opt/oracle/oradata/orcl11g/system01.dbf'
Add the following implicit parameter: SYS @ orcl11g> show parameter _ allowNAME type value =------------------------------------------------ _ allow_error_simulation boolean true_allow_resetlogs_limit uption boolean TRUE
Which can be opened when the database is found at this time
SYS @ orcl11g> SYS @ orcl11g> SYS @ orcl11g> alter database open resetlogs; Database altered. SYS @ orcl11g> the log file has been rebuilt: SYS @ orcl11g> select group #, status from v $ log; GROUP # STATUS ---------- ------------------------------------------------------------ 1 CURRENT 2 UNUSED 3 UNUSEDSYS @ orcl11g> alter system switch logfile; System altered. SYS @ orcl11g>/System altered. SYS @ orcl11g>/System altered. SYS @ orcl11g> select group #, status from v $ log; GROUP # STATUS ---------- ------------------------------------------------------ 1 CURRENT 2 INACTIVE 3 ACTIVE