1 2 Previous Next 18 Replies Latest reply: Apr 19, 2013 10:31 PM by Hemant K Chitale Go to original post RSS
      • 15. Re: How to restore specific backup file from RMAN?
        1002173
        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
          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:

          http://arjudba.blogspot.com/2008/05/how-to-discover-find-dbid.html
          • 17. Re: How to restore specific backup file from RMAN?
            gopal
            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
              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