rman script in 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: rman script in 8i

  1. #1
    Join Date
    Nov 2000
    Posts
    101

    Red face

    Dear Friends,

    I only know the script for rman in Oracle8. It is in d:\orant\rdbms80\admin\catrman.sql;

    Where is it in Oracle8i. I searched in d:\oracle\or81\rdbms\admin directory. There is no script available as catramn.sql.

    Could any one help pls.


    Thanks
    gandhi

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    there is no catrman.sql in 8i. all you need to do is create ur recovery catalog with a user rman and grant select catalog role to that user
    Vinit

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    In 8i the dbmsrman.sql will be executed automatically when you get to call the catproc script. So you don't have to run it once again.

    As vinit pointed out you just have to create the repository and assign the appropriate privileges for the user.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    What you need to do is the following:

    CREATE TABLESPACE RCVCAT
    DATAFILE '/dev/vx/rdsk/datadg/disk23' SIZE 20M
    AUTOEXTEND ON NEXT 5M MAXSIZE 250M;

    CREATE USER rman IDENTIFIED BY password
    TEMPORARY TABLESPACE temp
    DEFAULT TABLESPACE rcvcat
    QUOTA UNLIMITED ON rcvcat;

    GRANT RECOVERY_CATALOG_OWNER TO rman;
    GRANT CONNECT, RESOURCE to rman;

    Then:

    %rman catalog rman/password@catdb
    RMAN>create catalog tablespace 'RCVCAT';
    RMAN>exit;

    I have noticed that in the "create catalog" command (8.1.7), RCVCAT must in in quotes and in capitals.




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