Q
Problem solve Get help with specific problems with your technologies, process and projects.

ORA-600 error after full backup

I recently upgraded a database from 9i to 10g. My RMAN is also 10g. When I do a full backup, at the end of the backup I get an ORA-600 error.

Thanks for your great work, I find your Web site very useful.

At present I have a strange problem with RMAN. I recently upgraded a database from 9i to 10g. My RMAN is also 10g. When I do a full backup, at the end of the backup I get an ORA-600 error. However when I do the recovery drill it works fine. I am pretty confused -- any pointers?

The ORA-00600 error is a generic error telling you, "There is an error, but I do not know which error code to give you." This really is not very descriptive as it does not tell you what the real error is. Fortunately, the ORA-00600 error gives you a little more of a hint, although it is cryptic. The format of the ORA-00600 error looks similar to the following:

ORA-00600 [1234] [abcd] [] []

The first parameter in brackets tells you which location of the Oracle kernel code the error was thrown. The subsequent brackets may contain other diagnostic information.

Since you did not include at least the first parameter, I have no clue what location of the Oracle kernel is causing you problems. At this point, there are a few options. One, sign on to Metalink if you have an Oracle Support contract and type "ORA 600 1234" (substitute "1234" for the correct parameter) in the search box and see if Oracle has a resolution for this error. Second, perform the same search in Google to see if someone else has experienced the same problem. Many times, you can resolve the cryptic ORA-00600 errors just by seeing how others have solved the same problem.

If the above does not help you, then your only recourse is to open a Service Request with Oracle Support.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close