RMAN-06059 ORA-19625 backup archivelog all delete input

Problem Description
RMAN archivelog all delete input is failing with following error.
Starting backup at 01-DEC-11
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 12/01/2011 08:53:06
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file +RECO/prod4/archivelog/2011_11_11/thread_1_seq_1258.1184.768539967
ORA-17503: ksfdopn:2 Failed to open file +RECO/prod4/archivelog/2011_11_11/thread_1_seq_1258.1184.768539967
ORA-15012: ASM file '+RECO/prod4/archivelog/2011_11_11/thread_1_seq_1258.1184.768539967' does not exist

Solution Description: It looks like your archivelogs are missing or deleted. Try to restore the files if you have it in any other location. If you don’t have these files in any other location, it is advisable to take a fresh level 0 full backup to avoid the data lose. 
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google