RE: RMAN/DG - delete *ONLY* archive logs "already shipped to thestandby DataGuard database"?
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: <joelgarry@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Jan 2005 18:13:47 -0500
Joel,
>>Sure you want to do that?
Absolutely.
I can't say I don't agree with you, I do, but that is another issue;
"can't apply logs already shipped".
I agree, best to delete after the whole process is complete...applied to
the standby,=20
but my goal is; a good backup, an empty (primary) archive log dir and
not "create" a gap while doing these two.
If my standby is NOT accepting or applying "shipped" logs should that be
there *rule* for not backing up and/or not deleting from the primary?
As soon as late one night my primary archive log dir is full and db
halts...that rule is out, right?
Again I agree, but not in one script. Backup is backup...standby
consistency is another script / logic / code.
>>I habitually keep days worth of archives after rman/backup.
I will probably do the same, but "log age" is not a factor of having
been shipped...or applied...as we found out the hard way also.
>>never knows what exactly the standby will want
Ahhh, that is why we do backups...could agree more.
>>I know one fellow opens his standby every hour to be sure he can.
>>I'm seeing about one corrupted log per month at one customer, _after_
he upgraded network.
Interesting.
Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joel Garry
Sent: Tuesday, January 11, 2005 5:04 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN/DG - delete *ONLY* archive logs "already shipped to
thestandby DataGuard database"?
Marquez, Chris wrote:
>BUT delete *ONLY* archive logs "already shipped to the standby
DataGuard
>database".
Sure you want to do that? What if it can't apply logs already shipped?
When you write your own script, be sure to put in some slop so you don't
delete too many, or else some intelligence so you only delete those that
have been applied and shown to work, as exemplified by being able to
open R/O the standby.
Thanks to various bugs I've run into in 8i/early 9, I habitually keep
days worth of archives after rman/backup. One just never knows what
exactly the standby will want in various circumstances, and not having
an old enough one can be not-fun, and you can't know if any one is good
until it is successfully applied. Maybe it's all fixed now, I wouldn't
know. I know one fellow opens his standby every hour to be sure he can.
I'm seeing about one corrupted log per month at one customer, _after_ he
upgraded network.
Joel Garry
http://www.garry.to
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
