Home » RDBMS Server » Backup & Recovery » error set in sbterror by MM, does not get printed on the console?
error set in sbterror by MM, does not get printed on the console? [message #519972] Thu, 18 August 2011 00:42 Go to next message
swaorclser
Messages: 56
Registered: August 2011
Member
sbterror has the proper error string set by MM.
But, it is not displaying it in console.
Is this a knows problem which occurs sometime?

Please help.
Re: error set in sbterror by MM, does not get printed on the console? [message #519979 is a reply to message #519972] Thu, 18 August 2011 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without no information you can't have any help.

Regards
Michel
Re: error set in sbterror by MM, does not get printed on the console? [message #520005 is a reply to message #519979] Thu, 18 August 2011 03:08 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Ok. Sorry.
and thanks for your reply.
When I run oracle DB init job with Media management software, for some reason it fails.
But, in rman console it doesnot print the error. It shows
"ORA-19511 : Error received from media management layer: error text: "
and does not print the text.


sbterror function is called whenever there is any error.
sbterror(void *ctx,
unsigned long flags,
unsigned long *error_code,
char **error_text_native,
char **error_text_utf8)

Also , we can set error in error_text_native variable. I can see that to be set properly. But its not getting printed, that is the problem.

Hope this explains my problem.

Thanks!
Re: error set in sbterror by MM, does not get printed on the console? [message #520010 is a reply to message #520005] Thu, 18 August 2011 03:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
"ORA-19511 : Error received from media management layer: error text: "
and does not print the text.

So the MML did not send a text, just a not 0 return code telling to Oracle there is a problem in the MML.

Quote:
I can see that to be set properly

If you say so. We have no clue of what you did and got.
Please read OraFAQ Forum Guide, especially point 7.

Regards
Michel
Re: error set in sbterror by MM, does not get printed on the console? [message #520022 is a reply to message #520010] Thu, 18 August 2011 04:07 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Quote:
I can see that to be set properly


Means in the log that error is getting printed.

I will read the guidelines definitely.

Thanks!
Re: error set in sbterror by MM, does not get printed on the console? [message #520024 is a reply to message #520022] Thu, 18 August 2011 04:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Waiting...

Regards
Michel
Re: error set in sbterror by MM, does not get printed on the console? [message #520280 is a reply to message #520024] Sat, 20 August 2011 04:55 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Hello All,

I have set the error in sbterror function, in logs we are printing that error.
I can see the proper error in log being set but the RMAN console is not printing the error.

I tried various error strings for I doubted that it might be related to length of the error message.
But, no success. Sad

Did someone face similar problem?

Thanks & Regards,
-swaorclser
Re: error set in sbterror by MM, does not get printed on the console? [message #520285 is a reply to message #520280] Sat, 20 August 2011 09:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 18 August 2011 10:16
...
If you say so. We have no clue of what you did and got.
Please read OraFAQ Forum Guide, especially point 7.

swaorclser wrote on Thu, 18 August 2011 11:07
...
I will read the guidelines definitely.

Thanks!


Michel Cadot wrote on Thu, 18 August 2011 11:08
Waiting...

Regards
Michel

Re: error set in sbterror by MM, does not get printed on the console? [message #521339 is a reply to message #519972] Mon, 29 August 2011 00:31 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Hello,

Finally I got the solution to my problem.

Cause is:

The string which we give to sbterror function in case of MM failure, it has got restrictions:

From Oracle Media Management API Info guide,

Quote:

If the error message is more than 80 characters long, it should be appropriately
formatted with new-line characters.


After formatting my string, now RMAN is showing it! Smile


Thanks & Regards,
swaorclser
Re: error set in sbterror by MM, does not get printed on the console? [message #521343 is a reply to message #521339] Mon, 29 August 2011 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Re: error set in sbterror by MM, does not get printed on the console? [message #521580 is a reply to message #521343] Wed, 31 August 2011 05:54 Go to previous message
swaorclser
Messages: 56
Registered: August 2011
Member
You are WelCome!

Thanks & Regards,
swaorclser
Previous Topic: ORA-01422: exact fetch returns more than requested number of
Next Topic: block change tracking file
Goto Forum:
  


Current Time: Wed Dec 01 22:30:05 CST 2021