Pages

Saturday, March 26, 2016

Creating Datapump Files In ASM

Creating Datapump Files In  ASM

This section describes how to create DataPump export dumps within ASM diskgroups.

1.Create a directory from ASM. This step is only necessary, if you plan on storing the dumps in a specific directory

alter diskgroup flash add directory '+flash/dumpsets';

2.Create a directory in database

create directory dumps as '+flash/dumpsets';

3.Create a logfile directory, since logfiles cant be stored in ASM

create directory logfile_dest as '/u01/admin/dumps_logs';

4.expdp parfile=expdp_parfile

where expdp_parfile contents are:

userid=system/manager directory='DUMPS' dumpfile=expdp.dat job_name=full_export logfile=logfile_dest:exp.log

5.Validate that the file is created within ASM.

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

No comments:

Post a Comment