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 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,
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
Click Here to Expand Forum to Full Width