《设置定时自动清理归档日志脚本 》

fteair

1. root用户下
   
2. 
   
3. [root@localhost ~]# mkdir /nstg
   
4. [root@localhost ~]# cd /nstg/
   
5. [root@localhost nstg]# mkdir bin log tmp
   
6. [root@localhost nstg]# chown -R oracle:oinstall  /nstg
   
7. [root@localhost nstg]# su - oracle
   
8. [oracle@localhost ~]$ cd /nstg/bin
   
9. 
   
10. vi del_arch.sh
    
11. #!/bin/bash
    
12. echo "----------------------------------------`date`---------------------------------------"
    
13. source ~/.bash_profile
    
14. rman target / <<EOF
    
15. crosscheck archivelog all;
    
16. delete noprompt expired archivelog all;
    
17. delete noprompt archivelog all completed before 'sysdate-7';
    
18. EOF
    
19. echo -e "\n"
    
20. echo "------------------------------------ FINISHED ------------------------------------"
    
21. 
    
22. [oracle@localhost bin]$ crontab -e
    
23. 
    
24. * 1 * * *  nstg/bin/del_arc.sh

复制代码

caixuqad

张兴康

caixuqad

fteair