Home » RDBMS Server » Backup & Recovery » Rman backup gives error message RMAN-00554 (Oracle 11G Windows R2008)
Rman backup gives error message RMAN-00554 [message #615722] Sun, 08 June 2014 05:57 Go to next message
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.



Re: Rman backup gives error message RMAN-00554 [message #615723 is a reply to message #615722] Sun, 08 June 2014 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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?

Re: Rman backup gives error message RMAN-00554 [message #615725 is a reply to message #615723] Sun, 08 June 2014 07:29 Go to previous messageGo to next message
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/
Re: Rman backup gives error message RMAN-00554 [message #615728 is a reply to message #615725] Sun, 08 June 2014 09:43 Go to previous messageGo to next message
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
Re: Rman backup gives error message RMAN-00554 [message #615729 is a reply to message #615728] Sun, 08 June 2014 09:51 Go to previous messageGo to next message
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/
Re: Rman backup gives error message RMAN-00554 [message #615755 is a reply to message #615729] Mon, 09 June 2014 00:27 Go to previous messageGo to next message
martens_b2014
Messages: 13
Registered: June 2014
Junior Member
No errors in the listener log file.
Re: Rman backup gives error message RMAN-00554 [message #615756 is a reply to message #615755] Mon, 09 June 2014 00:29 Go to previous messageGo to next message
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 Go to previous messageGo to next message
martens_b2014
Messages: 13
Registered: June 2014
Junior Member
Here is the file:
  • Attachment: LISTENER.LOG
    (Size: 361.76KB, Downloaded 1652 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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: Rman backup gives error message RMAN-00554 [message #615822 is a reply to message #615816] Mon, 09 June 2014 11:05 Go to previous messageGo to next message
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;
Re: Rman backup gives error message RMAN-00554 [message #615850 is a reply to message #615822] Tue, 10 June 2014 02:17 Go to previous messageGo to next message
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.
Re: Rman backup gives error message RMAN-00554 [message #615871 is a reply to message #615850] Tue, 10 June 2014 07:30 Go to previous messageGo to next message
EdStevens
Messages: 1376
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.
Re: Rman backup gives error message RMAN-00554 [message #615876 is a reply to message #615871] Tue, 10 June 2014 08:12 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Rman backup gives error message RMAN-00554 [message #615880 is a reply to message #615877] Tue, 10 June 2014 08:32 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Rman backup gives error message RMAN-00554 [message #615882 is a reply to message #615881] Tue, 10 June 2014 08:53 Go to previous messageGo to next message
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.
Re: Rman backup gives error message RMAN-00554 [message #615884 is a reply to message #615882] Tue, 10 June 2014 09:03 Go to previous messageGo to next message
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!
Re: Rman backup gives error message RMAN-00554 [message #616055 is a reply to message #615884] Thu, 12 June 2014 01:27 Go to previous messageGo to next message
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.
Re: Rman backup gives error message RMAN-00554 [message #616056 is a reply to message #616055] Thu, 12 June 2014 01:54 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks to let us know.

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:
  


Current Time: Fri Mar 29 07:18:28 CDT 2024