I want to use rman, for this it is must to create recovery catlog to run catrman.sql which resides in /../rdbms/admin/catrman.sql .But I am not getting this script in admin directory. My Oracle (188.8.131.52) is installed on Win 2000.
Please suggest me to how to get this script to use rman utilities.
This is run automatically when u run catproc.sql
From Oracle 8.1.5 onwards there is no catrman.sql script to create the recovery catalog.Instead of that u have to use create catalog command at the rman prompt to create the RMAN catalog.
The following is the procedure to do it:
connect to rman
rman target="sys/sys@orc1" rcvcat="rman/rman"
Create the RMAN catalog
RMAN> create catalog;
Register the target database in RMAN of which u have to
take the backup.
RMAN> register database ;
In case of any help please be free to ask me at email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i