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.
12-22-2000, 12:46 PM
There is no longer a catrman.sql script. There is an rman command. Look at 'create catalog' command in the Backup and Recovery guide.
12-22-2000, 01:03 PM
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.
12-22-2000, 01:17 PM
You do not need to run any script.
12-22-2000, 01:20 PM
RMAN is a oracle executable/utility just like exp/imp/sql*ldr for 8i releases... you use rman to invoke the utility.
12-22-2000, 01:50 PM
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?
12-24-2000, 02:43 AM
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.