linux平台oracle自动备份



1.添加一个crontab的自动任务，每天23:30分执行一个备份脚本backup.txt

crontab -e
 
30 23 * * *  sh /xebest/u01/backup.txt

2. 编辑backup.txt脚本，内容如下

#!/bin/sh

export ORACLE_BASE=/xebest/u01/app/oracle
export ORACLE_HOME=/xebest/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=xedb
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export PATH=$ORACLE_HOME/bin:$PATH
PATH=$PATH:$HOME/bin
export PATH

rman target / nocatalog log /tmp/rman_full.log append << EOF

run
{allocate channel c1 type disk;
allocate channel c2 type disk;
backup  filesperset 2 database format '/xebest/u01/backup/full_data_%d_%T_%s_%p';
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
backup archivelog all format '/xebest/u01/backup/arch_%d_%T_%s_%p' delete input;
backup current controlfile format '/xebest/u01/backup/ctl_%d_%T_%s_%p';
}

EOF

rman target / nocatalog log /tmp/rman_delete.log append << EOF

allocate channel  for maintenance type disk;
allocate channel  for maintenance type disk; 
crosscheck backup; 
crosscheck archivelog all; 
crosscheck copy;    
delete noprompt expired backup device type disk;
delete noprompt obsolete device type disk;
delete noprompt expired archivelog all device type disk;

EOF

3. 定期查看 /tmp/rman_full.log 和 /tmp/rman_delete.log， 看看日志有没有报错信息！