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

Thread: Urgent! RMAN Configuration

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    19

    Exclamation

    I am tryting to set up Recovery Manager. When trying to run catrman.sql, the system complains "file not found". I went to ORACLE_HOME/rdbms/admin directory, not able to locate this file: catrman.sql. Did I miss something here? Help, please.

    I am running Oracle 8.1.5 on Linux 6.2.

    Thanks for your help.

    SY

  2. #2
    Join Date
    Apr 2000
    Posts
    126

    Wink

    There is no longer a catrman.sql script. There is an rman command. Look at 'create catalog' command in the Backup and Recovery guide.



  3. #3
    Join Date
    Oct 2000
    Posts
    19
    Thank you, mhaller, for the response.

    If no more of catrman.sql script, what is the new script?

    Can anyone give me a quick answer as what script I need to run in order to create the neccessary tables for the recovery catalog for Oracle 8.1.5. on Linux 6.2.

    I used catrman.sql sript when configuring the RMAN for oracle 8, and it was successful.

    Thanks.

  4. #4
    Join Date
    Apr 2000
    Posts
    126

    Wink

    You do not need to run any script.

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    RMAN is a oracle executable/utility just like exp/imp/sql*ldr for 8i releases... you use rman to invoke the utility.

  6. #6
    Join Date
    Oct 2000
    Posts
    19
    I guess I did not make myself clear in the first try. Here we go again:

    I came across the problem when I was trying to create Recovery Catalog. To set up Recovery Catalog, Oracle suggests the following:
    1. create a tablespace for the recovery catalog
    2. create recovery manager user
    3. grant recovery_catalog_owner role to rman
    4. Garnt DBA privileges to rman user
    5. create neccessary tables for the recovery catalog by running catrman.sql script under ORACLE_HOME/rdbms/admin

    Step 5 is where the problem was initiated. Any suggestions?

    Thanks.

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Hold on .....

    You don't have to give the DBA privileges to RMAN user. The privileges that you give to the rman are as follows

    CONNECT, RESOURCE and RECOVERY_CATALOG_OWNER


    Once after doing this,

    do the following

    rman catalog rman_user/pwd@rman_instance

    RMAN> create catlog tablespace rman_tablespace


    This would create the catalog in the database for you. The catrman.sql was some thing that we had to use in the prior versions of oracle. But as of 8i, ram is created using catproc and catalog scripts i presume (I'm not suer infact).

    Once the catalog is created

    RMAN> target sys@target_database


    RMAN> register database;

    This would register the database in your catalog and do a fully sync.

    Good luck
    Sam
    Thanx
    Sam



    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