Problém

RMAN> backup archivelog all;

Starting backup at 06-MAY-16
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 05/06/2016 09:51:42
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: chyba pri identifikaci souboru /fra/oraorcl/ORCL/archivelog/2016_04_21/o1_mf_1_76824_ckj646fn_.arc
ORA-27048: skgfifi: udaje v zahlavi souboru jsou neplatne
Additional information: 9

Řešení

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=410 device type=DISK
validation failed for archived log
archived log file name=/fra/oraorcl/ORCL/archivelog/2016_04_21/o1_mf_1_76824_ckj646fn_.arc RECID=76545 STAMP=909712934
validation succeeded for archived log
archived log file name=/fra/oraorcl/ORCL/archivelog/2016_05_06/o1_mf_1_77652_clrm8g01_.arc RECID=77373 STAMP=911123502
Crosschecked 2 objects

RMAN> delete expired archivelog all;

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

Key     Thrd Seq     S Low Time
——- —- ——- – ———
76545   1    76824   X 21-APR-16
Name: /fra/oraorcl/ORCL/archivelog/2016_04_21/o1_mf_1_76824_ckj646fn_.arc

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/fra/oraorcl/ORCL/archivelog/2016_04_21/o1_mf_1_76824_ckj646fn_.arc RECID=76545 STAMP=909712934
Deleted 1 EXPIRED objects

RMAN> backup archivelog all;

Starting backup at 06-MAY-16
current log archived
using channel ORA_DISK_1
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=77652 RECID=77373 STAMP=911123502
input archived log thread=1 sequence=77653 RECID=77374 STAMP=911123641
channel ORA_DISK_1: starting piece 1 at 06-MAY-16
channel ORA_DISK_1: finished piece 1 at 06-MAY-16
piece handle=/backup/oraorcl/backup/ORCL_df911123641_s47411_s1 tag=TAG20160506T095401 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 06-MAY-16

Starting Control File and SPFILE Autobackup at 06-MAY-16
piece handle=/backup/oraorcl/cf_autobackup/c-1519952010-20160506-00 comment=NONE
Finished Control File and SPFILE Autobackup at 06-MAY-16



Komentáře