oracle 简单备份

来源:互联网 发布:linux创建目录 ls 编辑:程序博客网 时间:2024/05/01 17:18
[root@iZ2379qsb0hZ ~]# cat archdel.sh 
find /u01/11g/admin/kldb/adump -ctime +5 -exec rm -rf {} \;

find /u01/11g/diag/rdbms/kldb/kldb/trace -ctime +5 -exec rm -rf {} \;[root@iZ2379qsb0hZ ~]# cat logicalbak.sh 
#!/bin/sh
find /home/oracle/logic_bak/dmpbak/*  -mtime +1 -exec rm {} \;
. /home/oracle/.bash_profile
#backupPath='/home/oracle/logic_bak/dmpbak/'
KlformBackupFile='Klform_'`date +%Y_%m_%d_%H_%M_%S`'.dmp'
KlformBackupLogFile='Klform_'`date +%Y_%m_%d_%H_%M_%S`'.log'
$ORACLE_HOME/bin/exp klform/klform file=/home/oracle/logic_bak/dmpbak/$KlformBackupFile log=/home/oracle/logic_bak/dmpbak/$KlformBackupLogFile owner=klform

0 0