Just wanted to ask a question on Dataguard. We have a scenario where we have a Dataguard setup on 2 Windows 2003 Boxes and have had issues with the logs not being shipped across. We traced this down with to the logs filling up disk space. Now this db is about 500gb and we created the standby using RMAN. We havent taken backups with RMAN after the initial creation of the standby due to space issues. Can we use RMAN retention policy (or anything similar) to delete archived redo logs from disk after they have been applied to the standby db from the the primary and standby site?
You can use RMAN to backup your primary archive logs and delete input. Also , you can schedule a cron job to check the max logseq on standby and delete the logs that are applied.RMAN is very powerful ....
If You are looking for a script, please IM me.
My Private World on the Web !