RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

oracle-11g-logo

Estava executando um backup utilizando Zero Data Loss Recovery Appliance – ZDLRA com Recovery Manager (RMAN), quando a execução foi abortada reportando o seguinte erro: “RMAN-06059: expected archived log not found, loss of archived log compromises recoverability”


[techdatabasket_server-techdatabasket_1]/home/oracle> tail -f rman_zdlra.log
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 10/06/2016 22:26:33
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file +DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86026.1088.910451079
ORA-17503: ksfdopn:2 Failed to open file +DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86026.1088.910451079
ORA-15012: ASM file '+DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86026.1088.910451079' does not exist

Para resolver este erro, basta efetuar os seguintes passos:

  1. Rodar o comando “CROSSCHECK ARCHIVELOG ALL;’ no banco de dados  target do RMAN que apresentou erro;
  2. Após a finalização do primeiro passo, deletar os archives expirados executando o seguinte comando “DELETE EXPIRED ARCHIVELOG ALL;” ;
  3. Reprocessar o backup que apresentou erro anteriormente.

Sendo assim, segue abaixo o exemplo dos passos 1 e 2 para resolver o problema:

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 6 22:30:02 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: techdatabasket (DBID=3495312623)
connected to recovery catalog database

RMAN> CROSSCHECK ARCHIVELOG ALL;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2463 instance=techdatabasket_1 device type=DISK
validation failed for archived log
archived log file name=+DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86026.1088.910451079 RECID=256702 STAMP=910451078
validation failed for archived log
archived log file name=+DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86027.627.910451997 RECID=256707 STAMP=910451999
validation failed for archived log
archived log file name=+DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86028.831.910452003 RECID=256708 STAMP=910452002
validation succeeded for archived log
archived log file name=+DG_FRA2/techdatabasket/archivelog/2016_10_06/thread_1_seq_169008.729.924559589 RECID=518775 STAMP=924559589
validation succeeded for archived log
archived log file name=+DG_FRA2/techdatabasket/archivelog/2016_10_06/thread_1_seq_169009.740.924560787 RECID=518778 STAMP=924560790
Crosschecked 5 objects
RMAN> DELETE EXPIRED ARCHIVELOG ALL;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2463 instance=techdatabasket_1 device type=DISK
List of Archived Log Copies for database with db_unique_name techdatabasket
=====================================================================

Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
1519994 1    86026   X 29-APR-16
        Name: +DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86026.1088.910451079

1519995 1    86027   X 29-APR-16
        Name: +DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86027.627.910451997

1519996 1    86028   X 29-APR-16
        Name: +DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86028.831.910452003


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=+DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86026.1088.910451079 RECID=256702 STAMP=910451078
deleted archived log
archived log file name=+DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86027.627.910451997 RECID=256707 STAMP=910451999
deleted archived log
archived log file name=+DG_FRA2/techdatabasket/archivelog/2016_04_29/thread_1_seq_86028.831.910452003 RECID=256708 STAMP=910452002
Deleted 3 EXPIRED objects

kindregards

Related posts

3 Thoughts to “RMAN-06059: expected archived log not found, loss of archived log compromises recoverability”

  1. Arun

    RMAN> CROSSCHECK ARCHIVELOG ALL;

    RMAN> DELETE EXPIRED ARCHIVELOG ALL;

    1. brunors

      Yep! Thanks for summarizing !

  2. Marco Mejia

    Gracias los comandos son correctos voy a intentar sacando nuevamente el respaldos

Leave a Comment