-
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
-
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.
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
|