3 Replies Latest reply: Mar 21, 2013 8:50 AM by TSharma-Oracle RSS

    DBID

    941949
      dear friends,
      how to get dbid when db is shut down and all files are lost and only left with rman backup?your help appreciated,thanks.


      db:10.2.0.3
      os:5.7 RHEL.
        • 1. Re: DBID
          Paul M.
          • 2. Re: DBID
            606331
            is it oracle binaries exist right?

            export ORACLE_SID=xxxxx
            rman target /

            it will display your database id.....
            • 3. Re: DBID
              TSharma-Oracle
              In your RMAN backup, if your controlfile is set default for automatic backup, you can take the dbid from there. The default format is %F which stands for

              the format of the autobackup file for all configured devices is the substitution variable %F. This variable format translates into c-IIIIIIIIII-YYYYMMDD-QQ, where:

              IIIIIIIIII stands for the DBID
              •YYYYMMDD is a time stamp of the day the backup is generated
              •QQ is the hex sequence that starts with 00 and has a maximum of FF