Viswamitra's blog

When we do not have space in normal file system at OS level for taking the expdp backup , we can take the backup to ASM. Below is the procedure for the same.

How to take expdp backup into ASM :-

1) Create a directory in database for ASM.

ASMCMD> mkdir +DATA1/EXP_BACKUP

SQL> create directory EXP_BACKUP as ‘+DATA1/EXP_BACKUP’;

Directory created.

2) Take the export to the directory

[oracle@node1 collectl-4.0.2]$ expdp test/test tables=emp directory=EXP_BACKUP dumpfile=emp.dmp logfile=emp.log

Export: Release 11.2.0.1.0 – Production on Tue Feb 2 11:00:30 2016

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 536
ORA-29283: invalid file operation

This error occurred because the logfile is a text file and oracle can not write the text file in ASM. So we should write the logfile in a separate directory in normal file system.

[oracle@node1 collectl-4.0.2]$ expdp test/test tables=emp directory=EXP_BACKUP dumpfile=emp.dmp logfile=LOG_FILE_DIR:emp.log

Export: Release 11.2.0.1.0 – Production on Tue Feb 2 11:05:06 2016

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting “TEST”.”SYS_EXPORT_TABLE_01″:  test/******** tables=emp directory=EXP_BACKUP dumpfile=emp.dmp logfile=LOG_FILE_DIR:emp.log
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported “TEST”.”EMP”                                8.570 KB      14 rows
Master table “TEST”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for TEST.SYS_EXPORT_TABLE_01 is:
  +DATA1/exp_backup/emp.dmp
Job “TEST”.”SYS_EXPORT_TABLE_01″ successfully completed at 11:05:24