Wednesday, February 13, 2019

RMAN-06059: expected archived log not found,loss of archived log compromises recoverability

Problem:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/29/2015 05:09:31
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /tmp/thread_1_seq_51256.712.898891279
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 1


Solution:

Step 1:

RMAN> delete noprompt expired archivelog all;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1618 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1865 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=5 device type=DISK
List of Archived Log Copies for database with db_unique_name testdb
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
1       1    51256   X 19-DEC-15
        Name: /tmp/thread_1_seq_51256.712.898891279

deleted archived log
archived log file name=/tmp/thread_1_seq_51256.712.898891279 RECID=1 STAMP=898907388
Deleted 1 EXPIRED objects


Step 2:


RMAN> crosscheck archivelog all;

No comments:

Post a Comment