Re: RMAN/DG - delete *ONLY* archive logs "already shipped to the standby 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"
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l