DATAPUMP Dumpfiles in ASM Diskgroup

Hi Guys,

Can I store Datapump dumpfile in asm diskgroup?. Yes you can. Now we can see How do we create directory and store dumpfile.

Step 1: Go To ASM Instance and Create New Directory.

[grid@oracle11 ~]$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar 23 12:51:56 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: /as sysasm

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> alter diskgroup DATA1 add directory '+DATA1/dpdump';

Step 2:  Go to DB Instance

 Create Directory for dumpfile.

SQL>create or replace directory DPS as '+DATA1/dpdump';

SQL>grant read,write on directory DPS to system;

SQL>create or replace directory LOGS as '/u01/app/oracle';

SQL> grant read,write on directory  LOGS to system;

step3:  Doing Export using datapump

$expdp system/xxxxxx directory=DPS dumpfile=testasm.dmp schemas=scott logfile=LOGS:testasm.log

Export: Release 11.2.0.2.0 - Production on Tuesday, 22 February, 2015 15:35:00

Connected to: Oracle Database 10g Enterprise Edition Release 11.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=DPS dump

file=testasm.dmp schemas=scott logfile=LOGS:testasm.log

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 192 KB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported "SCOTT"."DEPT"                              5.656 KB       4 rows

. . exported "SCOTT"."EMP"                               7.820 KB      14 rows

. . exported "SCOTT"."SALGRADE"                          5.585 KB       5 rows

. . exported "SCOTT"."BONUS"                                 0 KB       0 rows

Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:

  +DATA1/dpdump/testasm.dmp

Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 15:36:01

SQL>

Step 4: Go to ASM Instance and Check the file created in ASM

SQL> select file_number,creation_date,bytes from v$asm_file where type='DPS';

FILE_NUMBER CREATION_      BYTES

---------- --------- ----------

        283 22-FEB-11     212992

SQL>

Any doubt please contact enquiry@amktechs.com or www.amktechs.com