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:
- Rodar o comando “CROSSCHECK ARCHIVELOG ALL;’ no banco de dados target do RMAN que apresentou erro;
- Após a finalização do primeiro passo, deletar os archives expirados executando o seguinte comando “DELETE EXPIRED ARCHIVELOG ALL;” ;
- 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
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
Yep! Thanks for summarizing !
Gracias los comandos son correctos voy a intentar sacando nuevamente el respaldos