Home » SQL & PL/SQL » SQL & PL/SQL » DR Failure
DR Failure [message #672463] Tue, 16 October 2018 05:41 Go to next message
msyogi
Messages: 16
Registered: May 2016
Location: Hyderabad
Junior Member
Dear Friends,

We had a Disaster Recovery Activity on last saturday and it got failed and DBA team reverted back all the activities. We had many number of scheduled jobs running everyday. And after DR activity reverted back, we are seeing many job failures. As this is Insurance domain project all the cancellations, reinstatement and renewals etc policies were impacted. The common error we are facing attached to this. Please let me know if you need more info. Kindly assist us in resolving this issue.

Regards
Mahendra S



Re: DR Failure [message #672465 is a reply to message #672463] Tue, 16 October 2018 05:50 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I do not think that there is any advice that can be given, other than "tell your DBAs to sort it out". People will tell you that an ORA-600 is an Oracle bug, and only Oracle Support can help. Well, perhaps. But in this case, it must be because your DBAs have messed up.

I am a scientist, and therefore I do not believe in luck. However, I have to say "good luck. You may need it".
Re: DR Failure [message #672469 is a reply to message #672463] Tue, 16 October 2018 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.
And MOS notes:
ORA-600/ORA-7445/ORA-700 Error Look-up Tool (Doc ID 153788.1)
Master Note for Diagnosing ORA-600 (Doc ID 1092832.1)

Re: DR Failure [message #672486 is a reply to message #672463] Tue, 16 October 2018 07:52 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
As an FYI, please note that many sites block attachments. Many of us at sites that do not block them refuse to open them for the same reason others block them. You should paste directly into your posts.
Re: DR Failure [message #672489 is a reply to message #672465] Tue, 16 October 2018 08:18 Go to previous messageGo to next message
msyogi
Messages: 16
Registered: May 2016
Location: Hyderabad
Junior Member
OK thanks a lot
Re: DR Failure [message #672490 is a reply to message #672463] Tue, 16 October 2018 08:23 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:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

You posted NO actionable details.
We don't know OS name or version.
We don't know what Oracle version to 4 decimal places.
We don't know what SQL produced the error.

You have a mystery & give us no clues.
Re: DR Failure [message #672491 is a reply to message #672463] Tue, 16 October 2018 08:58 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
ALERT Description and fix for Bug 8895202: ORA-1555 / ORA-600 [ktbdchk1: bad dscn] ORA-600 [2663] in Physical Standby after switchover (Doc ID 1608167.1)
Previous Topic: Recursive query
Next Topic: Pulling hair out trying to use table function
Goto Forum:
  


Current Time: Thu Mar 28 05:39:21 CDT 2024