- 29 Nov, 2023
- 0 Comments
- 3 Mins Read
ORA-19625 : error identifying file
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;Starting backup at 29-NOV-23current log archivedusing channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of backup plus archivelog command at 29/11/2023 00:16:23RMAN-06059: expected archived log not found, loss of archived log compromises recoverabilityORA-19625: error identifying file /u01/app/oracle/oradata/archive/1_241_850299214.arcORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3 |
Solution :
You can check your expire archive log list and delete expired archive log files from RMAN, If you really lost your archive log file and you are not able to collect this file.1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 | RMAN> crosscheck archivelog all;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=98 device type=DISKvalidation failed for archived logarchived log file name=/u01/app/oracle/oradata/archive/1_241_850299214.arc RECID=351 STAMP=860457193validation failed for archived logarchived log file name=/u01/app/oracle/oradata/archive/1_242_850299214.arc RECID=351 STAMP=860457670validation succeeded for archived logarchived log file name=/u01/app/oracle/oradata/archive/1_243_850299214.arc RECID=352 STAMP=860458582Crosschecked 3 objectsRMAN> DELETE EXPIRED ARCHIVELOG ALL;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=98 device type=DISKList of Archived Log Copies for database with db_unique_name ORA11GS=====================================================================Key Thrd Seq S Low Time------- ---- ------- - ---------2730 1 241 X 29-NOV-23 Name: /u01/app/oracle/oradata/archive/1_241_850299214.arc3002 1 242 X 29-NOV-23 Name: /u01/app/oracle/oradata/archive/1_242_850299214.arcDo you really want to delete the above objects (enter YES or NO)? yesdeleted archived logarchived log file name=/u01/app/oracle/oradata/archive/1_241_850299214.arc RECID=351 STAMP=860457193deleted archived logarchived log file name=/u01/app/oracle/oradata/archive/1_242_850299214.arc RECID=351 STAMP=860457670Deleted 2 EXPIRED objectsRMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;Starting backup at 29-NOV-23current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=243 RECID=352 STAMP=860458582input archived log thread=1 sequence=244 RECID=353 STAMP=860459023channel ORA_DISK_1: starting piece 1 at 29-NOV-23channel ORA_DISK_1: finished piece 1 at 29-NOV-23piece handle=/u01/rman_backup/ora11gs_bkp_1gpkj40g tag=TAG20141009T002344 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01channel ORA_DISK_1: deleting archived log(s)archived log file name=/u01/app/oracle/oradata/archive/1_243_850299214.arc RECID=352 STAMP=860458582archived log file name=/u01/app/oracle/oradata/archive/1_244_850299214.arc RECID=353 STAMP=860459023Finished backup at 29-NOV-23Starting backup at 29-NOV-23using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/ora11gp/system01.dbfinput datafile file number=00002 name=/u01/app/oracle/oradata/ora11gp/sysaux01.dbfinput datafile file number=00003 name=/u01/app/oracle/oradata/ora11gp/undotbs01.dbfinput datafile file number=00004 name=/u01/app/oracle/oradata/ora11gp/users01.dbfchannel ORA_DISK_1: starting piece 1 at 29-NOV-23channel ORA_DISK_1: finished piece 1 at 29-NOV-23piece handle=/u01/rman_backup/ora11gs_bkp_1hpkj40h tag=TAG20141009T002345 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:25Finished backup at 29-NOV-23Starting backup at 29-NOV-23current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=245 RECID=354 STAMP=860459111channel ORA_DISK_1: starting piece 1 at 29-NOV-23channel ORA_DISK_1: finished piece 1 at 29-NOV-23piece handle=/u01/rman_backup/ora11gs_bkp_1ipkj437 tag=TAG20141009T002511 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01channel ORA_DISK_1: deleting archived log(s)archived log file name=/u01/app/oracle/oradata/archive/1_245_850299214.arc RECID=354 STAMP=860459111Finished backup at 29-NOV-23Starting Control File and SPFILE Autobackup at 29-NOV-23piece handle=/u01/rman_backup/bkp_cf_c-3519562480-20141009-01 comment=NONEFinished Control File and SPFILE Autobackup at 29-NOV-23RMAN> |