Log Corruption
Publicado por Sara (1 intervención) el 12/05/2009 19:09:25
Tengo una base de datos en Oracle 10g, y dicha bae de datos se ha estado quedando no disponible indicando un error de 'Log Corruption'.
Este es el mensaje que indica el archivo TRC:
*** SERVICE NAME:() 2009-05-11 09:47:28.264
*** SESSION ID:(211.1) 2009-05-11 09:47:28.264
kcrrwkx: work to do 0x1 (start)
*** 2009-05-11 09:47:32.396 60680 kcrr.c
ARC0: Log corruption near block 77778 change 240605325 time ?
ORA-00354: Message 354 not found; No message file for product=RDBMS, facility=ORA
ORA-00353: Message 353 not found; No message file for product=RDBMS, facility=ORA; arguments: [77778] [240605325] [05/06/2009 14:45:04]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSBREDO01.LOG]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSAREDO01.LOG]
*** 2009-05-11 09:47:32.471 60680 kcrr.c
ARC0: All Archive destinations made inactive due to error 354
*** 2009-05-11 09:47:32.490 58942 kcrr.c
kcrrfail: dest:2 err:354 force:0 blast:1
*** 2009-05-11 09:47:32.547 58942 kcrr.c
kcrrfail: dest:1 err:354 force:0 blast:1
*** 2009-05-11 09:47:32.997 20146 kcrr.c
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [16900]
ORA-00354: Message 354 not found; No message file for product=RDBMS, facility=ORA
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSAREDO01.LOG]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSBREDO01.LOG]
*** 2009-05-11 09:48:40.657
*** 2009-05-11 09:48:40.657 20146 kcrr.c
ORA-16014: Message 16014 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [16900]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSAREDO01.LOG]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSBREDO01.LOG]
Dump file c:oracle10gproduct10.2.0adminfproddumpfprod_arc0_300.trc
Tue May 12 11:00:47 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.1.0 - Production
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1557M/2047M, Ph+PgF:2184M/3947M, VA:545M/2047M
Instance name: fprod
Redo thread mounted by this instance: 1
Oracle process number: 16
Windows thread id: 300, image: ORACLE.EXE (ARC0)
Que puedo hacer para resolver este problema??
Espero puedan ayudarme por favor, ya que la situacion se esta volviendo critica.
Saludos,
Este es el mensaje que indica el archivo TRC:
*** SERVICE NAME:() 2009-05-11 09:47:28.264
*** SESSION ID:(211.1) 2009-05-11 09:47:28.264
kcrrwkx: work to do 0x1 (start)
*** 2009-05-11 09:47:32.396 60680 kcrr.c
ARC0: Log corruption near block 77778 change 240605325 time ?
ORA-00354: Message 354 not found; No message file for product=RDBMS, facility=ORA
ORA-00353: Message 353 not found; No message file for product=RDBMS, facility=ORA; arguments: [77778] [240605325] [05/06/2009 14:45:04]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSBREDO01.LOG]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSAREDO01.LOG]
*** 2009-05-11 09:47:32.471 60680 kcrr.c
ARC0: All Archive destinations made inactive due to error 354
*** 2009-05-11 09:47:32.490 58942 kcrr.c
kcrrfail: dest:2 err:354 force:0 blast:1
*** 2009-05-11 09:47:32.547 58942 kcrr.c
kcrrfail: dest:1 err:354 force:0 blast:1
*** 2009-05-11 09:47:32.997 20146 kcrr.c
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [16900]
ORA-00354: Message 354 not found; No message file for product=RDBMS, facility=ORA
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSAREDO01.LOG]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSBREDO01.LOG]
*** 2009-05-11 09:48:40.657
*** 2009-05-11 09:48:40.657 20146 kcrr.c
ORA-16014: Message 16014 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [16900]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSAREDO01.LOG]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:ORACLEDATABASEFPRODLOGSBREDO01.LOG]
Dump file c:oracle10gproduct10.2.0adminfproddumpfprod_arc0_300.trc
Tue May 12 11:00:47 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.1.0 - Production
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1557M/2047M, Ph+PgF:2184M/3947M, VA:545M/2047M
Instance name: fprod
Redo thread mounted by this instance: 1
Oracle process number: 16
Windows thread id: 300, image: ORACLE.EXE (ARC0)
Que puedo hacer para resolver este problema??
Espero puedan ayudarme por favor, ya que la situacion se esta volviendo critica.
Saludos,
Valora esta pregunta


0