Skip to Main Content

Database Software

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 with 2 archive log locations

877831Jul 25 2011 — edited Jul 26 2011
Hi

I have a quite stupid problem, but don't know how to resolve it. I tried many combinations, spent many hours, but with false result.

There are 2 archive log locations, running the RMAN script I just want to delete files from one locaton and not delete files from the second one. Is there somebody who faced with similiar problem? Will really appreciate for any help. As I said I tried many many things, but the problem is still unresolved.

===================

Archive log destinations (show parameter log_archive_dest)

log_archive_dest_1 string LOCATION=F:\Oracle_Backup\Archive\PGRET1
log_archive_dest_2 string LOCATION=F:\Oracle_Backup\Archive\to_send


RMAN script that I am currently using:

backup device type disk tag '%TAG' database;
backup device type disk tag '%TAG' archivelog all not backed up delete all input;
allocate channel for maintenance type disk;
crosscheck backup device type disk;
delete noprompt obsolete device type disk;
release channel;



OK, so the problem is to modify the script, so that it will delete old archive logs from log_archive_dest_1 but not delete any files from location log_archive_dest_2.

Will be really appreciate for any sugestions.

Kind regards,
M
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2011
Added on Jul 25 2011
8 comments
4,638 views