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  [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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading