| recovery manager [message #69905] |
Tue, 19 March 2002 00:59  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
I'm trying to create the recovery catalog. I have two databases on my local system-sonata and kris.
Step 1:SQL> CONNECT sys/change_on_install@rcat
Step 2:SQL> SPOOL create_rman.log
Step 3: CREATE USER rman IDENTIFIED BY rman
2> TEMPORARY TABLESPACE temp
3> DEFAULT TABLESPACE krists01
4> QUOTA UNLIMITED ON krists01;
Step 4:SQL>GRANT recovery_catalog_owner TO rman;
Step 5:SQL> GRANT connect, resource TO rman;
Now from the command line prompt, i entered
Step 6:RMAN>connect catalog rman/rman@kris
and got the following error message
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION
|
|
|
|
| Re: recovery manager [message #69907 is a reply to message #69905] |
Tue, 19 March 2002 03:08  |
Anatol
Messages: 15
Registered: January 2002
|
Junior Member |
|
|
Try this : from command prompt prcess this command:
rman tagret targ_user/targ_password@targ_db_name catalog cat_user/cat_passwd@cat_db_mane
I make this in my work .
|
|
|
|
| Re: recovery manager [message #69912 is a reply to message #69905] |
Tue, 19 March 2002 05:02 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Try: connect rcvcat rman/rman@kris
Also check to make sure you have no invalid objects in the SYS schema. You could also run catproc.sql again as SYS which runs dbmsrman.sql to install RMAN.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
