-
Database Recovery
Hi,
Database failed to restart and the following message appeared;
Database mounted.
ORA-01113: file 54 needs media recovery
ORA-01110: data file 54: 'D:\ORADATA\CMG_01.DBF'
I did the following and this is what i got:
SQL> alter database recover datafile 34;
alter database recover datafile 34
*
ERROR at line 1:
ORA-00279: change 923435034 generated at 01/24/2007 18:39:52 needed for thread
1
ORA-00289: suggestion :
C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_25\O1_MF_1_
112724_%U_.ARC
ORA-00280: change 923435034 for thread 1 is in sequence #112724
I have no clue on how to handle this, how can I recover the database? There are no archive log files in place. Please advise.
Thanks.
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
|