Shutdown abort mode: The redo is lost. Use the implicit parameter to start the database, abortredo

Source: Internet
Author: User

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






Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.