RMAN with multiple databases
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: RMAN with multiple databases

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Oracle 8.1.6 on SCO Unixware 7.1.1

    Hi Friends,

    I am going to start uing RMAN for backup and recovery.
    I will be creating a recovery catalogue in the same database as my OEM repository.

    I need to know whether a recovery catalogue in a particular database can hold backup/recovery information for several other databases i.e. prod/ test/ dev.

    How does RMAN distinguish between the several databases it is holding information on ?

    Thanks

    Suresh

  2. #2
    Join Date
    Oct 2000
    Posts
    42
    Let me suggest that you create a separate database dedicated to RMAN and its catalog. It may be on the same machine that you have your OEM database now. After you have created your RMAN catalog, you will need to register all the DB that you want RMAN to backup with it i.e RMAN database. When you create a new database, Oracle assigns a unique DBID to the database. This unique ID is what RMAN uses to distiguish between the databases that it backs up.

    A word of caution here, you cannot copy a database from another and hope RMAN will back it up because of the DBID. Also, make sure that the RMAN database is at least 816. If your rman db is 815 and all your db are 816 you may run into problem.

    oisaya

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi,

    Thanks for your prompt reply.
    both my databases will be 8.1.6.

    So are you trying to tell me that if i were to clone a database, it would have the same dbid as the database it was cloned from ?
    I take it that I can clone a database and then register it and it would be thought of as a completely different database to the original even though both databases will be in the catalogue. Please confirm.

    Also I am looking for the script which creates the rman catalogue.
    I thought it was called ORACLE_HOME/rdbms/admin/catrman.sql, but there is no script named that here. Is it called something different in 8.1.6.

    Thanks

    Suresh



  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Found it now :

    use create catalogue command.

  5. #5
    Join Date
    Oct 2000
    Posts
    42
    You cannot clone a database and hope rman will back it up. It will be better to create a new database register it with RMAN. Do export and import to get your new database populated and you will be set to go.

    Oisaya

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