This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Apr 19, 2013 8:31 PM by Hemant K Chitale Go to original post RSS
  • 15. Re: How to restore specific backup file from RMAN?
    1002173 Newbie
    Currently Being Moderated
    My db totallyy stucked:

    I do not have DB ID in backup log it was 2 weeks ago. I do now see any more that backup log on my terminal
    How to determine DBID?

    I accedently set some wrong DBID and now I can not open database at all.

    Plase help

    How to determine DBID and please tell me what is the step after I do restore controlfile?

    Thank you

    Edited by: 999170 on Apr 19, 2013 3:18 AM
  • 16. Re: How to restore specific backup file from RMAN?
    swapnil kambli Journeyer
    Currently Being Moderated
    DBID doesn't change..even if the backup log is 2 weeks old that DBID will be the same unless you changed it explicitly with NID tool etc.
    post first 20 lines of that logfile.

    Post error messages that you are getting.
    how did you manage to post the LIST BACKUP command output? When you connected through RMAN to the database that time in firstfew lines DBID is shown.

    Below is undocumented method:
  • 17. Re: How to restore specific backup file from RMAN?
    gopal Newbie
    Currently Being Moderated
    bring the DB to nomount mode
    then do the below steps
    rman target /
    RMAN>restore controlfile from '/opt/oracle/backup/std_0vo6morv_1_1';
    RMAN>alter database mount;
    RMAN>restore daatbase from '/opt/oracle/backup/std_0uo6morg_1_1';
    RMAN>alter database open resetlogs;
  • 18. Re: How to restore specific backup file from RMAN?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    You need to set the correct DBID before you RESTORE CONTROLFILE.

    After the RESTORE CONTROLFILE, you need to RESTORE DATABASE (and, after that, RECOVER DATABASE). If you are doing a Point In Time Recovery or an Incomplete Recovery, you need to SET UNTIL before the RECOVER DATABASE.

    Hemant K Chitale
1 2 Previous Next


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