Archive Deletion script After Logs Shipped to Physical Standby Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Archive Deletion script After Logs Shipped to Physical Standby Database

  1. #1
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184

    Archive Deletion script After Logs Shipped to Physical Standby Database

    Dear All,

    Application: SAP R/3
    DB: Oracle 10gR2 (2 Node RAC) on RHEL4
    Standby: Single Instance.

    I do not use RMAN for backing up my database. Backups are managed by BRTools .... thats a constraint.

    I am facing a problem, the archive logs are heavily generated on primary instances and there is a OS script which executes every four hours and backs up the archives and deletes them thru' BRTools. Now the problem is with limited bandwidth not all archive logs are shipped to the standby location and hence a gap is created almost every other day since archive logs not available on Primary location.

    I don't know if anyone faced such a problem and anyone has a script which can find the archive logs shipped to the standby location, then backup the archivelogs and delete them from primary location.

    RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY ... is what i cannot use due to limitations of not using RMAN ... so only OS and sqlplus is what i can use..

    Any help?

    Regards,
    Paresh

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    check the standby to see what has been shipped then v$archived_log

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    What about using the find command to delete old archive logs? We keep two days worth.

    find $ORALOG/archive -mtime +1 | xargs rm -rf
    this space intentionally left blank

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