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';
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