DBID
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: DBID

  1. #1
    Join Date
    Apr 2001
    Posts
    142
    When you connect to your taget database with RMAN you are give a DBID as shown below.

    C:\>RMAN TARGET SYS/MANAGER@GTS-CLUSTER2 RCVCAT=RMAN/RMAN@RMAN

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-06005: connected to target database: PICIS_DB (DBID=1706918627)
    RMAN-06008: connected to recovery catalog database

    Is this the unique identifier by which recovery manager knows which backup belongs to which database?

    Thanks

  2. #2
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    Yes the DBID is an internal number generated by oracle during the database create and is used to identify the database.
    Typically each database has a unique number however there is an exception - when you create a database by copy files from an existing database instead of using the create database command.
    In such cases you will not be able to register the second database due to the duplicate DBID.
    If failure to register occurs due to a duplicate create a second recovery catalog in another schema and register the database against the second catalog.

    Cheers
    Moff.

  3. #3
    Join Date
    Apr 2001
    Posts
    142

    For Moff

    Thanks Moff,

    ok so in the case where you have to recreate a new instance before restoring the database. When you connect to the new instance you will get a new BDID which RMAN will not recogonise as the one you would like to restore the backup to. What do you do in this case?????'

    Thanks.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    As Moff, pointed when you create a database, a new DBID is generated internally. Similarly, when you do a duplicate, this would copy the files from the existing database and generate a new unique DBID. Which would avoid the problem of redundant DBID.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Apr 2001
    Posts
    142
    I am talking about a case where the original instance has been destroyed and a new instance must be created. In this case a new DBID must be used so how can RMAN know to restore the previous DBID backups to this DBID?

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I hope this would explain you.

    http://www.oradoc.com/ora816/server....eco.htm#443287

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Apr 2001
    Posts
    142
    Hi,

    just a question on the documentation. In the step below

    "if the database is open, shut it down and then mount it:

    shutdown immediate;
    startup mount;"

    I can shutdown the database from RMAN but when I try and run the startup mount; command. I get the following :


    RMAN> shutdown immediate;

    RMAN-06405: database closed
    RMAN-06404: database dismounted
    RMAN-06402: Oracle instance shut down

    RMAN> startup mount;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-04005: error from target database: ORA-12505: TNS:listener could not resolve SID given in connect descriptor

    Whats the problem?

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Have you set the ORACLE_SID in the environment variable. In the mean time check your tnsnames.ora file and make sure that you have the services defined there.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width