
1、配置了策略如下
2、我的理解应该是备份只是保留当前备份出来的文件,并且在1天后过期删除。
但是过期1天是怎么判断的,是中午12点还是凌晨0点生效。我这里是中午12点删除所有的备份记录。在13点开始执行备份的时候系统提示失败;
3、备份脚本设置如下:
“----------------------------------------date
---------------------------------------”
source ~/.bash_profile
export FILE=“mweasdbbaklog-”(date +%Y%m%d%H)"-LEVEL1.log"
rman target / log /home/oracle/dbincbak/{FILE}<<EOF
run{
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
sql ‘alter system checkpoint’;
sql ‘alter system switch logfile’;
sql ‘alter system archive log current’;
backup incremental level=1 CUMULATIVE database tag=mwdb_bk_level1 format ‘/home/oracle/dbincbak/mwdbbak_level1c_%d_%T_%s_%p.bak’ include current controlfile;
sql ‘alter system archive log current’;
backup archivelog all format ‘/home/oracle/dbincbak/dbArchLog_level1_%d_%T_%s_%p.bak’;
backup current controlfile format’/home/oracle/dbincbak/%d_%T_%s_%p.control.bak’;
backup spfile format ‘/home/oracle/dbincbak/mwdbL1_SPFILE_%d_%T_%s_%p.bak’;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
release channel c1;
release channel c2;
release channel c3;
}
EOF
exit;
4、定时运行文件
唯一值得怀疑的文件
如上这些没有找出来设置的逻辑
