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

Wednesday 10 December 2014

Enable or Disable Hibernate in Windows



To Enable Hibernate

NOTE: This step will restore the hiberfil.sys file, and the Allow hybrid sleep and Hibernate after Power Options under Sleep.
You Need Administrator access for run below command 

In the command prompt,Run below, and press Enter. & check START butten

powercfg -h on 

To Disable Hibernate

NOTE: This step will disable hibernation, delete the hiberfil.sys file, and remove the Allow hybrid sleep and Hibernate after Power Options under Sleep..

In the command prompt, Run below, and press Enter. & check START butten

powercfg -h off