If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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 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

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).