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

Directory created.


4) execute expdp to export data
Expdp userid = system/storage01 directory = 'dumpsets 'dumpfile = expdp_5_5.dat job_name = full_export logfile = logfile_dest: exp5_5.log

Export: Release 11.1.0.6.0-production on Wednesday, 07 May, 2008 10:22:57

Copyright (c) 2003,200 7, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-Production
With the partitioning, OLAP, data mining and real application testing options
Starting "system". "full_export": userid = system/********* directory = dumpsets dumpfile = expdp_5_5.dat job_name = full_export logfile = logfile_dest: exp5_5.log
Estimate in progress using blocks method...
Processing object type schema_export/table/table_data
Total estimation using blocks method: 320 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/synonym/Synonym
Processing object type schema_export/type/type_spec
.
.
.
Processing object type schema_export/table/constraint/ref_constraint
Processing object type schema_export/table/trigger
Processing object type schema_export/table/statistics/table_statistics
Processing object type schema_export/table/post_table_action
Processing object type schema_export/post_schema/procact_schema
.. Exported "system". "repcat $ _ audit_attribute" 6.398 KB 2 rows
.. Exported "system". "repcat $ _ object_types" 6.882 kb 28 rows
.. Exported "system". "repcat $ _ resolution_method" 5.875 kb 19 rows
.. Exported "system". "repcat $ _ template_status" 5.484 KB 3 rows
.. Exported "system". "repcat $ _ template_types" 6.289 KB 2 rows
.. Exported "system". "def $ _ aqcall" 0 kb 0 rows
.. Exported "system". "def $ _ aqerror" 0 kb 0 rows
.
.
.
.. Exported "system". "repcat $ _ site_objects" 0 kb 0 rows
.. Exported "system". "repcat $ _ snapgroup" 0 kb 0 rows
.. Exported "system". "repcat $ _ template_objects" 0 kb 0 rows
.. Exported "system". "repcat $ _ template_parms" 0 kb 0 rows
.. Exported "system". "repcat $ _ template_refgroups" 0 kb 0 rows
.. Exported "system". "repcat $ _ template_sites" 0 kb 0 rows
.. Exported "system". "repcat $ _ template_targets" 0 kb 0 rows
.. Exported "system". "repcat $ _ user_authorizations" 0 kb 0 rows
.. Exported "system". "repcat $ _ user_parm_values" 0 kb 0 rows
.. Exported "system". "sqlplus_product_profile" 0 kb 0 rows
Master table "system". "full_export" successfully Loaded/unloaded
**************************************** **************************************
Dump File set for system. full_export is:
+ Fra/dumpsets/expdp_5_5.dat


5) The DMP file is created under + fra/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

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.