Dataguard Archived Logs retention policy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Dataguard Archived Logs retention policy

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Dataguard Archived Logs retention policy

    Hi all,

    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?

    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    where do you want to delete the logs from - the standby or the primary

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    Want to delete logs from both sites - on standby after the logs have been applied. We are running on maximum performance mode (the default) and its a physical standby rather than a logical one.

    Thanks in advance

  4. #4
    Join Date
    Dec 2001
    Posts
    337
    Any ideas on this? Thanks in advance

  5. #5
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    41
    Hi
    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.
    Milind
    -----------------------------
    www.milinds.com
    My Private World on the Web !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width