This discussion is archived
3 Replies Latest reply: Jul 28, 2013 3:09 AM by JohnWatson RSS

Oracle 9i Database error

sr59336 Newbie
Currently Being Moderated

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 Guru
    Currently Being Moderated

    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
    sr59336 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points