DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013

    Recover Data from Oracle 8i


    I am facing following problems due to improper shutdown when open my oracle 8i database :

    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\CP\SYSTEM01.DBF

    Database mounted successfully but did not open. i have applied following commands:

    recover database
    recover datafile 'datafile'

    in / as sysdba prompt but did not resolve problem. Database is in "no archive mode". Please suggest me any solution to take backup of my database.
    I have applied USER tablespace for my user ACC. Can i recover data from USER01.DBF file?

    Thanks and regards,

    M. Kamran

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    Try doing "recover database until cancel;" and when it asks for an archive log file point it
    to one of the online redo logs, and keep going until you either run out of online redo logs
    or the database does not want to be recovered anymore. In the future either add more
    online redo logs or better yet put the database in archive log mode.
    this space intentionally left blank

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.