expdp statement in resumable session ‘SYSTEM.SYS_IMPORT_FULL_01.1’ was suspended

EXPDP / IMPDP is used to take the logical backup of the database.

During execution of IMPDP, we received the following error due to not having enough space on tablespace and may be another reasons.

statement in resumable session ‘SYSTEM.SYS_IMPORT_FULL_01.1’ was suspended

For continue without restart the complete process. We follows following steps:

1. Connect with the instance with sys user:

sqlplus sys as sysdba

&nbps;
2. Find the job name from the dba_datapump_jobs view

select * from dba_datapump_jobs;

 
3. Check the reason of the job failure in alert log file.

Note : space issue then add more datafiles for import data.

4. For restart the job execution which is in executing state.you need to take a new session of expdp and attach the job

impdp  username/password@database attach=<job_name>

 

3. Resume the  session with following command

impdp> Client_continue

 

4. Check alert log it will show that session is resumed.

statement in resumable session ‘SYSTEM.SYS_IMPORT_FULL_01.1’ was resumed

5. Take another session and attach the same job and fired status command to check the status of expdp job

impdp username/password@database attach=<job_name>

impdp> status
It will show you the status of impdp jop

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s