Ajuda…Desafio aos colegas

[ramasineParticipante]

Olá todos,

Tenho uma máquina solari 10, com oracle 11.2.0.2

Ja há pelo menos 3 dias ela aborta o backup e faz shutdown a instância com o seguinte erro: (Suspeitamos de problemas de IO no storage)!!

ORA-12751: cpu time or run time policy violation
Tue Mar 20 10:16:12 2012
WARNING: aiowait timed out 1 times
Tue Mar 20 10:16:45 2012
WARNING: aiowait timed out 1 times
Tue Mar 20 10:17:12 2012
WARNING: aiowait timed out 1 times
Tue Mar 20 10:17:13 2012
WARNING: aiowait timed out 1 times
Tue Mar 20 10:17:14 2012
WARNING: aiowait timed out 1 times
Tue Mar 20 10:18:43 2012
Archived Log entry 974 added for thread 1 sequence 1453 ID 0x4759ed78 dest 1:
Tue Mar 20 10:29:51 2012
minact-scn: useg scan erroring out with error e:12751
Tue Mar 20 10:37:52 2012
minact-scn: useg scan erroring out with error e:12751
Tue Mar 20 10:43:32 2012
ERROR: Unable to normalize symbol name for the following short stack (at offset 153):
dbgexProcessError()+164<-dbgePostErrorKGE()+1320<-dbkePostKGE_kgsf()+44<-kgeade()+416<-kgerelv()+144<-kgerev()+56<-kgerec4()+32<-kjdgpstackdmp()+1132<-_$c1A.kjdglblkrdm pint()+244<-ksikblkrdmpi()+236<-ksqgtlctx()+11032<-ksqgelctx()+772<-kcc_get_enqueue()+832<-kccocx()+580<-kcc_begin_txn_internal()+68<-kcrfwl()+636<-ksbabs()+968<-ksbrdp ()+1236<-opirip()+1008<-opidrv()+780<-sou2o()+92<-opimai_real()+516<-ssthrdmain()+320<-main()+308<-_start()+380 Errors in file /u01/app/oracle/diag/rdbms/bdrjdw/BDRJDW/trace/BDRJDW_lgwr_18527.trc (incident=64156): ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 18529' Incident details in: /u01/app/oracle/diag/rdbms/bdrjdw/BDRJDW/incident/incdir_64156/BDRJDW_lgwr_18527_i64156.trc Killing enqueue blocker (pid=18529) on resource CF-00000000-00000000 by (pid=18527) ORA-1092 : opitsk aborting process Tue Mar 20 10:43:43 2012 ORA-1092 : opitsk aborting process Tue Mar 20 10:43:44 2012 Instance terminated by LGWR, pid = 18527 Tue Mar 20 10:44:56 2012 O backup é via rman (FULL) com alocação de 3 canais para disco!

[rmanParticipante]

@ramasine

Verifique os traces:

/u01/app/oracle/diag/rdbms/bdrjdw/BDRJDW/trace/BDRJDW_lgwr_18527.trc

/u01/app/oracle/diag/rdbms/bdrjdw/BDRJDW/incident/incdir_64156/BDRJDW_lgwr_18527_i64156.trc

Lá pode ter pistas da causa do problema.

[Autor]

Posts