-
Removing Archive logs in Standby
Hi,
We have an Oracle data guard implemented. In the server where standby db is hosted, Archive logs is filling up the disk space.
Im wondering whether I can delete the old archive logs (like archive logs older than 30 days or so)
Is there any oracle views which help in assessing which archive logs can be safely removed from standby server.
I appreciate any suggestions.
Thanks,
VG
-
As soon as it is applied, you can whack it. I do a simple find -mtime +1 to keep mine in check.
Jeff Hunter
-
Removing Archive logs in Standby
Thanks Jeff for the reply..
Is there any V$ view in the standby db side, to verify that all the old archive logs are applied and safe to delete.
Thanks,
VG
-
archive log list
-
Originally posted by kris123
archive log list
no no and NO
http://download-west.oracle.com/docs...htm#SBYDB00555
Last edited by davey23uk; 05-11-2005 at 02:31 PM.
-
V$ARCHIVED_LOG.APPLIED will tell you wether the archlog has been applied to standby database or not. Once it has been applied, it is no longer needed for managed standby recovery.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Re: Removing Archive logs in Standby
Originally posted by vg
Hi,
We have an Oracle data guard implemented. In the server where standby db is hosted, Archive logs is filling up the disk space.
Im wondering whether I can delete the old archive logs (like archive logs older than 30 days or so)
Is there any oracle views which help in assessing which archive logs can be safely removed from standby server.
I appreciate any suggestions.
Thanks,
VG
use rman to manage the logs on the standby and the sysdate-X magic
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|