Oracle 11g 目录对象到远程路径
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/6044117/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle 11g directory objects to remote path
提问by denisb
We're in the process of migrating over a system from Oracle 10G (windows 2003 32 bit) to 11G (on windows 2008 R2 64bit), where currently, our backup process consist a directory object that points to a remote (unc) path on our storage box so that we don't have to perform the expdp locally, and then move the file, which seems to work without issue, however on our new windows 2008 box with 11G, I can create the directory object and test it through the EM console, however whenever I try to run my import, I get the following:
我们正在将系统从 Oracle 10G(Windows 2003 32 位)迁移到 11G(在 Windows 2008 R2 64 位上),目前,我们的备份过程包含一个指向远程 (unc) 路径的目录对象我们的存储盒,这样我们就不必在本地执行 expdp,然后移动文件,这似乎没有问题,但是在我们新的 11G 的 windows 2008 盒子上,我可以创建目录对象并通过EM 控制台,但是每当我尝试运行导入时,我都会得到以下信息:
Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit ProductionWith the Automatic
Storage Management option
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
Any ideas?? Just trying to test with metadata_only right now to troubleshoot this, but still no luck.
有任何想法吗??现在只是尝试使用 metadata_only 进行测试以解决此问题,但仍然没有运气。
E:\>impdp xxxxx/xxxxx@prod CONTENT=METADATA_ONLY directory=Restoreloc dumpfile=XXXXX_
MAY172011.DMP logfile=XXXXXIMPDP.log exclude=grant