rman backup excluding missing archivelogs
609621Nov 24 2008 — edited Nov 24 2008Please help me in the following scenario :
I have 2 months old archivelog in my disk..am taking full rman database backup daily at night..but not the archivelog. once I moved some of my archivelog files to another mount point as the archivelog destination is almost filled.
when i try to take the backup of archivelogs,I got the message
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/24/2008 23:16:23
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /archv/PROD/PROD1_234_662754021.arc
ORA-17503: ksfdopn:4 Failed to open file /archv/PROD/PROD1_234_662754021.arc
ORA-17500: ODM err:File does not exist
which is expected, since I moved the file /archv/PROD/PROD1_234_662754021.arc to another location inorder to have that as a temp.solution ..
now , I have all my archivelogs starting from nov-3 till date in the log_archive_dest_1
RMAN> run
{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP FORMAT 'arch_u%u_s%s_p%p_t%t'
Archivelog
FROM TIME "TO_DATE('11-03-2008:23:46:15', 'MM-DD-YYYY:HH24:MI:SS')"
UNTIL TIME "TO_DATE('11-24-2008:23:46:15', 'MM-DD-YYYY:HH24:MI:SS')"
DELETE INPUT;
release channel ch00;
release channel ch01;
}
now, is there anyway i can include the old archivelogs in the rman by restoring from the temporay location and taking backup. I know that I have a full database backup, but I need to have my old archivelogs also included in that ? or () does backup arhcivelog all will give any error message now ?(ORA-17500: ODM err:File does not exist)
Any way ?
Kai