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, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, 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