asm中创建目录
ASMCMD> pwd
+
ASMCMD> cd data
ASMCMD> pwd
+data
ASMCMD> mkdir expdptest
ASMCMD> ls -l
Type Redund Striped Time Sys Name
Y ASM/
Y CDB/
Y ORA11G/
Y _MGMTDB/
N expdptest/
PASSWORD UNPROT COARSE JUN 28 22:00:00 N orapwasm => +DATA/ASM/PASSWORD/pwdasm.256.819326571
Y lunar-cluster/
数据库创建目录
SYS% cdb1> create or replace directory lunardump as '+DATA/expdptest'; Directory created. SYS% cdb1> create table lunartest as select * from dba_users; Table created.
expdp导出数据到asm
[oracle@lunar tmp]$ expdp "'/ as sysdba'" DUMPFILE=lunar.dmp DIRECTORY=LUNARDUMP CONTENT=METADATA_ONLY logfile=DATA_PUMP_DIR:expdp01.log Export: Release 12.1.0.1.0 - Production on Fri Aug 9 01:55:15 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database. Starting "C##LUNAR"."SYS_EXPORT_SCHEMA_01": "'/ as sysdba'" DUMPFILE=lunar.dmp DIRECTORY=LUNARDUMP CONTENT=METADATA_ONLY logfile=DATA_PUMP_DIR:expdp01.log 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/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Master table "C##LUNAR"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for C##LUNAR.SYS_EXPORT_SCHEMA_01 is: +DATA/expdptest/lunar.dmp Job "C##LUNAR"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Aug 9 01:59:51 2013 elapsed 0 00:03:47
检查expdp导出文件
ASMCMD> cd expdptest ASMCMD> ls -l Type Redund Striped Time Sys Name DUMPSET UNPROT COARSE AUG 09 01:00:00 N lunar.dmp => +DATA/CDB/DUMPSET/CLUNARSYS_EXPORT_SCHEMA_01_92142_1.302.822966973
补充说明
如果有rac，可以使用cluster=y，parallel=10…………这样就在整个集群parallel，在xd就用dbfs，本质就是这个原理的
