3 Replies Latest reply: Jul 28, 2013 5:09 AM by JohnWatson RSS

    Oracle 9i Database error

    user1115335

      Hi

       

      This morning i was trying to start  my Oracle Database Non production .

      it was not able to mount following error was coming

       

      alter database mount
      *
      ERROR at line 1:
      ORA-00220: controlfile not mounted by first instance, check alert log for more
      info
      ORA-00202: controlfile: 'D:\ORACLE\ORADATA\OCIDB\CONTROL03.CTL'


      Action plan:-

       

      Copied control file CONTROL02 and renamed it to 03

      After that database mounted.


      While giving alter database open.

       

      ORA-01113: file 6 needs media recovery

      ORA-01110: data file 6: 'D:\ORACLE\ORADATA\OCIDB\INDX01.DBF'

       

      Tried this  commad

       

      SQL> recover datafile 'D:\ORACLE\ORADATA\OCIDB\INDX01.DBF';

      ORA-00283: recovery session canceled due to errors

      ORA-01114: IO error writing block to file 6 (block # 1)

      ORA-01110: data file 6: 'D:\ORACLE\ORADATA\OCIDB\INDX01.DBF'

      ORA-27091: skgfqio: unable to queue I/O

      ORA-27041: unable to open file

      OSD-04002: unable to open file

      O/S-Error: (OS 5) Access is denied.

       

        I don’t have  the backup of this DB nor  this DB is in archive mode

       

      kindly help me with this.

       

      Regards

      SIR

        • 1. Re: Oracle 9i Database error
          Asif Muhammad

          Hi,

           

          In order to ensure the control file replacement is fine. Can you do the following.

           

          - Copy all the current controlfiles to a different location (for backup means)

          - Shutdown immediate

          - Delete controlfile 2 and 3

          - Ensure to have 3 copies of controlfile 1, and rename so that you have controlfile1, controlfile2 and controlile3.

           

          I believe there is a mismatch between the previous controlfile replacement.

           

          Just give a try!!!

           

          Regards,

          • 2. Re: Oracle 9i Database error
            user1115335

            HI

            Thanks for the reply ,

             

            I have even tried the following ,

             

            took backup of all the control files  recreated control file , then tried to open the database got this error

             

            Media Recovery Log

            ORA-279 signalled during: ALTER DATABASE RECOVER  database using backup cont...

            Sun Jul 28 12:27:34 2013

            ALTER DATABASE RECOVER    CANCEL 

            Sun Jul 28 12:27:36 2013

            ORA-1547 signalled during: ALTER DATABASE RECOVER    CANCEL  ...

            Sun Jul 28 12:27:36 2013

            ALTER DATABASE RECOVER CANCEL

            ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...

             

            Regards

            SIR

            • 3. Re: Oracle 9i Database error
              JohnWatson

              user1115335 wrote:

               

              Hi

               

              This morning i was trying to start  my Oracle Database Non production .

              it was not able to mount following error was coming

               

              alter database mount
              *
              ERROR at line 1:
              ORA-00220: controlfile not mounted by first instance, check alert log for more
              info
              ORA-00202: controlfile: 'D:\ORACLE\ORADATA\OCIDB\CONTROL03.CTL'


              Action plan:-

               

              Copied control file CONTROL02 and renamed it to 03

              After that database mounted.


              While giving alter database open.

               

              ORA-01113: file 6 needs media recovery

              ORA-01110: data file 6: 'D:\ORACLE\ORADATA\OCIDB\INDX01.DBF'

               

              Tried this  commad

               

              SQL> recover datafile 'D:\ORACLE\ORADATA\OCIDB\INDX01.DBF';

              ORA-00283: recovery session canceled due to errors

              ORA-01114: IO error writing block to file 6 (block # 1)

              ORA-01110: data file 6: 'D:\ORACLE\ORADATA\OCIDB\INDX01.DBF'

              ORA-27091: skgfqio: unable to queue I/O

              ORA-27041: unable to open file

              OSD-04002: unable to open file

              O/S-Error: (OS 5) Access is denied.

               

                I don’t have  the backup of this DB nor  this DB is in archive mode

               

              kindly help me with this.

               

              Regards

              SIR

              First,

               

              alter database datafile 6 offline;

              alter database open;

               

              Then, if you have followed your naming convention and the tablespace contains only indexes, relocate them to another tablespace and drop the damaged one. There are some complications in this process, but you won't lose any data.

              --

              John Watson

              Oracle Certified Master DBA

              http://skillbuilders.com