Hi,
Oracle version : 10.2.0.1
Operating system:Linux
I create an crontab to take the backup for one of my schema.When i saw the log file i get the below errors .What might be the problem
;;;
Export: Release 10.2.0.1.0 - Production on Wednesday, 23 December, 2009 0:00:05
Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Starting "CAPTURE_PROD"."CAPTURE_PRD": capture_prod/******** directory=dbdump dumpfile=capture_prod_2009-12-23.dmp EXCLUDE=STATISTICS,grant logfile=capture_prod_2009-12-23.log job_name=capture_prd
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 977.6 MB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
. . exported "CAPTURE_PROD"."HR_TIMEIN" 9.216 MB 178744 rows
. . exported "CAPTURE_PROD"."HR_TIMEIN24110154" 8.700 MB 168577 rows
ORA-31693: Table data object "CAPTURE_PROD"."HR_TIMEIN_SUMMARY" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01115: IO error reading block from file 18 (block # 106576)
ORA-27072: File I/O error
Additional information: 4
Additional information: 106576
Additional information: 16384
ORA-01115: IO error reading block from file 18 (block # 106576)
ORA-27072: File I/O error
Additional information: 4
Additional information: 106576
Additional informati
ORA-31693: Table data object "CAPTURE_PROD"."HR_TIMEIN_TRANSACTIONS" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26061: Concurrent direct unloads is not allowed.
. . exported "CAPTURE_PROD"."HR_TIMEIN2" 5.034 MB 97030 rows
. . exported "CAPTURE_PROD"."HR_USER_LOGINTRACK" 4.920 MB 151727 rows
. . exported "CAPTURE_PROD"."IR_MASTER" 3.910 MB 17245 rows
. . exported "CAPTURE_PROD"."DM_FORWARD" 3.137 MB 164305 rows
. . exported "CAPTURE_PROD"."HR_TIMEIN_BKUP" 2.320 MB 53105 rows
here is my alert.log file contents.
Wed Dec 23 00:00:07 2009
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=44, OS id=31540
to execute - SYS.KUPM$MCP.MAIN('CAPTURE_PRD', 'CAPTURE_PROD', 'KUPC$C_1_20091223000008', 'KUPC$S_1_20091223000008', 0);
kupprdp: worker process DW01 started with worker id=1, pid=46, OS id=31560
to execute - SYS.KUPW$WORKER.MAIN('CAPTURE_PRD', 'CAPTURE_PROD');
Wed Dec 23 00:01:33 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 5616K exceeds notification threshold (2048K)
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NU
Wed Dec 23 00:01:33 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 5612K exceeds notification threshold (2048K)
Details in trace file /u01/app/oracle/admin/capture/bdump/capture_dw01_31560.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NU
Wed Dec 23 00:11:15 2009
Errors in file /u01/app/oracle/admin/capture/bdump/capture_dw01_31560.trc:
ORA-00600: internal error code, arguments: [kluucls_10], [], [], [], [], [], [], []
Wed Dec 23 00:12:22 2009
Errors in file /u01/app/oracle/admin/capture/bdump/capture_dw01_31560.trc:
ORA-00600: internal error code, arguments: [729], [548812], [space leak], [], [], [], [], []
Wed Dec 23 01:05:06 2009
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=38, OS id=2427
to execute - SYS.KUPM$MCP.MAIN('CAP09_1', 'CAP09', 'KUPC$C_1_20091223010507', 'KUPC$S_1_20091223010507', 0);
kupprdp: worker process DW01 started with worker id=1, pid=46, OS id=2435
to execute - SYS.KUPW$WORKER.MAIN('CAP09_1', 'CAP09');
Wed Dec 23 01:06:19 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 5616K exceeds notification threshold (2048K)
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NU
Wed Dec 23 01:06:19 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 5612K exceeds notification threshold (2048K)
Details in trace file /u01/app/oracle/admin/capture/bdump/capture_dw01_2435.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NU
Wed Dec 23 04:55:17 2009
Thread 1 advanced to log sequence 1663
Current log# 3 seq# 1663 mem# 0: /u02/app/oracle/oradata/capture/redo03.log
Wed Dec 23 06:00:00 2009
Unable to restore resource manager plan to '':
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager
Wed Dec 23 08:50:01 2009
Please help me
Thanks & Regards,
Poorna Prasad.
Edited by: SIDDABATHUNI on Dec 22, 2009 11:23 PM