OraFAQ Forum: Backup & Recovery » Rman backup gives error message RMAN-00554

Home » RDBMS Server » Backup & Recovery » Rman backup gives error message RMAN-00554 (Oracle 11G Windows R2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rman backup gives error message RMAN-00554 [message #615722]

Sun, 08 June 2014 05:57

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

Hi,

On our STANDBY database we also make backups. since a while these backups have an error in almost all backup logfiles. Only very few haven't. The message is:

RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

I have no idea why this is happening suddenly as nothing has changed. The fact that most backups now fail but not all of them makes it strange. Specially around midnight some of the backups actually work. We have on the same server another standby database and this one has no problem with the backup.

The RMAN-catalog is running on a different server which is only dedicated to backups for all kind of instances that we have. Only this particular standby database causes problems.
The scripts are started on the dataguard itself by a windows scheduler. When I use the DOS-prompt and connect to the target with the catalog and I run the syntax that is within the script then there is no error message at the end. It finishes correctly.

I already tried replacing the password files from the cluster instances of the primary database but that didn't work.

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615723 is a reply to message #615722]

Sun, 08 June 2014 06:28

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How do you connect to RMAN and target database?
Which user launches RMAN? (including its groups)
Is the database local to the RMAN session or remote?

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615725 is a reply to message #615723]

Sun, 08 June 2014 07:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615728 is a reply to message #615725]

Sun, 08 June 2014 09:43

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

Hi,

- Connection: rman target / catalog username/password@rmancatalog

- The RMAN script is on the local standbyserver itself and is launched by a
special Oracle user that is a member of the Oracle group. That same user
is also launching the scripts for the other standby database on this server
which is not a problem.

- The script is on the local server and connecting remotely to the RMAN catalog
database as RMAN is on a special server for all backups.

Regards,
Ben martens

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615729 is a reply to message #615728]

Sun, 08 June 2014 09:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

please stop obfuscating your reality if you expect to actually solve your mystery.

post excerpt from listener log file on Catalog database system showing the connection attempt which throws posted errors

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615755 is a reply to message #615729]

Mon, 09 June 2014 00:27

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

No errors in the listener log file.

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615756 is a reply to message #615755]

Mon, 09 June 2014 00:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I wonder if you would recognize error if it bit you.

PLEASE post excerpt from listener log so we can conclude same as you.

[Updated on: Mon, 09 June 2014 00:30]

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615770 is a reply to message #615722]

Mon, 09 June 2014 02:49

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

Here is the file:

Attachment: LISTENER.LOG
(Size: 361.76KB, Downloaded 580 times)

[Updated on: Mon, 09 June 2014 03:22]

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615816 is a reply to message #615770]

Mon, 09 June 2014 09:36

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I would check if the script is trying to talk with right database.
Check ORACLE_SID etc set it the environment that calls the script.

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615822 is a reply to message #615816]

Mon, 09 June 2014 11:05

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

I am not a fulltime DBA, however, if you are on RAC, can you post result of :

select * from gv$pwfile_users;

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615850 is a reply to message #615822]

Tue, 10 June 2014 02:17

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

The environment is good. I executed the script for every commandline manualy and it works.

I can't put a select on the gv$pwfile_users as it is a standby database.

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615871 is a reply to message #615850]

Tue, 10 June 2014 07:30

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

martens_b2014 wrote on Tue, 10 June 2014 02:17

The environment is good. I executed the script for every commandline manualy and it works.

So is it failing if executed from cron (which reminds me, I don't see where you actually told us what OS it is on, but I may have overlooked it).

If so, scripts executed from cron do not inherit any enviornment variables. Your .bash_profile is not executed as part of launching a process from cron. your script would be responsible for all environment variables it needs. That's where the oracle supplied script 'oraenv' comes to the rescue.

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615876 is a reply to message #615871]

Tue, 10 June 2014 08:12

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

Sorry, I am new on this site and I see in the top of this topic the OS version and the Oracle Version. Am I as the creator of this topic the only one who is seeing this?

OS: windows R2008
Oracle Version 11.2.0.1.0

Actualy it is the scheduler of Windows 2008. In the script I set the environment variables to make sure they are the right ones.

[Updated on: Tue, 10 June 2014 08:19]

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615877 is a reply to message #615876]

Tue, 10 June 2014 08:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>In the script I set the environment variables to make sure
you can be sure & WRONG at the same time.

Either Oracle correctly reports reality or you are hitting an Oracle bug.
I would bet that your environment is mis-configured & Oracle is correctly trowing these errors

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615880 is a reply to message #615877]

Tue, 10 June 2014 08:32

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

Hi Swan,

I would not bet to much if I were you.

This script worked fine for a long time and all of sudden without any change it didn't.....most of the time. As I already explained here above, the script works mostly for some time around midnight.

A script stays the same and doesn't alter by itself. Either it works or not. If it works sometimes it means that something else must be wrong.

To make sure of that I opened a DOS-window I did set each environment setting in that script seperately after which I executed the backup scriptline which actually starts the backup and it worked perfectly.

What are the errors in the Listener logfile that I missed?

[Updated on: Tue, 10 June 2014 08:36]

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615881 is a reply to message #615880]

Tue, 10 June 2014 08:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What I noticed from the listener log file excerpt is that multiple different system connect to the listener using different USERNAME
Since have obfuscated actual details or just not provided any, I have no idea which log entries work without error & which are associated with posted RMAN errors

same inputs to scripts produce same results.
when different results occur, it means that SOMETHING has changed.
since other system can successfully & repeatedly connect to this Oracle DB, I conclude that something on the remote client which throws the errors is changing.
You are free to conclude otherwise & continue your snipe hunt.

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615882 is a reply to message #615881]

Tue, 10 June 2014 08:53

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

Hi Swan,

I fully agree. The question is what could have possibly changed. I placed this topic as I was hoping that someone experienced before and could give me a hint to get closer to my target while snipe hunting.

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #615884 is a reply to message #615882]

Tue, 10 June 2014 09:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

compare & contrast those that work against those that throw error.
SOMETHING is different between those two situations.
It does NOT matter what happened in the past. What matters is what is happening NOW.
Telling yourself & others that "nothing changed" or there is "no difference" is not correct and not productive; because by definition something is DIFFERENT!

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #616055 is a reply to message #615884]

Thu, 12 June 2014 01:27

martens_b2014
Messages: 13
Registered: June 2014

Junior Member

Hi Swan,

You are definitely right. A script doesn't change but if something suddenly doesn't work then somewhere in the environment of that script something has changed.

Just for sharing the solution:
I couldn't find exactly what caused it but just to be sure I deleted and recreated every task in the taskscheduler of Windows that was related to rman backups and started the tasks manually to test and it worked. From there the backups for this standby database where working again when scheduled.

Report message to a moderator

Re: Rman backup gives error message RMAN-00554 [message #616056 is a reply to message #616055]

Thu, 12 June 2014 01:54

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks to let us know.

Report message to a moderator

Previous Topic:	ORA-19554: error allocating device, device type: SBT_TAPE
Next Topic:	How RMAN handles backup pieces sent to tape,when backup failed in halfway

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 25 16:00:28 CDT 2023