怎么将Expdp备份数据转到ASM中

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

一、问题描述

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

二、实验

1.数据库建立directory

SYS@PROD1 > create directory databk as '+data/backup';Directory created..[oracle@sam1 ~]$ expdp system/oracle direcotry=databk dumpfile=all.dmp full=yLRM-00101: unknown parameter name 'direcotry'[oracle@sam1 ~]$ expdp system/oracle directory=databk dumpfile=all.dmp full=yExport: Release 11.2.0.3.0 - Production on Sat Feb 15 08:13:57 2020Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsORA-39002: invalid operationORA-39070: Unable to open the log file.ORA-29283: invalid file operationORA-06512: at "SYS.UTL_FILE", line 536ORA-29283: invalid file operation

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

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

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

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

[oracle@sam1 ~]$ expdp system/oracle directory=databk dumpfile=all.dmp full=y NOLOGFILE=YESExport: Release 11.2.0.3.0 - Production on Mon Feb 24 01:22:35 2020Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsStarting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** directory=databk dumpfile=all.dmp full=y NOLOGFILE=YESEstimate in progress using BLOCKS method...Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATATotal estimation using BLOCKS method: 4.809 GBProcessing object type DATABASE_EXPORT/TABLESPACEProcessing object type DATABASE_EXPORT/PROFILEProcessing object type DATABASE_EXPORT/SYS_USER/USERProcessing object type DATABASE_EXPORT/SCHEMA/USERProcessing object type DATABASE_EXPORT/ROLEProcessing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT….... . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES"             0 KB       0 rows. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rowsMaster table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded******************************************************************************Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:  +DATA/backup/all.dmpJob "SYSTEM"."SYS_EXPORT_FULL_01" completed with 1 error(s) at 01:25:42

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

需要建立一个放log的directory

SYS@PROD1 > create directory logdump as '/home/oracle';Directory created.[oracle@sam1 ~]$ expdp system/oracle directory=databk dumpfile=scott.dmp  schemas=scott logfile=logdump:expdp_scott.logExport: Release 11.2.0.3.0 - Production on Mon Feb 24 04:50:37 2020Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsStarting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=databk dumpfile=scott.dmp schemas=scott logfile=logdump:expdp_scott.logEstimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 320 KBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . exported "SCOTT"."DEPT"                              5.929 KB       4 rows. . exported "SCOTT"."EMP"                               8.562 KB      14 rows. . exported "SCOTT"."SALGRADE"                          5.859 KB       5 rows. . exported "SCOTT"."TABLE1"                            5.835 KB       2 rows. . exported "SCOTT"."TEST"                              5.421 KB       1 rows. . exported "SCOTT"."BONUS"                                 0 KB       0 rowsMaster table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded******************************************************************************Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:  +DATA/backup/scott.dmpJob "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 04:51:03[oracle@sam1 ~]$ ls -l expdp_scott.log-rw-r--r-- 1 oracle asmadmin 2080 Feb 24 04:51 expdp_scott.log

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