1 2 Previous Next 17 Replies Latest reply: Jan 10, 2013 8:42 PM by sb92075 Go to original post RSS
      • 15. Re: ORA-01033: ORACLE initialization or shutdown in progress
        sb92075
        970292 wrote:
        Hi ,

        I followed the steps mentioned .. But was not successful.. Here is the trace. Could you please let me know what is wrong ?

        SQL> Show parameter control_files

        NAME TYPE VALUE
        ------------------------------------ ----------- ------------------------------
        control_files string C:\POSSUITEAPPS\ORACLEDB\ORADA
        TA\ORCL\CONTROL01.CTL, C:\POSS
        UITEAPPS\ORACLEDB\FLASH_RECOVE
        RY_AREA\ORCL\CONTROL02.CTL
        SQL>
        SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=
        b.group# and b.status='CURRENT'
        2
        SQL> Shutdown abort
        ORACLE instance shut down.
        SQL> C:\POSSU
        SP2-0023: String not found.
        SQL> Startup mount
        ORACLE instance started.

        Total System Global Area 1653518336 bytes
        Fixed Size 2176288 bytes
        Variable Size 1275071200 bytes
        Database Buffers 369098752 bytes
        Redo Buffers 7172096 bytes
        Database mounted.
        SQL> recover database using backup controlfile until cancel
        ORA-00279: change 6366747 generated at 01/08/2013 10:24:54 needed for thread 1
        ORA-00289: suggestion :
        C:\POSSUITEAPPS\ORACLEDB\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_01_10\O1_MF_1_

        186_%U_.ARC
        ORA-00280: change 6366747 for thread 1 is in sequence #186


        Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
        C:\POSSuiteApps\OracleDB\oradata\orcl\REDO02.LOG
        ORA-00310: archived log contains sequence 185; sequence 186 required
        ORA-00334: archived log: 'C:\POSSUITEAPPS\ORACLEDB\ORADATA\ORCL\REDO02.LOG'


        ORA-10879: error signaled in parallel recovery slave
        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: 'C:\POSSUITEAPPS\ORACLEDB\ORADATA\ORCL\SYSTEM01.DBF'

        SQL> Alter database open resetlogs
        2
        you just rendered this DB to be permanently inoperable!
        • 16. Re: ORA-01033: ORACLE initialization or shutdown in progress
          973295
          I provided a wrong log file (REDO02.LOG instead of REDO03.LOG) hence the recovery was not successful and the attempt to open DB also failed . I corrected that and was successfully able to connect to the DB after the recovery.

          Thanks!
          • 17. Re: ORA-01033: ORACLE initialization or shutdown in progress
            sb92075
            970292 wrote:
            I provided a wrong log file (REDO02.LOG instead of REDO03.LOG) hence the recovery was not successful and the attempt to open DB also failed . I corrected that and was successfully able to connect to the DB after the recovery.

            Thanks!
            CONGRATULATIONS!
            Please mark this thread as answered.
            1 2 Previous Next