11.2.0.2_dataguard bug处理

1：DG数据的版本为11.2.0.2触发oracle bug不能select 系统表，

ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 21 with name
"_SYSSMU21_3288119158$" too small

2：os AIX6.1 

3：Bug 10320455: QUERY IN ACTIVE DATA GUARD RETURNS ORA-1555

which is duplicate from
Bug 10092353: ACTIVE DATAGUAD INSTANCE HANGS DUE TO A LIBRARY CACHE LOCK
HOLDER
This is resolved by applying the fix for
Internal Bug 10018789: DBMV2-BIGBH:SPIN IN KGLLOCK CAUSED DB HUNG AND HIGH
LIBRARY CACHE LOCK

4：下载10018789 的补丁，详细阅读readme文版，打上此补丁

5：查询已打上的patch

 bash-3.2$ cd /haclu/app/oracle/product/11.2.0/dbhome_1/OPatch/

bash-3.2$ pwd

/haclu/app/oracle/product/11.2.0/dbhome_1/OPatch

bash-3.2$ opatch lsinventory

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Copyright (c) 2009, Oracle Corporation.  All rights reserved.

Oracle Home       : /haclu/app/oracle/product/11.2.0/dbhome_1

Central Inventory : /haclu/app/oraInventory

   from           : /etc/oraInst.loc

OPatch version    : 11.2.0.1.1

OUI version       : 11.2.0.2.0

OUI location      : /haclu/app/oracle/product/11.2.0/dbhome_1/oui

Log file location : /haclu/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-04-28_16-06-44PM.log

Patch history file: /haclu/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /haclu/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-04-28_16-06-44PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1): 

Oracle Database 11g                                                  11.2.0.2.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  10018789     : applied on Sun Apr 28 10:48:21 CST 2013

Unique Patch ID:  15898853

   Created on 28 Jan 2013, 22:51:21 hrs PST8PDT

   Bugs fixed:

     10018789

--------------------------------------------------------------------------------

OPatch succeeded.

补丁安装成功；

6：启动数据：

starup

出现ORA-600错误，检查alert.log

---------------------------------------------------------------------------------------------------------

Sun Apr 28 11:00:57 2013

ALTER DATABASE   MOUNT

Sun Apr 28 11:00:57 2013

ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.4.136)(PORT=1521)))

)' SCOPE=MEMORY SID='qlbackupdg';

NOTE: Loaded library: System 

ORA-15025: ?????? "/dev/rhdisk10"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk11"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk12"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk13"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk14"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk15"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk16"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk17"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk18"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk19"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk20"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk21"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk22"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk23"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk24"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk25"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

ORA-15025: ?????? "/dev/rhdisk9"

ORA-27041: ??????

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 11

SUCCESS: diskgroup DATA was mounted

Errors in file /haclu/app/oracle/diag/rdbms/qlbackupdg/qlbackupdg/trace/qlbackupdg_ckpt_3407940.trc  (incident=1273

05):

ORA-00600: ??????, ??: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], []

Incident details in: /haclu/app/oracle/diag/rdbms/qlbackupdg/qlbackupdg/incident/incdir_127305/qlbackupdg_ckpt_3407

940_i127305.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

NOTE: dependency between database qlbackupdg and diskgroup resource ora.DATA.dg is established

Sun Apr 28 11:01:00 2013

Sweep [inc][115305]: completed

Sweep [inc2][115305]: completed

Dumping diagnostic data in directory=[cdmp_20130428110102], requested by (instance=1, sid=3407940 (CKPT)), summary

=[incident=127305].

ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 3407940 

Sun Apr 28 11:01:06 2013

PMON (ospid: 3342418): terminating the instance due to error 469

Sun Apr 28 11:01:07 2013

System state dump requested by (instance=1, sid=3342418 (PMON)), summary=[abnormal instance termination].

System State dumped to trace file /haclu/app/oracle/diag/rdbms/qlbackupdg/qlbackupdg/trace/qlbackupdg_diag_2097770.

trc

Dumping diagnostic data in directory=[cdmp_20130428110107], requested by (instance=1, sid=3342418 (PMON)), summary

=[abnormal instance termination].

---------------------------------------------------------------------------------------------------------

根据检查结果，貌似是磁盘组权限出现问题，经检查磁盘和磁盘组正常，

检查oracle_home/bin下的oracle执行权限，发现oracle文件的执行权限出现变化，修改成为了oracle:oinstall .  

chown  oracle:asmadmin oracle 

重新启动数据库

OK!

故障解决；

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14507784/viewspace-759489/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14507784/viewspace-759489/