“ORA-08103: object no longer exists” durante EXPDP

[msantinoParticipante]

gazioli, valeu pela resposta. Só consegui testar hoje, e o comportamento é exatamente o mesmo:

O DUMP começa a executar, ele faz o levantamento de todos os objetos, começa a exportar os dados e ai trava. Fica no mesmo status eternamente.

Por exemplo, pelo client do expdp, esse é o status que fica:

Export> status

Job: SYS_EXPORT_FULL_01
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 17,690,383,176
Percent Done: 99
Current Parallelism: 10
Job Error Count: 0
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_%u.dmp
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_01.dmp
bytes written: 1,967,927,296
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_02.dmp
bytes written: 1,960,329,216
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_03.dmp
bytes written: 1,918,627,840
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_04.dmp
bytes written: 1,946,865,664
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_05.dmp
bytes written: 2,185,584,640
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_06.dmp
bytes written: 1,945,800,704
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_07.dmp
bytes written: 2,165,612,544
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_08.dmp
bytes written: 1,892,950,016
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_09.dmp
bytes written: 1,866,018,816
Dump File: /u03/backup/dump/prod1/expdp_prod1_2012-08-27_144917_10.dmp
bytes written: 4,096

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: RAFAELMW
Object Type: DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Completed Objects: 720
Worker Parallelism: 1

Worker 2 Status:
Process Name: DW01
State: WORK WAITING

Worker 3 Status:
Process Name: DW02
State: WORK WAITING

Worker 4 Status:
Process Name: DW03
State: EXECUTING
Object Schema: ORDDATA
Object Name: ORDDCM_CT_PRED_OPRD
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 2,760
Total Objects: 540,473
Worker Parallelism: 1

Worker 5 Status:
Process Name: DW04
State: WORK WAITING

Worker 6 Status:
Process Name: DW05
State: WORK WAITING

Worker 7 Status:
Process Name: DW06
State: WORK WAITING

Worker 8 Status:
Process Name: DW07
State: WORK WAITING

Worker 9 Status:
Process Name: DW08
State: EXECUTING
Object Schema: SYSMAN
Object Name: MGMT_TASK_QTABLE
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 2,716
Total Objects: 540,473
Worker Parallelism: 1

Worker 10 Status:
Process Name: DW09
State: WORK WAITING

Coloquei em anexo o resultado da query, porque ficou mal formatado quando colei aqui. Ele não passa de 58,95% de progresso e nos WAITS, ele só aumenta o tempo, não sai mais disso…

Obs: Esse DUMP está sendo feito com parallel=10 mas eu já experimentei tirar o parallel e ficou exatamente o mesmo comportamento.

Segue o comando executado:

expdp datapump/******** FULL=Y directory=DUMP dumpfile=expdp_prod1_2012-08-27_144917_%U.dmp logfile=expdp_prod1_2012-08-27_144917.log PARALLEL=10 exclude=SCHEMA:"in('SYSTEM','SYSAUX','OUTLN','ANONYMOUS','OLAPSYS','MDDATA','MGMT_VIEW','SCOTT','DATAPUMP')",STATISTICS METRICS=y

Já experimentei tirar também o EXCLUDE, deixar ele limpinho, somente o dump full e nada!