[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
0 0 1 * * ?
每天1点执行
最后于 2022-8-16
被admin编辑
,原因: 添加执行命令