-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|