Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman backup excluding missing archivelogs

609621Nov 24 2008 — edited Nov 24 2008
Please 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2008
Added on Nov 24 2008
2 comments
3,033 views