Rman backup archivelog ORA-19625 appears

The following error occurs when rman backs up archivelog:

RMAN> backup archivelog all delete input;

Starting backup at 14-APR-14

Current log archived

Using channel ORA_DISK_1

Using channel ORA_DISK_2

RMAN-00571: ========================================================== ==============================

RMAN-00569: ==================== error message stack follows ==========================

RMAN-00571: ========================================================== ==============================

RMAN-03002: failure of backup command at 04/14/2014 18:40:23

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
 
The ORA-19625: error identifying file/home/Oracle/PROD/1_2_844469007.dbf

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

-------------------------------------- Split line --------------------------------------

Recommended reading:

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------

An error was found on the internet because the archive log was deleted in the operating system and has not been backed up yet. When rman was used to back up the log, the archive failed to be found. You can use the change archivelog all crosscheck command to solve this problem, as follows:
 
RMAN> change archivelog all crosscheck;

Released channel: ORA_DISK_1

Released channel: ORA_DISK_2

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID = 43 device type = DISK

Allocated channel: ORA_DISK_2

Channel ORA_DISK_2: SID = 45 device type = DISK

Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/41516_827176743.dbf RECID = 1 STAMP = 844399662
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/route 17_827176743.dbf RECID = 2 STAMP = 844460245
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/export 18_827176743.dbf RECID = 3 STAMP = 844461320
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/route 19_827176743.dbf RECID = 4 STAMP = 844461426
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/201720_827176743.dbf RECID = 5 STAMP = 844461580
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/export 21_827176743.dbf RECID = 6 STAMP = 844461592
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/export 22_827176743.dbf RECID = 7 STAMP = 844461696
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/route 23_827176743.dbf RECID = 8 STAMP = 844462037
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/42424_827176743.dbf RECID = 9 STAMP = 844462165
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/42425_827176743.dbf RECID = 10 STAMP = 844462279
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/export 26_827176743.dbf RECID = 11 STAMP = 844462409
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/route 27_827176743.dbf RECID = 12 STAMP = 844465108
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/export 28_827176743.dbf RECID = 13 STAMP = 844469010
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/History history 841_2679.dbf RECID = 16 STAMP = 844533450
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/1_2_841_2679.dbf RECID = 19 STAMP = 844537684
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/1_2_841_2679.dbf RECID = 17 STAMP = 844533553
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/1_3_841_2679.dbf RECID = 20 STAMP = 844537685
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/4154_8420.2679.dbf RECID = 18 STAMP = 844537684
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/release route 844537684.dbf RECID = 23 STAMP = 844605032
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/History history 844537684.dbf RECID = 21 STAMP = 844575254
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/1_2_844537684.dbf RECID = 24 STAMP = 844605033
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/1_2_844537684.dbf RECID = 22 STAMP = 844581004
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/1_3_844537684.dbf RECID = 25 STAMP = 844605034
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/route 844469007.dbf RECID = 14 STAMP = 844530587
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/History history 844605031.dbf RECID = 26 STAMP = 844670045
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/1_2_844605031.dbf RECID = 27 STAMP = 844797748
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/1_3_844605031.dbf RECID = 28 STAMP = 844841532
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/4154_844605031.dbf RECID = 29 STAMP = 844847317
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/logs 5_844605031.dbf RECID = 30 STAMP = 844855807
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/route 6_844605031.dbf RECID = 31 STAMP = 844855838
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/route 7_844605031.dbf RECID = 32 STAMP = 844886422
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/export 8_844605031.dbf RECID = 33 STAMP = 844886590
 
Validation succeeded for archived log

Archived log file name =/home/oracle/PROD/rj9_844605031.dbf RECID = 34 STAMP = 844886622
 
Crosschecked 33 objects

 

Validation failed for archived log

Archived log file name =/home/oracle/PROD/1_2_844469007.dbf RECID = 15 STAMP = 844530793
 
Crosschecked 1 objects

-- Execute archivelog's rman backup again, as shown below:

RMAN> backup archivelog all delete input;

 

Starting backup at 14-APR-14

Current log archived

Using channel ORA_DISK_1

Using channel ORA_DISK_2

Channel ORA_DISK_1: starting compressed archived log backup set

Channel ORA_DISK_1: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 16 RECID = 1 STAMP = 844399662

Input archived log thread = 1 sequence = 17 RECID = 2 STAMP = 844460245

Input archived log thread = 1 sequence = 18 RECID = 3 STAMP = 844461320

Channel ORA_DISK_1: starting piece 1 at 14-APR-14

Channel ORA_DISK_2: starting compressed archived log backup set

Channel ORA_DISK_2: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 1 RECID = 16 STAMP = 844533450

Channel ORA_DISK_2: starting piece 1 at 14-APR-14

Channel ORA_DISK_2: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/PROD_20140414_1bp5ntq0_1_1.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02

Channel ORA_DISK_2: deleting archived log (s)

Archived log file name =/home/oracle/PROD/History history 841_2679.dbf RECID = 16 STAMP = 844533450
 
