ORA-19625: error identifying file XXXXX

  在RMAN备份全库的时候,将归档日志一同进行备份,结果报如下错误,可以看到是无法获得对应归档日志的报错:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/05/2017 23:52:03
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /oradata/gqtzdb/archivelog/1_173_946166147.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

  根据报错,进入对应目录查看,发现确实没有此归档日志。所以此报错的原因可能是人为物理删除了该归档,而在控制文件中还记录此归档的存在,因此需要将此归档信息从控制文件的记载中删除,命令如下:

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;

[oracle@KG-ORA-01 archivelog]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 5 23:56:10 2017

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

connected to target database: GQTZDB (DBID=1719892735)

RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=288 device type=DISK
validation failed for archived log
archived log file name=/oradata/gqtzdb/archivelog/1_173_946166147.dbf RECID=3870 STAMP=948015057
validation failed for archived log
archived log file name=/oradata/gqtzdb/archivelog/1_174_946166147.dbf RECID=3873 STAMP=948015107
validation failed for archived log
archived log file name=/oradata/gqtzdb/archivelog/1_175_946166147.dbf RECID=3875 STAMP=948015107
validation succeeded for archived log
archived log file name=/oradata/gqtzdb/archivelog/1_38_948016496.dbf RECID=3960 STAMP=948585123
validation succeeded for archived log
archived log file name=/oradata/gqtzdb/archivelog/1_39_948016496.dbf RECID=3962 STAMP=948585123
Crosschecked 5 objects


RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=288 device type=DISK
List of Archived Log Copies for database with db_unique_name GQTZDB
=====================================================================

Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
3870    1    173     X 30-JUN-17
        Name: /oradata/gqtzdb/archivelog/1_173_946166147.dbf

3873    1    174     X 30-JUN-17
        Name: /oradata/gqtzdb/archivelog/1_174_946166147.dbf

3875    1    175     X 30-JUN-17
        Name: /oradata/gqtzdb/archivelog/1_175_946166147.dbf


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/oradata/gqtzdb/archivelog/1_173_946166147.dbf RECID=3870 STAMP=948015057
deleted archived log
archived log file name=/oradata/gqtzdb/archivelog/1_174_946166147.dbf RECID=3873 STAMP=948015107
deleted archived log
archived log file name=/oradata/gqtzdb/archivelog/1_175_946166147.dbf RECID=3875 STAMP=948015107
Deleted 3 EXPIRED objects


RMAN> 

RMAN>  crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=288 device type=DISK
validation succeeded for archived log
archived log file name=/oradata/gqtzdb/archivelog/1_38_948016496.dbf RECID=3960 STAMP=948585123
validation succeeded for archived log
archived log file name=/oradata/gqtzdb/archivelog/1_39_948016496.dbf RECID=3962 STAMP=948585123
Crosschecked 2 objects

   再次备份成功。

原文地址:https://www.cnblogs.com/zx3212/p/7127162.html