I only know the script for rman in Oracle8. It is in d:\orant\rdbms80\admin\catrman.sql;
Where is it in Oracle8i. I searched in d:\oracle\or81\rdbms\admin directory. There is no script available as catramn.sql.
Could any one help pls.
there is no catrman.sql in 8i. all you need to do is create ur recovery catalog with a user rman and grant select catalog role to that user
In 8i the dbmsrman.sql will be executed automatically when you get to call the catproc script. So you don't have to run it once again.
As vinit pointed out you just have to create the repository and assign the appropriate privileges for the user.
Life is a journey, not a destination!
What you need to do is the following:
CREATE TABLESPACE RCVCAT
DATAFILE '/dev/vx/rdsk/datadg/disk23' SIZE 20M
AUTOEXTEND ON NEXT 5M MAXSIZE 250M;
CREATE USER rman IDENTIFIED BY password
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rcvcat
QUOTA UNLIMITED ON rcvcat;
GRANT RECOVERY_CATALOG_OWNER TO rman;
GRANT CONNECT, RESOURCE to rman;
%rman catalog rman/password@catdb
RMAN>create catalog tablespace 'RCVCAT';
I have noticed that in the "create catalog" command (8.1.7), RCVCAT must in in quotes and in capitals.
Click Here to Expand Forum to Full Width