Problém:
Starting backup at 25-SEP-24
current log archived
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 09/25/2024 10:43:59
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /fra/ORCL/archivelog/2021_10_31/o1_mf_1_35818_jqvtq3ym_.arc
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Řešení:
RMAN> change archivelog all crosscheck;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
validation failed for archived log
archived log file name=/fra/ORCL/archivelog/2021_10_31/o1_mf_1_35818_jqvtq3ym_.arc RECID=35810 STAMP=1087351283
validation failed for archived log
archived log file name=/fra/ORCL/archivelog/2022_10_30/o1_mf_1_71264_kovm7d4s_.arc RECID=71256 STAMP=1119405692
validation succeeded for archived log
archived log file name=/fra/ORCL/archivelog/2023_10_29/o1_mf_1_106522_lmvcozq1_.arc RECID=106514 STAMP=1151460047
validation succeeded for archived log
archived log file name=/fra/ORCL/archivelog/2024_09_24/o1_mf_1_138773_mh6d8rwq_.arc RECID=138765 STAMP=1180568248
validation succeeded for archived log
archived log file name=/fra/ORCL/archivelog/2024_09_24/o1_mf_1_138774_mh6f4wpv_.arc RECID=138766 STAMP=1180569148
validation succeeded for archived log
Starting backup at 25-SEP-24
current log archived
channel ch1: starting compressed archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=138823 RECID=138815 STAMP=1180608604
channel ch1: starting piece 1 at 25-SEP-24
channel ch1: finished piece 1 at 25-SEP-24
piece handle=/backup/esada/0435ta2s_1_1 tag=TAG20240925T105004 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-SEP-24
released channel: ch1