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

Thread: problem creating recovery catalog

  1. #1
    Join Date
    Mar 2001


    I am creating the recovery catalog but I am having some problems. Below is what I have done so far and the error message that I got.

    SVRMGR> create tablespace CATALOG
    2> datafile '/ora1/o2/DATA1/cat1rcat.dbf'
    3> size 1000m;
    Statement processed.
    SVRMGR> create user rman identified by rman
    2> temporary tablespace temp
    3> default tablespace CATALOG quota unlimited on CATALOG;
    Statement processed.
    SVRMGR> grant recovery_catalog_owner to rman;
    Statement processed.

    machine oracle DATA1 /ora1/08/dbse
    $ export ORACLE_SID=RCAT

    machine oracle RCAT /ora1/08/dbse
    $ rman catalog rman/rman

    Recovery Manager: Release - Production

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-04004: error from recovery catalog database: ORA-01034: ORACLE not available

    MY O/S is AIX
    Oracle version
    I have 2 databases (DATA1,DATA2)

    Any help?


  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    Your catalog database would be the one where you have created the rman user. That would be either DATA1 or DATA2 not RCAT.

    export ORACLE_SID= ?

    sqlplus sys/passwd@your-catalog instance <-- where you have created the user rman

    SQL> grant connect, resource to rman;
    SQL> exit

    rman catalog rman/rman
    RMAN> create catalog tablespace catalog;
    RMAN> connect target sys/passwd@targetdb
    RMAN> register database;
    RMAN> exit


    [Edited by sambavan on 06-14-2001 at 11:57 AM]

    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