RE: RMAN/DG - delete *ONLY* archive logs "already shipped to thestandby DataGuard database"?

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel Garry Sent: Tuesday, January 11, 2005 5:04 PM
To: oracle-l_at_freelists.org
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

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