doubt on recovery catalog
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: doubt on recovery catalog

  1. #1
    Join Date
    Apr 2006
    Posts
    35

    doubt on recovery catalog

    I have askted my management to give a separate machine to maintain
    recovery database.
    Now the probelm is i have 2 different production enviroment
    1.oracle 8 on windows
    2.oracle 9i on windows
    can both oracle 8 and oracle9i database can be installed in the same machine,so that i can maintain catalogs of both version
    Plz guide me
    Thanks and regards,

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    1) You do not need to install the DBs on the same machine in order to share the same recovery catalog
    2) I am not sure if DBs in different versions can share same recovery catalog

  3. #3
    Join Date
    Apr 2006
    Posts
    35
    I wish to maintain 2 recovery catalogs
    1 for oracle 8
    1 for oracle 9i
    now if i install one oracle version above other one of the version gets
    overwritten
    Plz suggest a way

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you only need one catalog

  5. #5
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    It is definitely not clear what are you asking and what are you doing.
    Pls. explain in more details

  6. #6
    Join Date
    Apr 2006
    Posts
    35
    (i)I have 9 production database on oracle 8 for which i am using
    Recovery Manager: Release 8.0.6.0.0 - Production
    (ii)I have 2 production database on oracle 9i for which i am using
    Recovery Manager: Release 9.2.0.2.1 - Production

    After long discussion i got a machine to maintain rcvcat
    now I am going to maintain (i)oracle 8 rcvcat in this new machine

    Now my doubt is can i have oracle 9i home so that i can maintain
    the catalog of (ii)

  7. #7
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    Quote Originally Posted by natraj.dba
    (i)I have 9 production database on oracle 8 for which i am using
    Recovery Manager: Release 8.0.6.0.0 - Production
    (ii)I have 2 production database on oracle 9i for which i am using
    Recovery Manager: Release 9.2.0.2.1 - Production

    After long discussion i got a machine to maintain rcvcat
    now I am going to maintain (i)oracle 8 rcvcat in this new machine

    Now my doubt is can i have oracle 9i home so that i can maintain
    the catalog of (ii)
    Create 1 9i Catalog. It can backup up your 8 and 9i databases. No need to have 2 catalogs.

  8. #8
    Join Date
    Apr 2006
    Posts
    35
    Thank you sir,
    this was haunting me for a very long time
    thanks again

  9. #9
    Join Date
    Apr 2006
    Posts
    35
    As suggested by senior member
    i tried to backup oracle 8 db using 9i catalog
    I get following error message

    C:\>rman catalog rman/rman target=sys/oracle@remote

    Recovery Manager: Release 9.2.0.1.0 - Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    Recovery Manager incompatible with TARGET database: RMAN 8.0.4 to 8.0.4 required

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-06429: TARGET database is not compatible with this version of RMAN

    C:\>
    Could some one plz help

  10. #10
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Well, the problem is you start the RMAN at the rcvcat host.
    Go to the database host and issue
    rman target / catalog rman/rman@allias
    RMAN> register database

    And go further

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