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
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
Other related posts:
