RE: RMAN/DG - delete *ONLY* archive logs "already shipped to thestandby DataGuard database"?
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: "Carel-Jan Engel" <cjpengel.dbalert@xxxxxxxxx>
- Date: Mon, 10 Jan 2005 17:54:22 -0500
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
Other related posts:
