Carel-Jan Engel >>But, AFAIK, RMAN is not DG-aware. Yes, I believe you are right...and based on the answers (from Oracle Employees) I have seen on "Forums" @ Metalink, I sure of it. :O| Actually Oracle Employees on the forum, never really answers the question... >>when you dynamically generate your RMAN script based on the Ah...the beatuy of RMAN...no "dynamic" scripts needed for the primary db backup, but just like the old HOT Bakcup days I think I'm going to have to write shell, Perl, maybe even pl/sql code to aovid delecting log needed by the standyby. Sad, but maybe it will be *fixed* in Oracle 11XL. :o) Thanks, Chris Marquez Oracle DBA HEYMONitor(tm) - heymonitor.com "Oracle Monitoring & Alerting Solution" ----Original Message----- From: Carel-Jan Engel [mailto:cjpengel.dbalert@xxxxxxxxx] Sent: Monday, January 10, 2005 5:07 PM To: Marquez, Chris Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: RMAN/DG - delete *ONLY* archive logs "already shipped to thestandby DataGuard database"? Chris, I'm not an experienced RMAN user, others will have better advice on that topic. But, AFAIK, RMAN is not DG-aware. You might be able to achieve this when you dynamically generate your RMAN script based on the , and use the V$ARCHIVED_LOG view to determine what change# needs to be applied in the 'BACKUP ARCHIVELOG UNTIL SCN <last forwarded SCN>' command. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === Upcoming appearances: * Jan 27, 2005: London, UKOUG Unix SIG: Data Guard Best Practices * Feb 9-10, 2005: Denver, RMOUG Training Days: Data Guard Performance Issues * Mar 6-10, 2005: Dallas, Hotsos Symposium: Data Guard Performance Issues On Mon, 2005-01-10 at 18:08, Marquez, Chris wrote: Hi All, My Oracle-DB is Oracle 9205. We use RMAN to backup databases and archive logs. Once archive logs are backed up we also use RMAN to delete them.=20 We implement standby using DataGuard.=20 Sometimes RMAN backs up archive logs and deletes them before DataGuard ships the archive logs to stand by site. Is there any way I can instruct RMAN to backup all the archive logs=20 BUT delete *ONLY* archive logs "already shipped to the standby DataGuard database". Notice that I did not say delete logs older than "n" time/date...no, I want to delete logs shipped not matter what the date/time is. Thanks in advance. PS Please respond directly to me as well as to the list. Chris Oracle DBA HEYMONitor(tm) - heymonitor.com "Oracle Monitoring & Alerting Solution" -- //www.freelists.org/webpage/oracle-l <//www.freelists.org/webpage/oracle-l> -- //www.freelists.org/webpage/oracle-l