这篇文章主要介绍“怎么将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=y LRM-00101: unknown parameter name 'direcotry' [oracle@sam1 ~]$ expdp system/oracle directory=databk dumpfile=all.dmp full=y Export: Release 11.2.0.3.0 - Production on Sat Feb 15 08:13:57 2020 Copyright (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 Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536 ORA-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=YES Export: Release 11.2.0.3.0 - Production on Mon Feb 24 01:22:35 2020 Copyright (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 Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** directory=databk dumpfile=all.dmp full=y NOLOGFILE=YES Estimate in progress using BLOCKS method... Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA Total estimation using BLOCKS method: 4.809 GB Processing object type DATABASE_EXPORT/TABLESPACE Processing object type DATABASE_EXPORT/PROFILE Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABASE_EXPORT/SCHEMA/USER Processing object type DATABASE_EXPORT/ROLE Processing 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 rows Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is: +DATA/backup/all.dmp Job "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.log Export: Release 11.2.0.3.0 - Production on Mon Feb 24 04:50:37 2020 Copyright (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 Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=databk dumpfile=scott.dmp schemas=scott logfile=logdump:expdp_scott.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/TABLE/TABLE 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/CONSTRAINT/REF_CONSTRAINT Processing 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 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: +DATA/backup/scott.dmp Job "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中”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注亿速云网站,小编会继续努力为大家带来更多实用的文章!
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。