In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly introduces "how to transfer Expdp backup data to ASM". In daily operation, I believe many people have doubts about how to transfer Expdp backup data to ASM. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to transfer Expdp backup data to ASM". Next, please follow the editor to study!
I. description of the problem
Need to use expdp to back up data, check that the system space is very small, there is not enough backup files. Just add space to the system, but it will waste time and contact a lot of people. At this time, the ASM space is very sufficient, whether it can be used. Then there is the following operation.
2. Experiment
1. Database establishment 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
The above error will be reported at this time because the log cannot be written to the ASM. It can be solved in two ways:
a. Use the NOLOGFILE=YES option to disable logging.
b. Specify the log to the system's directory.
two。 Test NOLOGFILE=YES successfully completed backup
[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. Test to write log to another location to successfully complete the backup
You need to set up a directory for log.
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 The study on "how to transfer Expdp backup data to ASM" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.