Archive Deletion script After Logs Shipped to Physical Standby Database
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..
check the standby to see what has been shipped then v$archived_log
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
Click Here to Expand Forum to Full Width