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