RMAN ? create catalog?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: RMAN ? create catalog?

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Exclamation

    Hello. Before I was create RMAN for 8.05. I just installed 8.1.6 and got into the process of create rman. According to rman docs you have to run catrman.sql but in 8.1.6 cat rman doesnt exist. oracle note says to just create catalog command and I have referenced the backup/recovery guide for 8.1.6 and I cannot locate this create catalog. Anybody have the syntax?

    thanks
    Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Mar 2001
    Posts
    13

    Unhappy

    I need to create rman for 8.0.5. Any information with be greatly appreciated

    Thanks,
    Bond..

  3. #3
    Join Date
    Jan 2001
    Posts
    216
    I just did this yesterday, so its fresh in my memory !

    %set ORACLE_SID=rmandb
    %rman catalog rman/rmanpassword

    rman>create catalog

    Hope this helps

  4. #4
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    I did on 8.1.5
    RMAN>connect catalog rman/rman@sid(which is different from the database you are going to backup)
    RMAN>create catalog tablespace rcvcat;

    Dragon

  5. #5
    Join Date
    Nov 2000
    Posts
    245

    to use rman
    805 you have to run catrman.sql
    81x you don't need, just run rman

  6. #6
    Join Date
    Mar 2001
    Posts
    77

    Create catalog

    Here's what I had done, but it's in version 8.1.5.

    1 CREATE TABLESPACE rman_ts DATAFILE 'd:\oratestdb\orafiles\rman_01.dbf'
    2* SIZE 10M autoextend on next 10M maxsize 30M;

    1 CREATE USER rman IDENTIFIED BY rman
    2 TEMPORARY TABLESPACE temp
    3 DEFAULT TABLESPACE rman_ts
    4* QUOTA UNLIMITED ON rman_ts
    SQL> /

    User created.

    SQL> GRANT recovery_catalog_owner TO rman;

    Grant succeeded.


    SQL> GRANT connect, resource TO rman;

    Grant succeeded.
    *****************************


    D:\>rman

    Recovery Manager: Release 8.1.5.0.0 - Production


    RMAN> CREATE CATALOG tablespace rman_ts;

    RMAN-06431: recovery catalog created

    HTH.

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