Results 1 to 3 of 3

Thread: Urgent -Failed to open database

  1. #1
    Join Date
    Jul 2005
    Posts
    35

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

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You need the archived log files in the backup location to continue restoring.

  3. #3
    Join Date
    Sep 2005
    Posts
    9
    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
  •