linux下 oracle rman简单备份&上传ftp&逻辑备份

-- rman
cd /home/oracle/scripts/
vim arcfull.sh
#!/bin/sh  
  
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=XXX
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
days=7
BAKUPTIME=`date +%Y_%m_%d`
rman target / nocatalog cmdfile /home/oracle/scripts/archfullback.sh  log  /home/oracle/scripts/$BAKUPTIME.log


find /home/oracle/scripts  -type f -name "*.log" -mtime +$days -exec rm -rf {} \;

--其中archfullback.sh
RUN {
 DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK;;
 crosscheck archivelog all;
 delete noprompt expired archivelog all;
 crosscheck backup;
 delete noprompt expired backup;
 allocate channel c1 type disk;
 allocate channel c2 type disk;
 backup database format 'db_%s_%p_%t' plus archivelog delete all input format 'arch_%s_%p_%t';
 release channel c1;
 release channel c2;
 }
exit

--ftpback.sh
#!/bin/bash
TODAY=`date +%Y_%m_%d`
cd XXX
tar -zcvf arcfull_%TODAY.tar.gz *
ftp -n  192.168.XXX.XXX << EOF
user user password
bin
lcd XXX
prompt
mput *.tar.gz
bye
EOF

-- 最后添加任务
crontab -e 
0 1 * * * /home/oracle/scripts/arcfull.sh


-- 附expdp备份
#!/bin/sh  
  
export ORACLE_BASE=/u01/app/oracle 
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=XXX
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin  
  
export DATA_DIR=/ora02/sdd2/expdpdir
export LOGS_DIR=/ora02/sdd2/expdpdir
export DELTIME=`date -d "10 days ago" +%Y%m%d`  
export BAKUPTIME=`date +%Y%m%d%H%M%S`  
  
  
echo "Starting bakup..."  
echo "Bakup file path $DATA_DIR/$BAKUPTIME.dmp"  
expdp system/*** directory=dump_dir full=y dumpfile=$BAKUPTIME.dmp  logfile=$BAKUPTIME.log

echo "Delete the file bakup before 10 days..."  
rm -rf $DATA_DIR/$DELTIME*.dmp  
rm -rf $LOGS_DIR/$DELTIME*.log  

RAC的一个参考备份例子：

#节点1：
#/bin/bash
source /home/oracle/.bash_profile
backtime=`date +%Y%m%d`
rman target /  log=/rmanbak/log/node1_backupall_$backtime.log <<EOF
allocate channel for maintenance type disk;
run{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup database format '/rmanbak/datafile/rac1_%d_%T_%U';
backup archivelog all format '/rmanbak/datafile/rac1_arch_%t_%s_%c' delete input;
report obsolete;
delete force noprompt  obsolete device type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt expired backup;
release channel ch1;
release channel ch2;
}
EOF
echo "backup complete!"
scp /rmanbak/log/node1_backupall_$backtime.log oracle@rac2:/rmanbak/log/
exit

#节点2
#/bin/bash
source /home/oracle/.bash_profile
backtime=`date +%Y%m%d`
if [ -f /rmanbak/log/node1_backupall_$backtime.log ]
then
echo "node1 backup have been success!"
exit
else
echo "node1 backup have been filed,start node2 backup!"
fi
rman target /  log=/rmanbak/log/node2_backupall_$backtime.log <<EOF
allocate channel for maintenance type disk;
run{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup database format '/rmanbak/datafile/rac2_%d_%T_%U';
backup archivelog all format '/rmanbak/datafile/rac2_arch_%t_%s_%c' delete input;
report obsolete;
delete force noprompt  obsolete device type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt expired backup;
release channel ch1;
release channel ch2;
}
EOF
echo "backup complete!"
exit