Prováděl jsem export dat a konzultant mi pod rukama zastavil databázi. Jelikož export běžel již 6h, nechtěl jsem ho spouštět znovu.
Tady je příklad, jak navázat na již jednou spuštěný job.
V logu se mi objevilo:
UDE-01089: operation generated ORACLE error 1089 ORA-01089: immediate shutdown in progress - no operations are permitted ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551 ORA-06512: at line 1 Process ID: 8366 Session ID: 138 Serial number: 315
Kontrola:
SQL> SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;
OWNER_NAME JOB_NAME ------------------------------ ------------------------------ OPERATION -------------------------------------------------------------------------------- JOB_MODE -------------------------------------------------------------------------------- STATE ------------------------------ SYS SYS_EXPORT_FULL_02 EXPORT FULL NOT RUNNING
[18:01:23 DBSERVER~] $ expdp ATTACH=SYS_EXPORT_FULL_02
Export: Release 11.2.0.3.0 - Production on Tue Dec 2 18:02:49 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Job: SYS_EXPORT_FULL_02
Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: 093AF49EF48A20AEE053830E0A0A4C95
Start Time: Tuesday, 02 December, 2014 18:03:03
Mode: FULL
Instance: ORCL
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND "/******** AS SYSDBA" full=y directory=DATA_PUMP_DIR dumpfile=ORCL_full.dmp logfile=ORCL_full.log
State: IDLING
Bytes Processed: 224,539,989,864
Percent Done: 86
Current Parallelism: 1
Job Error Count: 0
Dump File: /TEMP-HDD/export/ORCL_full.dmp
bytes written: 224,712,806,400
Worker 1 Status:
Process Name: DW00
State: UNDEFINED
Object Schema: CRPDTA
Object Name: F4072TEM
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 108
Total Objects: 20,001
Worker Parallelism: 1
Export> continue_client
Job SYS_EXPORT_FULL_02 has been reopened at Tuesday, 02 December, 2014 18:03
Restarting "SYS"."SYS_EXPORT_FULL_02": "/******** AS SYSDBA" full=y directory=DATA_PUMP_DIR dumpfile=ORCL_full.dmp logfile=ORCL_full.log
...
Logfile ORA-39097: Data Pump job encountered unexpected error -1089 ORA-39065: unexpected master process exception in MAIN ORA-01089: immediate shutdown in progress - no operations are permitted Job SYS_EXPORT_FULL_02 has been reopened at Tuesday, 02 December, 2014 18:03 Restarting "SYS"."SYS_EXPORT_FULL_02": "/******** AS SYSDBA" full=y directory=DATA_PUMP_DIR dumpfile=ORCL_full.dmp logfile=ORCL_full.log ..
Export navázal na předešlý:
Creator Privs: TRUE GUID: 093AF49EF48A20AEE053830E0A0A4C95 Start Time: Tuesday, 02 December, 2014 18:03:03 Mode: FULL Instance: ORCL Max Parallelism: 1 EXPORT Job Parameters: Parameter Name Parameter Value: CLIENT_COMMAND "/******** AS SYSDBA" full=y directory=DATA_PUMP_DIR dumpfile=ORCL_full.dmp logfile=ORCL_full.log State: EXECUTING Bytes Processed: 227,401,792,608 Percent Done: 80 Current Parallelism: 1 Job Error Count: 0 Dump File: /TEMP-HDD/export/ORCL_full.dmp bytes written: 227,574,648,832
Worker 1 Status: Process Name: DW00 State: EXECUTING Object Schema: TESTDTA Object Name: F01133 Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA Completed Objects: 18 Total Objects: 20,001 Worker Parallelism: 1