Recover Data from Oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Recover Data from Oracle 8i

  1. #1
    Join Date
    May 2013
    Posts
    1

    Recover Data from Oracle 8i

    Hi,

    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'
    RECOVER DATABASE USING BACKUP CONTROLFILE;

    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
    Location
    Pittsburgh, PA
    Posts
    4,002
    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