学习目标

学会Oracle自动job备份方法；
能正常备份Oracle实例中schema;
熟悉Oracle备份工具及备份脚本。

业务场景

解决生产环境Oracle备份问题；

学习内容

Linux逻辑备份（expdp脚本备份）：

创建导出脚本expdp.sh ，给脚本授予775权限

编辑导出脚本内容expdp.sh:
vi expdp.sh :

脚本内容添加如下：

echo "begin_dbaflag `date +%Y-%m-%d` `date +%H:%M:%S`"

cd /backup/expdp
Dat=`date +%Y%m%d`
dat=`date +%Y-%m-%d-%H-%M-%S`
day=`date +%w`

if [ -e $day ]
then rm -rf $day
fi
mkdir $day;

sql (){
sql="select current_scn from v\$database;"
sqlplus /nolog <<EOF
conn / as sysdba;
set long 999999999
$sql
EOF
}
cd /backup/expdp/$day
sql >sql.log 2>&1
scn=`cat sql.log |egrep -v "Version|Release|Copyright|SQL|Disconnected|OLAP|Application|CURRENT_SCN|-"|sed '/^$/d'|awk '{print $1}'`
echo ${scn}

expdp eascs/eascs dumpfile=expbak:eascs-${Dat}.dmp flashback_scn=${scn} logfile=expbak:eascs-${Dat}.log cluster=n exclude=table:\"like \'VT%\'\"

cd /backup/expdp/
mv *.dmp $day;
mv *.log $day;

echo -e "\n end_dbaflag `date +%Y-%m-%d` `date +%H:%M:%S`"

添加job自动执行任务：

2.Linux rman 全量备份（rman脚本备份，需要Oracle实例开启归档）
Oracle开启归档参考：https://vip.kingdee.com/school/310707883333732608?productLineId=1
创建rman备份存入系统目录，并授予775权限：

创建rman备份脚本rman.sh ，给脚本授予775权限

编辑rman.sh脚本内容

Rman脚本内容添加如下：

echo "begin_dbaflag `date +%Y-%m-%d` `date +%H:%M:%S`"

cd /backup/rmanbackup
Dat=`date +%Y%m%d`
dat=`date +%Y-%m-%d-%H-%M-%S`
day=`date +%w`

if [ -e $day ]
then rm -rf $day
fi
mkdir $day;
cd $day
rman target system/system log="/backup/rmanbackup/$day/rmanback$dat.log" <<EOF
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/rmanbackup/$day/control%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

sql 'alter system checkpoint';

crosscheck archivelog all;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
delete expired archivelog all;
delete noprompt archivelog until time 'sysdate-7';

run {
allocate channel c1 type disk maxpiecesize 4096M rate 20M;
allocate channel c2 type disk maxpiecesize 4096M rate 20M;
backup as compressed backupset format '/backup/rmanbackup/$day/%T_%d_%s_%p.dat' tag 'full_dat' database plus archivelog;
backup as compressed backupset format '/backup/rmanbackup/$day/%T_%d_%s_%p.ora' tag 'full_ora' spfile;
backup as compressed backupset format '/backup/rmanbackup/$day/%T_%d_%s_%p.ctl' tag 'full_ctl' current controlfile;
backup as compressed backupset format '/backup/rmanbackup/$day/AL_%d_%T_S%s_P%p' tag 'all_arc' archivelog all delete input;
release channel c1;
release channel c2;
}
EOF

echo -e "\n end_dbaflag `date +%Y-%m-%d` `date +%H:%M:%S`"

添加job自动执行任务：

Oracle 自动备份job方法

恭喜您！