首页 > 数据库 >rac dg活动复制完成后,备库节点1查询数据库状态时报错ORA-00204、ORA-00202,且告警日志中出现ORA-15025、ORA-27041异常

rac dg活动复制完成后,备库节点1查询数据库状态时报错ORA-00204、ORA-00202,且告警日志中出现ORA-15025、ORA-27041异常

时间:2022-11-27 18:01:39浏览次数:49  
标签:mapper 00204 备库 app oracle u01 root ORA

问题描述:rac dg活动复制完成后,备库节点1查询数据库状态时报错ORA-00204、ORA-00202,且告警日志中出现ORA-15025、ORA-27041异常,如下所示:
说明:rac dg磁盘组采用的是多路径 + udev方式绑盘.
前端报错:
SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/healdg/controlfile/control01.ctl'
ORA-15081: failed to submit an I/O operation to a disk
trace日志:
Sun Nov 27 14:53:23 2022
Errors in file /u01/app/oracle/diag/rdbms/healdg/healdg1/trace/healdg1_ora_119305.trc:
ORA-15025: could not open disk "/dev/mapper/asm_data01"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/healdg/healdg1/trace/healdg1_ora_119305.trc:
ORA-15025: could not open disk "/dev/mapper/asm_data01"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 256 in group [3.2158751383] from disk DATA_0000 allocation unit 102 reason error; if possible, will try another mirror side
Errors in file /u01/app/oracle/diag/rdbms/healdg/healdg1/trace/healdg1_ora_119305.trc:
ORA-00202: control file: '+DATA/healdg/controlfile/control01.ctl'
ORA-15081: failed to submit an I/O operation to a disk
Sun Nov 27 14:56:25 2022
Errors in file /u01/app/oracle/diag/rdbms/healdg/healdg1/trace/healdg1_ora_119543.trc:
ORA-15025: could not open disk "/dev/mapper/asm_data01"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/healdg/healdg1/trace/healdg1_ora_119543.trc:
ORA-15025: could not open disk "/dev/mapper/asm_data01"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 256 in group [3.2158751383] from disk DATA_0000 allocation unit 102 reason error; if possible, will try another mirror side
Errors in file /u01/app/oracle/diag/rdbms/healdg/healdg1/trace/healdg1_ora_119543.trc:
ORA-00202: control file: '+DATA/healdg/controlfile/control01.ctl'
ORA-15081: failed to submit an I/O operation to a disk
异常原因:
报警提示很明显,缺少访问磁盘组的权限.
解决过程:
通过查询资料了解到很可能与?/bin/oracle权限有关.
查主库节点1.
[oracle@hisdb1 dbs]$ ll $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239501536 Oct 6 13:31 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
查备库节点1.
[root@hisdb3 mapper]# ll /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwsr-s--x 1 oracle oinstall 239501536 Nov 26 19:50 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
说明:备库该文件属性为oracle:oinstall,判断其为造成此异常的原因,将其修改为oracle:asmadmin.
--因此前修改过/dev/mapper/asm_data01属性为grid:asmadmin,现将其修改回来.
[root@hisdb3 mapper]# chown -R root:root /dev/mapper/asm_data01
[root@hisdb3 mapper]# ll
total 0
lrwxrwxrwx 1 root root 7 Nov 27 16:49 asm_data01 -> ../dm-4
lrwxrwxrwx 1 root root 7 Nov 27 14:53 asm_fra01 -> ../dm-3
lrwxrwxrwx 1 root root 7 Nov 26 19:44 asm_ocr01 -> ../dm-2
lrwxrwxrwx 1 root root 7 Nov 26 18:53 centos-root -> ../dm-0
lrwxrwxrwx 1 root root 7 Nov 26 18:53 centos-swap -> ../dm-1
crw------- 1 root root 10, 236 Nov 26 18:53 control
[root@hisdb3 mapper]# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@hisdb3 mapper]# ll /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwxr-x--x 1 oracle asmadmin 239501536 Nov 26 19:50 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@hisdb3 mapper]# chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@hisdb3 mapper]# ll /u01/app/oracle/product/11.2.0/db_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239501536 Nov 26 19:50 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
备库节点2:
[root@hisdb4 mapper]# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[root@hisdb4 mapper]# chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle
[oracle@hisdb3 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Nov 27 16:54:06 2022

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 855982080 bytes
Fixed Size 2258040 bytes
Variable Size 348130184 bytes
Database Buffers 499122176 bytes
Redo Buffers 6471680 bytes
SQL> alter database mount;

Database altered.

SQL> select name from v$database;

NAME
---------
HEAL

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

结论:修改文件属性后,成功查询备库状态.

标签:mapper,00204,备库,app,oracle,u01,root,ORA
From: https://blog.51cto.com/u_12991611/5890245

相关文章