[Translated from MOS] place the DMP file of expdp from the ASM disk to the local file system.
Source: Internet
Author: User
Place the DMP file of expdp from the ASM disk to the local file system.
Reference Original:
How to extract DataPump file from ASM diskgroup to local filesystem? (Docid 566941.1)
Applicable:
Oracle Database-Enterprise Edition-version 11.1.0.6 to 11.1.0.7 [release 11.1]
Information in this document applies to any platform.
Information in this document applies to any platform.
Objectives:
Starting from 11.1.0.6, asmcmd provides the CP command, which is similar to the CP command on the OS.
You can use the asmcmd CP command to copy all files in the ASM disk group.
Solution:
Example:
1) create a directory in the ASM instance
SQL> show parameter instance_name
Name type value
-----------------------------------------------------------------------------
Instance_name string + ASM
SQL> alter diskgroup FRA add directory '+ fra/dumpsets ';
Diskgroup altered.
2) create a directory in the database instance to store DMP files
SQL> show parameter instance_name
Name type value
-----------------------------------------------------------------------------
Instance_name string db11g
SQL> create directory dumpsets as '+ fra/dumpsets ';
Directory created.
3) create a directory on the OS and create a directory in the database instance for this OS directory. This OS directory is used to store exported logfiles.
SQL>! Mkdir/home/Oracle/dumpsets
SQL>! Ls-LD/home/Oracle/dumpsets
Drwxr-XR-x 2 Oracle oinstall 4096 May 7/home/Oracle/dumpsets
SQL> create directory logfile_dest as '/home/Oracle/dumpsets ';
Asmcmd> ls-L + fra/dumpsets/expdp_5_5.dat
Type redund striped time sys name
N expdp_5_5.dat => + fra/db11g/dumpset/systemfull_export_71029_1.303.654085391
6) copy the DMP file from the ASM disk group to the OS directory.
Asmcmd> pwd
+ Fra/dumpsets
Asmcmd> ls
Expdp_5_5.dat
Asmcmd> CP expdp_5_5.dat/home/Oracle/dumpsets/expdp_5_5.dat
Source + fra/dumpsets/expdp_5_5.dat
Target/home/Oracle/dumpsets/expdp_5_5.dat
Copying file (s )...
File,/home/Oracle/dumpsets/expdp_5_5.dat, copy committed.
Asmcmd> exit
$> Ls-L/home/Oracle/dumpsets/expdp_5_5.dat
-RW-r ----- 1 Oracle oinstall 2289664 May 7 11: 05/home/Oracle/dumpsets/expdp_5_5.dat
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.