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!
rman.
rman.
ramasine
ramasine
rman