[ 2015-12-15 ]

Falla en el archivado de un online redolog por corrupción del online redo file

Comparto un problema con el cual me encontré días atrás y como resolverlo:
  • fact: Oracle Server - Enterprise Edition
  • fact: Instance is running
  • symptom: Errors when archiving online redolog
  • symptom: ORA-16038: log %s sequence# %s cannot be archived
  • symptom: ORA-00354: corrupt redo log block header
  • symptom: ORA-00312: "online log %s thread %s: '%s'"
  • cause: Failure to archive online redolog due to a corruption in the online redo file
fix:

You can keep the database running when solving and working around this problem. 
The following steps have to be taken:

1) alter database clear unarchived logfile '<logfilename>';          

2) make a new complete (online) backup of your database

The first command clears the online logfile (fills it with all null).  This 
makes the corruption disappear which causes the contents of the cleared online  
redo file to be missing in the archived redo stream. This requires a new 
complete (online) backup to allow for complete recovery in the future (step 2).

MOS: Errors in Archiving Online Redolog (Doc ID 145769.1)

No hay comentarios:

Publicar un comentario