expdp导出数据到asm中

联系:QQ(5163721)

标题:expdp导出数据到asm中

作者:Lunar©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]

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,本质就是这个原理的

此条目发表在 ASM 分类目录,贴了 , , 标签。将固定链接加入收藏夹。

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

您可以使用这些 HTML 标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>