RMAN-03002 RMAN-06059 ORA-19625

En ocasiones puede suceder que por algún motivo en especial, se borran manualmente los archivos de archivelog de una base de datos.

A la hora de intentar generar el respaldo con el utilitario RMAN, este no devuelve un mensaje, indicando que existe un archivo idéntificado dentro de la lista de archivos disponibles para respaldar, que no se encuentra físicamente en la ubicación que debería estar.

Para soluccionar el problema, puede seguir el siguiente procedimiento:

RMAN> backup device type disk tag '%TAG_1' archivelog all not backed up delete all input;

Starting backup at 02-NOV-09
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/02/2009 12:17:06
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_2_16519_5gy8crlt_.arc
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=262 instance=admin1 devtype=DISK
validation succeeded for archived log
archive log filename=/respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_1_54199_5gy8cswp_.arc recid=14080 stamp=701871257
validation succeeded for archived log
archive log filename=/respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_1_54200_5gy8jf3x_.arc recid=14082 stamp=701871405
validation failed for archived log
archive log filename=/respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_2_16519_5gy8crlt_.arc recid=14081 stamp=701871270
validation failed for archived log
archive log filename=/respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_2_16520_5gy8jkvc_.arc recid=14083 stamp=701871422
Crosschecked 4 objects

RMAN> delete noprompt expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=262 instance=admin1 devtype=DISK

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
14081 2 16519 X 02-NOV-09 /respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_2_16519_5gy8crlt_.arc
14083 2 16520 X 02-NOV-09 /respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_2_16520_5gy8jkvc_.arc
deleted archive log archive log

filename=/respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_2_16519_5gy8crlt_.arc recid=14081 stamp=701871270

deleted archive log
archive log filename=/respaldos/archives/ADMIN/archivelog/2009_11_02/o1_mf_2_16520_5gy8jkvc_.arc recid=14083 stamp=701871422

Deleted 2 EXPIRED objects

RMAN>

Ahora ya puede realizar el respaldo de los archives log, sin problemas.