Script to delete archive logs in Oracle
Script to delete archive logs in Oracle
Normally we delete archive logs as soon as we take archive backup by using script.
Due to any reason ,If deletion is not done as mentioned above , then we delete archives separately.
Below are the different situations:
Delete archive logs if they are expired / obsolete.
Delete all archives completed before a particular time.
Delete archive logs after applying on standby site.
For all the above conditions, we can take care in the script.
Main script :
Name: deleteArchivelogs.sh
| SCRIPT_DIR=/u01/app/oracle/scripts/rman
CMDF=${SCRIPT_DIR}/deleteArchivelogs.rman LOG=${SCRIPT_DIR}/deleteArchivelogs.log . $HOME/.bash_profile |
Parameters passed:
None
Calling script /sub script
#script name: deleteArchivelogs.rman
| run { CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; crosscheck archivelog all; delete noprompt expired backup; delete noprompt expired archivelog all; delete noprompt obsolete; delete noprompt archivelog all completed before ‘sysdate – 1/24’; } |
How to run Manually in the background?
$sh deleteArchivelogs.sh &
Parameters Passed:
None
crontab entry :
| 10 19 * * * /u00/app/oracle/scripts/rman/deleteArchivelogs.sh > /u01/app/oracle/scripts/rman/deleteArchivelogs.log |