#数据库备份
expdp 'cosem/"Q1w2e3#"'@localhost:1521/zsny dumpfile=43zsny211022.dmp full=y
#数据库还原
[oracle@CentosDB ~]$ impdp 'cosem/"Q1w2e3#"'@localhost:1521/orcl dumpfile=43zsny211022.dmp LOGFILE=43zsny211022.log full = y table_exists_action=replace;
Import: Release 11.2.0.1.0 - Production on Fri Oct 22 11:23:05 2021
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/u01/app/oracle/admin/orcl/dpdump/43zsny211022.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
#复制备份文件到指定目录
[oracle@CentosDB ~]$ mv /u01/app/oracle/admin/zsny/dpdump/43zsny211022.dmp /u01/app/oracle/admin/orcl/dpdump/43zsny211022.dmp
#再次执行数据库还原
[oracle@CentosDB ~]$ impdp 'cosem/"Q1w2e3#"'@localhost:1521/orcl dumpfile=43zsny211022.dmp LOGFILE=43zsny211022.log full = y table_exists_action=replace;
oracle数据库备份和还原
最新推荐文章于 2024-04-29 03:42:10 发布