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