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,