一个rman备份全部内容.docx

rman备份:full、0-level、1-level、2-level及自动删除2天前归档备份0.crontab设置每月30日2点做全备份，每星期日12点做0级备份，每星期三1点做1级备份，其他每天2点做2级备份。oraclebxdb $ crontab -l0 2 30 * * /oradata/full.shoraclebxdb $ crontab -l0 0 * * 0 /oradata/0level.sh0 1 * * 3 /oradata/1level.sh0 2 * * 1,2,4,5,6 /oradata/2level.sh1.全备份(0备份与全备份的区别是全备份不能用增量备份恢复，而0级备份则可以)(文件名：full.sh)#mkdir /oradata/bb test program is yes or no runningexport ORACLE_BASE=/home/oracleexport ORACLE_HOME=/home/oracle/OraHome1export ORACLE_SID=orclexport NLS_LANG=AMERICAN_AMERICA.UTF8#export PATH=$PATH:$ORACLE_HOME/binecho -start-;date/oradata/aa.txt#backup start#mkdir /oradata/cc test program is yes or no running$ORACLE_HOME/bin/rman /oradata/aa.txt#backup start#mkdir /oradata/cc test program is yes or no running$ORACLE_HOME/bin/rman /oradata/aa.txt#backup start#mkdir /oradata/cc test program is yes or no running$ORACLE_HOME/bin/rman /oradata/aa.txt#backup start#mkdir /oradata/cc test program is yes or no running$ORACLE_HOME/bin/rman EOFconnect target / ;allocate channel c1 type disk;allocate channel c2 type disk;allocate channel c3 type disk;backup incremental level 1 tag db1 format /oradata/2levelbak/db2%u_%s_%p database skip readonly;sql alter system archive log current;backup fileaperset 3 format /oradata/2levelbak/db2%u_%s_%p archivelog all delete input; #这样不能删除归档日志backup fileaperset 3 format /oradata/2levelbak/db2%u_%s_%p archivelog from time sysdate - 2 all delete input; #这句话也不可以自动删除2天前的归档日志;delete noprompt archivelog until time sysdate - 2 all ; #这句话才可以删除,注意sysdate-2是从现在的日期和时间开始进行删除,注意时间.release channel c1;release channel c2;release channel c3;exit;EOFecho -end-;date-若不小心执行了以上命令,系统开始运行备份,但这个备份过程在前台找不到,是在后台处理的,因在上班期间,备份影响系统性能,想将正在运行的备份终止,此时方法是以sys用户登陆,在toad中使用命令:select * from v$