Set the script to automatically clear archived logs at regular intervals.

Set the script to automatically clear archived logs at regular intervals.

Root User

[Root @ localhost ~] # Mkdir/nstg
[Root @ localhost ~] # Cd/nstg/
[Root @ localhost nstg] # mkdir bin log tmp
[Root @ localhost nstg] # chown-R oracle: oinstall/nstg
[Root @ localhost nstg] # su-oracle
[Oracle @ localhost ~] $ Cd/nstg/bin

Vi del_arch.sh
#! /Bin/bash
Echo "---------------------------------------- 'date '---------------------------------------"
Source ~ /. Bash_profile
Rman target/<EOF
Crosscheck archivelog all;
Delete noprompt expired archivelog all;
Delete noprompt archivelog all completed before 'sysdate-7 ';
EOF
Echo-e "\ n"
Echo "-------------------------------------- FINISHED ------------------------------------"

[Oracle @ localhost bin] $ crontab-e

* 1 *** nstg/bin/del_arc.sh