Channel ORA_DISK_2: starting compressed archived log backup set

Channel ORA_DISK_2: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 19 RECID = 4 STAMP = 844461426

Input archived log thread = 1 sequence = 20 RECID = 5 STAMP = 844461580

Input archived log thread = 1 sequence = 21 RECID = 6 STAMP = 844461592

Input archived log thread = 1 sequence = 22 RECID = 7 STAMP = 844461696

Input archived log thread = 1 sequence = 23 RECID = 8 STAMP = 844462037

Input archived log thread = 1 sequence = 24 RECID = 9 STAMP = 844462165

Input archived log thread = 1 sequence = 25 RECID = 10 STAMP = 844462279

Channel ORA_DISK_2: starting piece 1 at 14-APR-14

Channel ORA_DISK_1: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/prod_20140414_1ap5ntq0_00001.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Channel ORA_DISK_1: deleting archived log (s)

Archived log file name =/home/oracle/PROD/41516_827176743.dbf RECID = 1 STAMP = 844399662
 
Archived log file name =/home/oracle/PROD/route 17_827176743.dbf RECID = 2 STAMP = 844460245
 
Archived log file name =/home/oracle/PROD/export 18_827176743.dbf RECID = 3 STAMP = 844461320
 
Channel ORA_DISK_1: starting compressed archived log backup set

Channel ORA_DISK_1: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 2 RECID = 19 STAMP = 844537684

Input archived log thread = 1 sequence = 3 RECID = 20 STAMP = 844537685

Channel ORA_DISK_1: starting piece 1 at 14-APR-14

Channel ORA_DISK_2: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/prod_20140414_1cp5ntq3_00001.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_2: backup set complete, elapsed time: 00:00:00

Channel ORA_DISK_2: deleting archived log (s)

Archived log file name =/home/oracle/PROD/route 19_827176743.dbf RECID = 4 STAMP = 844461426
 
Archived log file name =/home/oracle/PROD/201720_827176743.dbf RECID = 5 STAMP = 844461580
 
Archived log file name =/home/oracle/PROD/export 21_827176743.dbf RECID = 6 STAMP = 844461592
 
Archived log file name =/home/oracle/PROD/export 22_827176743.dbf RECID = 7 STAMP = 844461696
 
Archived log file name =/home/oracle/PROD/route 23_827176743.dbf RECID = 8 STAMP = 844462037
 
Archived log file name =/home/oracle/PROD/42424_827176743.dbf RECID = 9 STAMP = 844462165
 
Archived log file name =/home/oracle/PROD/42425_827176743.dbf RECID = 10 STAMP = 844462279
 
Channel ORA_DISK_2: starting compressed archived log backup set

Channel ORA_DISK_2: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 26 RECID = 11 STAMP = 844462409

Input archived log thread = 1 sequence = 27 RECID = 12 STAMP = 844465108

Channel ORA_DISK_2: starting piece 1 at 14-APR-14

Channel ORA_DISK_1: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/prod_20140414_1dp5ntq3_00001.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00

Channel ORA_DISK_1: deleting archived log (s)

Archived log file name =/home/oracle/PROD/1_2_841_2679.dbf RECID = 19 STAMP = 844537684
 
Archived log file name =/home/oracle/PROD/1_3_841_2679.dbf RECID = 20 STAMP = 844537685
 
Channel ORA_DISK_1: starting compressed archived log backup set

Channel ORA_DISK_1: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 4 RECID = 18 STAMP = 844537684

Channel ORA_DISK_1: starting piece 1 at 14-APR-14

Channel ORA_DISK_2: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/prod_20140414_1ep5ntq3_00001.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01

Channel ORA_DISK_2: deleting archived log (s)

Archived log file name =/home/oracle/PROD/export 26_827176743.dbf RECID = 11 STAMP = 844462409
 
Archived log file name =/home/oracle/PROD/route 27_827176743.dbf RECID = 12 STAMP = 844465108
 
Channel ORA_DISK_2: starting compressed archived log backup set

Channel ORA_DISK_2: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 1 RECID = 23 STAMP = 844605032

Channel ORA_DISK_2: starting piece 1 at 14-APR-14

Channel ORA_DISK_1: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/prod_20140414_1fp5ntq4_00001.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:00

Channel ORA_DISK_1: deleting archived log (s)

Archived log file name =/home/oracle/PROD/4154_8420.2679.dbf RECID = 18 STAMP = 844537684
 
Channel ORA_DISK_1: starting compressed archived log backup set

Channel ORA_DISK_1: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 28 RECID = 13 STAMP = 844469010

Channel ORA_DISK_1: starting piece 1 at 14-APR-14

Channel ORA_DISK_1: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/prod_20140414_1hp5ntq4_00001.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04

Channel ORA_DISK_1: deleting archived log (s)

Archived log file name =/home/oracle/PROD/export 28_827176743.dbf RECID = 13 STAMP = 844469010
 
Channel ORA_DISK_1: starting compressed archived log backup set

Channel ORA_DISK_1: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 1 RECID = 14 STAMP = 844530587

