-
Urgent -Failed to open database
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.
-
You need the archived log files in the backup location to continue restoring.
-
please let me know if this works
STARTUP MOUNT
Begin cancel-based recovery by issuing the following command:
RECOVER DATABASE UNTIL CANCEL
If you are using a backup control file with this incomplete recovery, then specify the USING BACKUP CONTROLFILE option in the RECOVER command.
RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
(The until clause is important)
Continue applying redo log files until the last log has been applied to the restored datafiles, then cancel recovery by executing the following command:
CANCEL
Open the database using
ALTER DATABASE OPEN RESETLOGS;
Good Luck,
Vikram
Last edited by vikram_gaba; 09-02-2005 at 12:15 PM.
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
|
|