Home » RDBMS Server » Backup & Recovery » Rman error (Linux)
Rman error [message #331302] Wed, 02 July 2008 23:35 Go to next message
darshana01
Messages: 7
Registered: June 2008
Location: Bangalore
Junior Member
Hi,
I am getting the following error.Please guide me through this:


[oracle@trainee bin]$ ./rman catalog=sys/sys

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 3 09:48:27 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

******
Please help!! Smile




Re: Rman error [message #331310 is a reply to message #331302] Wed, 02 July 2008 23:47 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Did you grant sysdba privilege to catalog owner?
Re: Rman error [message #331311 is a reply to message #331302] Wed, 02 July 2008 23:47 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
What does your documented & tested Recovery Manual say to do?
Re: Rman error [message #331316 is a reply to message #331310] Thu, 03 July 2008 00:06 Go to previous messageGo to next message
darshana01
Messages: 7
Registered: June 2008
Location: Bangalore
Junior Member
yes i did grant the privilage.
Re: Rman error [message #331318 is a reply to message #331316] Thu, 03 July 2008 00:11 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
darshana01 wrote on Wed, 02 July 2008 22:06
yes i did grant the privilage.


So, what do you do now?
Re: Rman error [message #331325 is a reply to message #331302] Thu, 03 July 2008 00:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You do not need sysdba priv for the catalog owner.
Overkill.
Just make sure you are logging in as the correct catalog owner.
SYS should NOT BE CATALOG owner.
Create a separate rman user with NECESSARY privs.
By default
--wont work.
oracle@gretel#rman catalog=sys/sys

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 3 01:36:39 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

-- will not work
oracle@gretel#rman catalog=sys/sys@rmandb

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 3 01:36:46 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-28009: connection to sys should be as sysdba or sysoper

-- login as correct catalog owner to RMANDB
oracle@gretel#rman catalog=r_xxx/rman@rmandb

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 3 01:36:54 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to recovery catalog database

RMAN> exit


Recovery Manager complete
Re: Rman error [message #331329 is a reply to message #331302] Thu, 03 July 2008 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYS should NOT be the catalog owner.

Regards
Michel
Re: Rman error [message #331348 is a reply to message #331329] Thu, 03 July 2008 01:34 Go to previous messageGo to next message
darshana01
Messages: 7
Registered: June 2008
Location: Bangalore
Junior Member
OK.But i have tried sys as catalog the last.. it had worked fine.Why the error this time Any idea??

Thanks
Re: Rman error [message #331353 is a reply to message #331348] Thu, 03 July 2008 01:51 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't do what you think you did.

Regards
Michel
Previous Topic: Need Help in Oracle Export/Import?
Next Topic: Archive log
Goto Forum:
  


Current Time: Fri Dec 09 11:33:38 CST 2016

Total time taken to generate the page: 0.05134 seconds