Channel ORA_DISK_1: starting piece 1 at 14-APR-14

Channel ORA_DISK_2: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/prod_20140414_1gp5ntq4_00001.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_2: backup set complete, elapsed time: 00:00:04

Channel ORA_DISK_2: deleting archived log (s)

Archived log file name =/home/oracle/PROD/release route 844537684.dbf RECID = 23 STAMP = 844605032
 
Channel ORA_DISK_2: starting compressed archived log backup set

Channel ORA_DISK_2: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 2 RECID = 24 STAMP = 844605033

Input archived log thread = 1 sequence = 3 RECID = 25 STAMP = 844605034

Channel ORA_DISK_2: starting piece 1 at 14-APR-14

Channel ORA_DISK_1: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/prod_20140414_1ip5ntq8_00001.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08

Channel ORA_DISK_1: deleting archived log (s)

Archived log file name =/home/oracle/PROD/route 844469007.dbf RECID = 14 STAMP = 844530587
 
Channel ORA_DISK_1: starting compressed archived log backup set

Channel ORA_DISK_1: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 1 RECID = 26 STAMP = 844670045

Input archived log thread = 1 sequence = 2 RECID = 27 STAMP = 844797748

Input archived log thread = 1 sequence = 3 RECID = 28 STAMP = 844841532

Channel ORA_DISK_1: starting piece 1 at 14-APR-14

Channel ORA_DISK_2: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/PROD_20140414_1jp5ntq8_1_1.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_2: backup set complete, elapsed time: 00:00:07

Channel ORA_DISK_2: deleting archived log (s)

Archived log file name =/home/oracle/PROD/1_2_844537684.dbf RECID = 24 STAMP = 844605033
 
Archived log file name =/home/oracle/PROD/1_3_844537684.dbf RECID = 25 STAMP = 844605034
 
Channel ORA_DISK_2: starting compressed archived log backup set

Channel ORA_DISK_2: specifying archived log (s) in backup set

Input archived log thread = 1 sequence = 4 RECID = 29 STAMP = 844847317

Input archived log thread = 1 sequence = 5 RECID = 30 STAMP = 844855807

Input archived log thread = 1 sequence = 6 RECID = 31 STAMP = 844855838

Input archived log thread = 1 sequence = 7 RECID = 32 STAMP = 844886422

Input archived log thread = 1 sequence = 8 RECID = 33 STAMP = 844886590

Input archived log thread = 1 sequence = 9 RECID = 34 STAMP = 844886622

Input archived log thread = 1 sequence = 10 RECID = 35 STAMP = 844887872

Channel ORA_DISK_2: starting piece 1 at 14-APR-14

Channel ORA_DISK_1: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/PROD_20140414_1kp5ntqg_1_1.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16

Channel ORA_DISK_1: deleting archived log (s)

Archived log file name =/home/oracle/PROD/History history 844605031.dbf RECID = 26 STAMP = 844670045
 
Archived log file name =/home/oracle/PROD/1_2_844605031.dbf RECID = 27 STAMP = 844797748
 
Archived log file name =/home/oracle/PROD/1_3_844605031.dbf RECID = 28 STAMP = 844841532
 
Channel ORA_DISK_2: finished piece 1 at 14-APR-14

Piece handle =/home/oracle/backup/PROD_20140414_1lp5ntqh_1_1.bak tag = TAG20140414T190432 comment = NONE
 
Channel ORA_DISK_2: backup set complete, elapsed time: 00:00:15

Channel ORA_DISK_2: deleting archived log (s)

Archived log file name =/home/oracle/PROD/4154_844605031.dbf RECID = 29 STAMP = 844847317
 
Archived log file name =/home/oracle/PROD/logs 5_844605031.dbf RECID = 30 STAMP = 844855807
 
Archived log file name =/home/oracle/PROD/route 6_844605031.dbf RECID = 31 STAMP = 844855838
 
Archived log file name =/home/oracle/PROD/route 7_844605031.dbf RECID = 32 STAMP = 844886422
 
Archived log file name =/home/oracle/PROD/export 8_844605031.dbf RECID = 33 STAMP = 844886590
 
Archived log file name =/home/oracle/PROD/rj9_844605031.dbf RECID = 34 STAMP = 844886622
 
Archived log file name =/home/oracle/PROD/201710_844605031.dbf RECID = 35 STAMP = 844887872
 
Finished backup at 14-APR-14

 

Starting Control File Autobackup at 14-APR-14

Piece handle =/home/oracle/backup/control/c-239015079-20140414-0d comment = NONE

Finished Control File Autobackup at 14-APR-14

Note:

Crosscheck archivelog all: After you manually delete the archive file of the database, you need to use this command for synchronization. (Archive logs are deleted physically, but the control file is not known. Therefore, cross-check is required to synchronize information)
 
Crosscheck backup: this command is required when the rman backup level is manually deleted:

The difference between them is that the synchronization content is different. One is to synchronize the status of the archive file, and the other is to synchronize the RMAN backup information.