这篇文章主要介绍“怎么将Expdp备份数据转到ASM中”，在日常操作中，相信很多人在怎么将Expdp备份数据转到ASM中问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”怎么将Expdp备份数据转到ASM中”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

一、问题描述

需求要使用expdp备份数据，检查系统空间很小，不够放备份文件。直接给系统加空间不就得了，可是这样一来就要耽误时间，还要联系一大堆人员。此时ASM空间是很充足的，可不可以使用呢。接着就有以下的操作了。

二、实验

1.数据库建立directory

SYS@PROD1>createdirectorydatabkas'+data/backup';Directorycreated..[oracle@sam1~]$expdpsystem/oracledirecotry=databkdumpfile=all.dmpfull=yLRM-00101:unknownparametername'direcotry'[oracle@sam1~]$expdpsystem/oracledirectory=databkdumpfile=all.dmpfull=yExport:Release11.2.0.3.0-ProductiononSatFeb1508:13:572020Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsORA-39002:invalidoperationORA-39070:Unabletoopenthelogfile.ORA-29283:invalidfileoperationORA-06512:at"SYS.UTL_FILE",line536ORA-29283:invalidfileoperation

此时会有以上报错，原因是日志无法写入ASM当中导致。可以以下两种方式解决：

A.使用NOLOGFILE=YES选项禁用日志。

B.将日志指定到系统的目录。

2.测试NOLOGFILE=YES 成功完成备份

[oracle@sam1~]$expdpsystem/oracledirectory=databkdumpfile=all.dmpfull=yNOLOGFILE=YESExport:Release11.2.0.3.0-ProductiononMonFeb2401:22:352020Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsStarting"SYSTEM"."SYS_EXPORT_FULL_01":system/********directory=databkdumpfile=all.dmpfull=yNOLOGFILE=YESEstimateinprogressusingBLOCKSmethod...ProcessingobjecttypeDATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATATotalestimationusingBLOCKSmethod:4.809GBProcessingobjecttypeDATABASE_EXPORT/TABLESPACEProcessingobjecttypeDATABASE_EXPORT/PROFILEProcessingobjecttypeDATABASE_EXPORT/SYS_USER/USERProcessingobjecttypeDATABASE_EXPORT/SCHEMA/USERProcessingobjecttypeDATABASE_EXPORT/ROLEProcessingobjecttypeDATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT….....exported"SYSTEM"."REPCAT$_USER_PARM_VALUES"0KB0rows..exported"SYSTEM"."SQLPLUS_PRODUCT_PROFILE"0KB0rowsMastertable"SYSTEM"."SYS_EXPORT_FULL_01"successfullyloaded/unloaded******************************************************************************DumpfilesetforSYSTEM.SYS_EXPORT_FULL_01is:+DATA/backup/all.dmpJob"SYSTEM"."SYS_EXPORT_FULL_01"completedwith1error(s)at01:25:42

3.测试将log写到其他位置成功完成备份

需要建立一个放log的directory

SYS@PROD1>createdirectorylogdumpas'/home/oracle';Directorycreated.[oracle@sam1~]$expdpsystem/oracledirectory=databkdumpfile=scott.dmpschemas=scottlogfile=logdump:expdp_scott.logExport:Release11.2.0.3.0-ProductiononMonFeb2404:50:372020Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsStarting"SYSTEM"."SYS_EXPORT_SCHEMA_01":system/********directory=databkdumpfile=scott.dmpschemas=scottlogfile=logdump:expdp_scott.logEstimateinprogressusingBLOCKSmethod...ProcessingobjecttypeSCHEMA_EXPORT/TABLE/TABLE_DATATotalestimationusingBLOCKSmethod:320KBProcessingobjecttypeSCHEMA_EXPORT/USERProcessingobjecttypeSCHEMA_EXPORT/SYSTEM_GRANTProcessingobjecttypeSCHEMA_EXPORT/ROLE_GRANTProcessingobjecttypeSCHEMA_EXPORT/DEFAULT_ROLEProcessingobjecttypeSCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessingobjecttypeSCHEMA_EXPORT/TABLE/TABLEProcessingobjecttypeSCHEMA_EXPORT/TABLE/INDEX/INDEXProcessingobjecttypeSCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessingobjecttypeSCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessingobjecttypeSCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessingobjecttypeSCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS..exported"SCOTT"."DEPT"5.929KB4rows..exported"SCOTT"."EMP"8.562KB14rows..exported"SCOTT"."SALGRADE"5.859KB5rows..exported"SCOTT"."TABLE1"5.835KB2rows..exported"SCOTT"."TEST"5.421KB1rows..exported"SCOTT"."BONUS"0KB0rowsMastertable"SYSTEM"."SYS_EXPORT_SCHEMA_01"successfullyloaded/unloaded******************************************************************************DumpfilesetforSYSTEM.SYS_EXPORT_SCHEMA_01is:+DATA/backup/scott.dmpJob"SYSTEM"."SYS_EXPORT_SCHEMA_01"successfullycompletedat04:51:03[oracle@sam1~]$ls-lexpdp_scott.log-rw-r--r--1oracleasmadmin2080Feb2404:51expdp_scott.log

到此，关于“怎么将Expdp备份数据转到ASM中”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！