• 用NBU无法还原数据库到ASM磁盘


    描述:用NBU无法还原数据库到ASM磁盘,却可以还原到数据库本地磁盘

    错误提示:

    ORA-15025: could not open disk "/dev/mapper/DATA1"
    ORA-27041: unable to open file
    Linux-x86_64 Error: 13: Permission denied
    Additional information: 9
    ORA-15025: could not open disk "/dev/mapper/DATA3"
    ORA-27041: unable to open file
    Linux-x86_64 Error: 13: Permission denied
    Additional information: 9
    SUCCESS: diskgroup DATA was mounted
    ORA-15025: could not open disk "/dev/mapper/DATA2"
    ORA-27041: unable to open file
    Linux-x86_64 Error: 13: Permission denied
    Additional information: 9
    ORA-15025: could not open disk "/dev/mapper/DATA4"
    ORA-27041: unable to open file
    Linux-x86_64 Error: 13: Permission denied
    Additional information: 9
    SUCCESS: diskgroup FRA was mounted
    SUCCESS: diskgroup FRA was dismounted
    Errors in file /home/u01/app/oracle/diag/rdbms/middb/middb1/trace/middb1_ora_53718.trc  (incident=9929):
    ORA-00600: internal error code, arguments: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], []
    Incident details in: /home/u01/app/oracle/diag/rdbms/middb/middb1/incident/incdir_9929/middb1_ora_53718_i9929.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Tue Mar 13 23:13:16 2018
    Dumping diagnostic data in directory=[cdmp_20180313231316], requested by (instance=1, osid=53718), summary=[incident=9929].
    Errors in file /home/u01/app/oracle/diag/rdbms/middb/middb1/trace/middb1_ora_53718.trc  (incident=9930):
    ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []
    Incident details in: /home/u01/app/oracle/diag/rdbms/middb/middb1/incident/incdir_9930/middb1_ora_53718_i9930.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Dumping diagnostic data in directory=[cdmp_20180313231317], requested by (instance=1, osid=53718), summary=[incident=9930].
    ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 53718

    原因:权限问题

    在安装oracle soft之后:
    $ORACLE_HOME/bin/oracle文件属性权限为oracle:oninstall 751(-rwxr-x--x)
    在用安装ASM建库(DBCA)时:
    此文件属性会自动被修改为oracle:asmadmin6751(-rwsr-s--x)
    在PSU apply之后:
    此文件属性又被自动被修改为oracle:oinstall751(-rwxr-x--x)

    解决方法:

    hown oracle:asmadmin $ORACLE_HOME/bin/oracle

    chmod 6751 $ORACLE_HOME/bin/oracle

    参考大侠的blog:http://blog.csdn.net/tw7752/article/details/47023803

  • 相关阅读:
    建立一个能持续处理的C/S网络程序
    建立一个可以不停地接收客户端新的连接,但不能处理复杂的业务的C/S网络程序
    归并排序
    堆排序
    计数排序
    不要在PHP7中踩这些坑
    关于生活学习
    topthink/think-swoole 扩展包的使用 之 WebSocket
    PHP 三元运算符
    topthink/think-swoole 扩展包的使用 之 Task
  • 原文地址:https://www.cnblogs.com/Snowfun/p/8564167.html
Copyright © 2020-2023  润新知