【ORA】ORA-19504: failed to create file +DATA/orcl/controlfile/control01

最新推荐文章于 2021-04-08 19:43:37 发布

原创

最新推荐文章于 2021-04-08 19:43:37 发布 · 3.8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#ORA-19504 #ORA-19870 #控制文件还原报错 #控制文件 #ORA-15173

在尝试创建+DATA/orcl/controlfile/control01.ctl文件时遇到ORA-19504错误。本文讨论了这个问题，并提供了控制文件还原过程中的常见错误解决方案，包括ORA-19870和ORA-15173。

ORA-19504: failed to create file "+DATA/orcl/controlfile/control01.ctl"

场景：
在单实例环境通过rman备份的控制文件，拷贝到rac下执行下面的还原语句

RMAN> restore controlfile from '/oradata/CONTROL_0BSQVKUC_1_1';

Starting restore at 2018-02-11 16:41:54
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/11/2018 16:42:01
ORA-19870: error while restoring backup piece /oradata/CONTROL_0BSQVKUC_1_1
ORA-19504: failed to create file "+DATA/orcl/controlfile/control01.ctl"
ORA-17502: ksfdcre:4 Failed to create fil