Rman Q !!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Rman Q !!

Hybrid View

  1. #1
    Join Date
    Jul 2003
    Posts
    323

    Rman Q !!

    Is there a command to unregister a db from the catalog -
    besides the
    EXECUTE dbms_rcvcat.unregisterdatabase(db_key, db_id)
    method ?
    i.e why did'nt Oracle think of
    UNREGISTER DATABASE ?
    or is it in 10g?

    Also any links to doc. on dbms_rcvman & dbms_rcvcat,dbms_backup_restore ??


  2. #2
    Join Date
    Oct 2002
    Posts
    807
    Dunno about 10g.

    My 1 cent.
    A database possibly has multiple incarnations. If they had a "unregister database" a novice dba might blow away all the incarnations. Just 'theorizing'..

    In anycase, what's so difficult/complicated about "EXECUTE dbms_rcvcat.unregisterdatabase(db_key, db_id)". It is an equivally simple command in my opinion.

    As for links - It is all documented in the RMAN user guide.
    http://download-west.oracle.com/docs...pos.htm#442604

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    From 10g doc
    Unregistering a Database: Example
    In this example, you connect to the target database test1 and then unregister it:

    rman TARGET SYS/oracle@test1 CATALOG rman/rman@catdb

    RMAN> UNREGISTER DATABASE NOPROMPT;

    only 10g

  4. #4
    Join Date
    Jul 2003
    Posts
    323
    Tx pando - confirmed my suspicions - Oracle is still upto it's old tricks of creating/jumping on a buzz & selling ->

    v.7-8 -> "Best" relational d/b
    v.8i -> Internet d/b..
    v.9i -> Prime time for web d/b,RAC,HA/MA...blah blah
    v.10g -> Grid..more blah blah

    Why not have unregister db in 9i - probably product dev. was too rushed to deliver/release mgmt. guys screwed up..and the 10g guys put it in?


  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    10g is screwed up

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