Archive

Archive for September, 2011

Restart import Job

September 1, 2011 Leave a comment

1. Attach the import job

[oracle@vmrac1 oracle]$ impdp system/oracle attach=SYS_IMPORT_SCHEMA_05

Import: Release 11.1.0.7.0 – 64bit Production on Thursday, 01 September, 2011 15:55:16

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Release 11.1.0.7.0 – 64bit Production
With the Real Application Clusters option

Job: SYS_IMPORT_SCHEMA_05
Owner: SYSTEM
Operation: IMPORT
Creator Privs: TRUE
GUID: ABCB8691568FDB9EE040030A5ADF367F
Start Time: Thursday, 01 September, 2011 15:55:27
Mode: SCHEMA
Instance: vstbdev1
Max Parallelism: 1
EXPORT Job Parameters:
CLIENT_COMMAND        system/******** DIRECTORY=expdp_dir DUMPFILE=POC_data.DMP FULL=y LOGFILE=expfull.log version=11.1.0
IMPORT Job Parameters:
Parameter Name      Parameter Value:
CLIENT_COMMAND        system/******** parfile=imp.par
TABLE_EXISTS_ACTION   REPLACE
State: IDLING           <– The job is idle       
Bytes Processed: 1,765,419,680
Percent Done: 99
Current Parallelism: 1
Job Error Count: 0
Dump File: /bkup/oracle/POC_DATA.DMP

Worker 1 Status:
Process Name: DW01
State: UNDEFINED
Object Schema: NE
Object Name: R424_SDE_ROWID_UK
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Completed Objects: 1,224
Worker Parallelism: 1

2. Restart the job
Import> start_job

Import> status

Job: SYS_IMPORT_SCHEMA_05
Operation: IMPORT
Mode: SCHEMA
State: EXECUTING    <– The job is running     
Bytes Processed: 1,765,419,680
Percent Done: 99
Current Parallelism: 1
Job Error Count: 0
Dump File: /bkup/oracle/POC_DATA.DMP

Worker 1 Status:
Process Name: DW01
State: EXECUTING

Import>

Categories: impdp