Re: RMAN/DG - delete *ONLY* archive logs "already shipped to the standby DataGuard database"?

  • From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
  • To: CMarquez@xxxxxxxx
  • Date: Mon, 10 Jan 2005 23:07:27 +0100

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>'

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
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/, 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) -
> "Oracle Monitoring & Alerting Solution"
> --
> //


Other related posts: