Home » RDBMS Server » Backup & Recovery » recovery manager
recovery manager [message #69905] Tue, 19 March 2002 00:59 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Is there are possible to make automatic daily backup with RMAN?
Next Topic: How to perform automatic execution of backup with RMAN
Goto Forum:
  


Current Time: Thu Dec 01 14:08:12 CST 2022