搭建Dataguard,使用RMAN还原数据时无法连接ASM实例

前端之家收集整理的这篇文章主要介绍了搭建Dataguard,使用RMAN还原数据时无法连接ASM实例前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

报错如下:

RMAN> restore standby controlfile from '/tmp/rman_backup/standby_0dss6ds7_1_1.ctl';


Starting restore at 2018/02/26 14:18:35

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=21 device type=DISK


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/26/2018 14:18:36

ORA-19870: error while restoring backup piece /tmp/rman_backup/standby_0dss6ds7_1_1.ctl

ORA-19504: Failed to create file "+DATA_VG/bbdg/controlfile/cont.ctl"

ORA-17502: ksfdcre:3 Failed to create file +DATA_VG/bbdg/controlfile/cont.ctl

ORA-15001: diskgroup "DATA_VG" does not exist or is not mounted

ORA-15055: unable to connect to ASM instance

ORA-15055: unable to connect to ASM instance

ORA-27300: OS system dependent operation:open Failed with status: 13


原因:没有创建数据库,/u01/app/oracle/product/11.2.0/db_1/bin/oracle权限不对


处理方法(root用户):

chown oracle.asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle

chmod 6555 /u01/app/oracle/product/11.2.0/db_1/bin/oracle


权限和所属组如下:

-r-sr-sr-x 1 oracle asmadmin 239626683 Feb 28 14:24 /u01/app/oracle/product/11.2.0/db_1/bin/oracle


参考博文:

http://www.jb51.cc/article/p-suuotisp-yb.html

http://www.itpub.net/thread-2053471-1-1.html

原文链接:https://www.f2er.com/oracle/206392.html

猜你在找的Oracle相关文章