ORA-01113: file 2 needs media ercovery - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: ORA-01113: file 2 needs media ercovery

  1. #11
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104
    I couldn't able to connect to this database due to this error so recovering is not possible.

  2. #12
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Connect locally using svrmgrl (or sqlplus 9i). Mount the database. Recover it.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #13
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104
    I won't be able to connect using sqlplus and it always says 'oracle shutdown in progress' and when I did the following I got 'File 2 needs media recovery error'.

    net start OracleServiceSID /y
    sqlplus /nolog
    set instance SID
    connect /as sysdba
    startup pfile'/xx/init.ora'

  4. #14
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    yes that's where you have to recover the datafile. I hope you have the archive logs to recover.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #15
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by SANJAY_G
    Connect locally using svrmgrl (or sqlplus 9i). Mount the database. Recover it.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #16
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104
    My database is in NOARCHIEVELOG mode and more over I am doing cold backup.

  7. #17
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can still try to recover. If you are lucky the file can be recovered from online redo logs. If not, your only option is to restore everything from your last cold backup.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #18
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by sudheer_nm
    I won't be able to connect using sqlplus and it always says 'oracle shutdown in progress' and when I did the following I got 'File 2 needs media recovery error'.
    You all missed an important point.. Sudheer_nm since it says "oracle shutdown in progress" abort the database. Make sure all processes connected with the database are down.

    Your database is in No archive log mode so here is what you have to do.
    If you've backed up your control file to trace we can get this thing recovered (if your datafile is not phyically corrupted).
    Lets try this the easy way first and hopefully that will work.
    1.start up the database (yea you'll get the .dbf needs recovery that's ok.
    2. issue recover database
    3. It's going to ask you for an archive log file. Give it the path of your first redo log file. If it doesn't work give it the next redo log file until there are no log files or your database recovers itself.

    More than likely your datafile(s) have gotten out of sync and he's looking for a sequence #.

    If this doesn't work then we'll have to get down and dirty with it the most important thing is if you have a control file backed up to trace we can get it recovered.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width