The shutdown abort mode loses redo and uses the implicit parameter to start the database.

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.

[email protected]>alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01139: RESETLOGS option only valid after an incomplete database recovery[email protected]>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: 1[email protected]>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: [email protected]> 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

[Email protected]> [email protected]> [email protected]> alter database open resetlogs; database altered. [email protected]> the log file has been rebuilt: [email protected]> select group #, status from V $ log; group # status ---------- ------------------------------------------------------------ 1 current 2 unused 3 unused [email protected]> alter system switch logfile; System altered. [email protected]>/system altered. [email protected]>/system altered. [email protected]> select group #, status from V $ log; group # status ------------ ---------------------------------------------------- 1 current 2 inactive 3 active

The shutdown abort mode loses redo and uses the implicit parameter to start the database.