This discussion is archived
1 2 3 Previous Next 30 Replies Latest reply: Nov 24, 2012 5:50 PM by 975524 Go to original post RSS
  • 15. Re: Success on RESTORE but failed on RECOVER-- need help
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Since you are doing an Incomplete Recovery (recovery to a specific Sequence or SCN), take Set 2.
    Take the commands from
    "-- Set #2. RESETLOGS case" to the end.


    Hemant K Chitale
  • 16. Re: Success on RESTORE but failed on RECOVER-- need help
    975524 Newbie
    Currently Being Moderated
    After i got these errors below...

    ****************************
    140 '/oracle/oradsk2/ERPLN/bigtablesidex18.dbf'
    141 CHARACTER SET WE8ISO8859P1
    142 ;

    Control file created.

    SQL> RECOVER DATABASE USING BACKUP CONTROLFILE
    ORA-00279: change 1155601425 generated at 10/29/2012 00:30:04 needed for thread
    1
    ORA-00289: suggestion : /oracle/oradsk3/archivelogs/1_94642_700099109.dbf
    ORA-00280: change 1155601425 for thread 1 is in sequence #94642


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    VARIABLE RECNO NUMBER;
    ORA-00308: cannot open archived log 'VARIABLE'
    ORA-27037: unable to obtain file status
    IBM AIX RISC System/6000 Error: 2: No such file or directory
    Additional information: 3
    **********************************

    I know i did skip the part after creating the controlfile. What should i do next?
  • 17. Re: Success on RESTORE but failed on RECOVER-- need help
    975524 Newbie
    Currently Being Moderated
    I specified the suggested archivelog file as displayed then it states that "no longer needed for recovery"
    see below. What to do next? Am i missing something for the recovery?

    ***************************
    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    /oracle/oradsk3/archivelogs/1_94644_700099109.dbf
    ORA-00279: change 1155620109 generated at 10/29/2012 03:20:50 needed for thread
    1
    ORA-00289: suggestion : /oracle/oradsk3/archivelogs/1_94645_700099109.dbf
    ORA-00280: change 1155620109 for thread 1 is in sequence #94645
    ORA-00278: log file '/oracle/oradsk3/archivelogs/1_94644_700099109.dbf' no
    longer needed for this recovery


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    cancel
    Media recovery cancelled.
    **********************************
  • 18. Re: Success on RESTORE but failed on RECOVER-- need help
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    You seem to have jumped over some lines from the create controlfile script.


    Issue the RECOVER DATABASE USING BACKUP CONTROLFILE command manually.


    Hemant K Chitale
  • 19. Re: Success on RESTORE but failed on RECOVER-- need help
    975524 Newbie
    Currently Being Moderated
    Your reply is much appreciated. Below is what i got...


    SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;
    ORA-00279: change 1155620109 generated at 10/29/2012 03:20:50 needed for thread
    1
    ORA-00289: suggestion : /oracle/oradsk3/archivelogs/1_94645_700099109.dbf
    ORA-00280: change 1155620109 for thread 1 is in sequence #94645


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

    /oracle/oradsk3/archivelogs/1_94645_700099109.dbf <---- i pasted this as suggested

    ORA-00279: change 1155620123 generated at 10/29/2012 03:20:53 needed for thread
    1
    ORA-00289: suggestion : /oracle/oradsk3/archivelogs/1_94646_700099109.dbf
    ORA-00280: change 1155620123 for thread 1 is in sequence #94646
    ORA-00278: log file '/oracle/oradsk3/archivelogs/1_94645_700099109.dbf' no
    longer needed for this recovery


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

    Edited by: 972521 on Nov 24, 2012 4:13 PM
  • 20. Re: Success on RESTORE but failed on RECOVER-- need help
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Carry on applying as many archivelogs as you have / want to apply and then CANCEL after the last file.
    After the CANCEL, if the database is consistent, you should be able to ALTER DATABASE OPEN RESETLOGS.


    Hemant K Chitale
  • 21. Re: Success on RESTORE but failed on RECOVER-- need help
    975524 Newbie
    Currently Being Moderated
    Hemant K Chitale wrote:
    Carry on applying as many archivelogs as you have / want to apply and then CANCEL after the last file.
    After the CANCEL, if the database is consistent, you should be able to ALTER DATABASE OPEN RESETLOGS.


    Hemant K Chitale
    >
    Carry on applying as many archivelogs as you have / want to apply and then CANCEL after the last file.
    After the CANCEL, if the database is consistent, you should be able to ALTER DATABASE OPEN RESETLOGS.


    Hemant K Chitale
    > Carry on applying as many archivelogs as you have / want to apply and then CANCEL after the last file.
    After the CANCEL, if the database is consistent, you should be able to ALTER DATABASE OPEN RESETLOGS.


    Hemant K Chitale
    > Carry on applying as many archivelogs as you have / want to apply and then CANCEL after the last file.
    After the CANCEL, if the database is consistent, you should be able to ALTER DATABASE OPEN RESETLOGS.


    Hemant K Chitale
    SQL> recover database using backup controlfile;
    ORA-00279: change 1155620123 generated at 10/29/2012 03:20:53 needed for thread
    1
    ORA-00289: suggestion : /oracle/oradsk3/archivelogs/1_94646_700099109.dbf
    ORA-00280: change 1155620123 for thread 1 is in sequence #94646


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    /oracle/oradsk3/archivelogs/1_94646_700099109.dbf <----- i pasted this
    ORA-00279: change 1155620136 generated at 10/29/2012 03:20:56 needed for thread
    1
    ORA-00289: suggestion : /oracle/oradsk3/archivelogs/1_94647_700099109.dbf
    ORA-00280: change 1155620136 for thread 1 is in sequence #94647
    ORA-00278: log file '/oracle/oradsk3/archivelogs/1_94646_700099109.dbf' no
    longer needed for this recovery


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    cancel <-- then i cancelled since there is no more suggested archivelog path
    Media recovery cancelled.
    SQL> alter database open resetlogs
    2 ;
    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: '/oracle/oradsk2/ERPLN/system01.dbf'

    SQL>

    Should i be restoring this datafile again? i pretty sure that i had a successful restoration.
  • 22. Re: Success on RESTORE but failed on RECOVER-- need help
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    "file needs more recovery" does mean that the database is not yet consistent.

    You could try a RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
    and then CANCEL
    and see if Oracle reports a message that more recovery would be required.


    Hemant K Chitale
  • 23. Re: Success on RESTORE but failed on RECOVER-- need help
    975524 Newbie
    Currently Being Moderated
    Its still looking for a certain datafile. see below
    ******
    SQL> recover database using backup controlfile until cancel
    ORA-00279: change 1155620136 generated at 10/29/2012 03:20:56 needed for thread
    1
    ORA-00289: suggestion : /oracle/oradsk3/archivelogs/1_94647_700099109.dbf
    ORA-00280: change 1155620136 for thread 1 is in sequence #94647

    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    *******

    Based on my rman backup log. "1_94647_700099109.dbf" is not included in the backup

    Can i just make recover up to the last good archivelog? "/oracle/oradsk3/archivelogs/1_94646_700099109.dbf"
  • 24. Re: Success on RESTORE but failed on RECOVER-- need help
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Issue a CANCEL and see what messages are returned by Oracle.


    Hemant K Chitale
  • 25. Re: Success on RESTORE but failed on RECOVER-- need help
    975524 Newbie
    Currently Being Moderated
    Media recovery cancelled
    SQL>
  • 26. Re: Success on RESTORE but failed on RECOVER-- need help
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Try an ALTER DATABASE OPEN RESETLOGS now.


    Hemant K Chitale
  • 27. Re: Success on RESTORE but failed on RECOVER-- need help
    975524 Newbie
    Currently Being Moderated
    SQL> alter database open resetlogs
    2 ;

    Database altered.

    SQL>

    Edited by: 972521 on Nov 24, 2012 5:31 PM
  • 28. Re: Success on RESTORE but failed on RECOVER-- need help
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    That's it then. You are done with an Incomplete Recovery upto the last ArchiveLog that you had applied.

    Congrats.

    Take a fresh backup asap.

    Hemant K Chitale
  • 29. Re: Success on RESTORE but failed on RECOVER-- need help
    975524 Newbie
    Currently Being Moderated
    Can i command "startup" now? is this ok?

    SQL> startup
    ORA-01081: cannot start already-running ORACLE - shut it down first

    Should i do "shutdown immediate" or just "shutdown"

    Then startup?

    Edited by: 972521 on Nov 24, 2012 5:36 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points