3 Replies Latest reply on Jun 13, 2015 12:26 PM by Beauty_and_dBest

    Corrupted Redo on 11i?

    Beauty_and_dBest

      Hi all,

       

      EBS 11Ii

      9i Db

       

       

      I am starting our 11i apps/database using:

       

      [oradev@oratrng5 ~]$ /u02/oradev/devdb/9.2.0/appsutil/scripts/DEV_oratrng5/addbctl.sh start

       

      You are running addbctl.sh version 115.8

       

      Starting the database DEV ...

       

      SQL*Plus: Release 9.2.0.6.0 - Production on Sat Jun 13 18:01:32 2015

       

      Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

       

      Connected to an idle instance.

      ORACLE instance started.

       

      Total System Global Area  581506668 bytes

      Fixed Size                   452204 bytes

      Variable Size             402653184 bytes

      Database Buffers          167772160 bytes

      Redo Buffers               10629120 bytes

      Database mounted.

      ORA-00354: corrupt redo log block header

      ORA-00353: log corruption near block 204333 change 5977336119449 time

      06/12/2015 21:50:16

      ORA-00312: online log 3 thread 1: '/u02/oradev/devdata/log03b.dbf'

      ORA-00312: online log 3 thread 1: '/u02/oradev/devdata/log03a.dbf'

       

      Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

      With the Partitioning, OLAP and Oracle Data Mining options

      JServer Release 9.2.0.6.0 - Production

       

      addbctl.sh: exiting with status 0

       

      [oradev@oratrng5 ~]$

      ===========================

       

      It was still good since yesterday

      What causes this corruption?

       

      I tried to run "recover database" but to no avail.

       

       

      Please help....

       

      Thanks a lot.

       

      JC

        • 1. Re: Corrupted Redo on 11i?
          Beauty_and_dBest

          I tried googling some steps like:

           

          SQL>  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

          ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3

          *

          ERROR at line 1:

          ORA-01624: log 3 needed for crash recovery of thread 1

          ORA-00312: online log 3 thread 1: '/u02/oradev/devdata/log03a.dbf'

          ORA-00312: online log 3 thread 1: '/u02/oradev/devdata/log03b.dbf'

           

           

          SQL>  alter system switch logfile;

          alter system switch logfile

          *

          ERROR at line 1:

          ORA-01109: database not open

          • 2. Re: Corrupted Redo on 11i?
            Beauty_and_dBest

            ORA-00289: suggestion : /u02/oradev/devdb/9.2.0/dbs/arch/1_30.dbf

            ORA-00280: change 5977336119448 for thread 1 is in sequence #30

             

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

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

            ORA-01194: file 1 needs more recovery to be consistent

            ORA-01110: data file 1: '/u02/oradev/devdata/system01.dbf'

             

            ORA-01112: media recovery not started

            • 3. Re: Corrupted Redo on 11i?
              Beauty_and_dBest

              Hi all,

               

              I set  > _allow_resetlogs_corruption=TRUE

               

              And I was able to opet the database resetlogs.

               

              SQL> recover database until cancel;

              ORA-00279: change 5977336119448 generated at 06/13/2015 07:10:45 needed for

              thread 1

              ORA-00289: suggestion : /u02/oradev/devdb/9.2.0/dbs/arch/1_30.dbf

              ORA-00280: change 5977336119448 for thread 1 is in sequence #30

               

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

              cancel

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

              ORA-01194: file 1 needs more recovery to be consistent

              ORA-01110: data file 1: '/u02/oradev/devdata/system01.dbf'

               

              ORA-01112: media recovery not started

               

              SQL> alter database open resetlogs;

               

              Database altered.


              ============


              Is it enough now? The docs  said to create the database after it opened.

              But did not explain how and why?

               

               

              Thanks a lot.