加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

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

发布时间:2020-12-12 14:04:08 所属栏目:百科 来源:网络整理
导读:报错如下: 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_

报错如下:

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.52php.cn/article/p-suuotisp-yb.html

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

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读