Hi all,
When I tried to open database I got:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open.
I tried to :
Code:
alter database open resetlogs;
and I got:
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'E:\ORACLE\PRODUCT\10.1.0\ORADATA\FILERPRO\SYSTEM0 1.DBF'
Then I did:
Code:
SQL>RECOVER DATAFILE 1;
and It throws:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
And if you are there and did not run away I should say I issued:
Code:
alter database recover using backup controlfile
and this time my lovely server said:
ERROR at line 1:
ORA-00279: change 3111399 generated at 08/29/2005 13:08:13 needed for thread 1
ORA-00289: suggestion :
E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\FILER PRO\ARCHIVELOG\2005_08_29\O1_MF_1_343_%U_.ARC
ORA-00280: change 3111399 for thread 1 is in sequence #343
And here my flawed knowledge was finished and I post here to get help from you,dear guys!
-Thanks a lot.