ORA-00600: internal error code, arguments: [kpotcgah-9]

                                                    

Yesterday I have faced again issue on EXPDP. EXPDP and IMPDP is the mythJ. 

I have scheduled the expdp backup for one of the production database on cronjob.

So everyday it’s taking full database backup and keep last 3 days backup on database server.

I have one database changes. For safer side, application team raised a request to take the database backup.

I have disabled the routine expdp cronjob and executed the expdp job script manually.

While running the expdp script, we getting the below and expdp was failed.

Error Details:

ORA-31693: Table data object "RIAP1DBO"."CX_ADVSR_TRADE" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLECLOSE callout

ORA-31643: unable to close dump file "/export/backup/test/exp_test1_full_01_20110818.dmp"

ORA-19510: failed to set size of 419192 blocks for file "/export/backup/test/exp_test1_full_01_20110818.dmp" (block size=4096)

ORA-27037: unable to obtain file status

SVR4 Error: 13: Permission denied

Additional information: 9

Note: we have enough spaces on file system.

I have tried few times to take the backup & it’s failed. 

Also we got the ORA-00600 error, skipped one table and took the remaining table’s backup.

ORA-00600 Error:

ORA-31693: Table data object "testschema"."testtable" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-00600: internal error code, arguments: [kpotcgah-9], [0], [ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []

], [], [], [], [], [], [], [], [], []

 I have checked the oracle support notes and got below notes.

Bug 8544008 OERI [kpotcgah-9] using datapump export

Versions confirmed as being affected: 10.2.0.4 and 11.1.0.7 and issue fixed on 11.2.0.2

 Workaround

Already I have faced the same issue on another environment.

http://dbarajabaskar.blogspot.com/2010/12/ora-29913-error-in-executing.html

To reducing the PARALLEL value in parfile. I have reduced the parallel 4 to 2 and ran the expdp backup through cronjob.  Now expdp is running fine and didn’t get any error.

Impact:   Expdp backup took more time to completed full database backup.

I Hope this article helped to you. I am expecting your suggestions/feedback.

Best Regards
Rajabaskar Thangaraj