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
Step 5 is where the problem was initiated. Any suggestions?
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.