Sunday, 14 December 2014

How to stop data pump jobs EXPDP


Export full DB backup :--

expdp \'/ as sysdba\' full=Y directory=TEST_DIR dumpfile=DB11G.dmp logfile=Full_DB_bkp.log compression=all 

Export: Release 11.2.0.2.0 - Production on Fri Dec 12 20:24:31 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01":  "/******** AS SYSDBA" full=Y directory=TEST_DIR dumpfile=DB11G.dmp logfile=Full_DB_bkp.log compression=all 
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 27.60 GB


Stop Export Backup from DB level:--

SQL> set lines 1000 pages 1000
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_01             EXPORT                         FULL                           EXECUTING


oracle@Test-DB$expdp \'/ as sysdba\' attach=SYS_EXPORT_FULL_01

Export: Release 11.2.0.2.0 - Production on Fri Dec 12 21:08:53 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

Job: SYS_EXPORT_FULL_01
  Owner: SYS
  Operation: EXPORT
  Creator Privs: TRUE
  GUID: 0A076075C651060DE054002128D658F4
  Start Time: Friday, 12 December, 2014 20:46:30
  Mode: FULL
  Instance: TestPRD
  Max Parallelism: 1
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        "/******** AS SYSDBA" full=Y directory=CRAMERDATA_EXP dumpfile=Full_DB_bkp.dmp logfile=Full_DB_bkp.log
  State: EXECUTING
  Bytes Processed: 22,522,186,936
  Percent Done: 98
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /orabkp/exp_backup/Full_DB_bkp.dmp
    bytes written: 22,569,902,080

Worker 1 Status:
  Process Name: DW00
  State: EXECUTING
  Object Schema: Test
  Object Name: CR_FR_RO
  Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
  Completed Objects: 313
  Total Objects: 3,100
  Worker Parallelism: 1

Export> STOP_JOB
Are you sure you wish to stop this job ([yes]/no): yes

oracle@Test-DB$

Export Check Status :--

SQL> set lines 1000 pages 1000
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_01             EXPORT                         FULL                           NOT RUNNING

SQL> exit

No comments:

Post a comment