这篇文章主要介绍“用Oracle RMAN备份的方法是什么”,在日常操作中,相信很多人在用Oracle RMAN备份的方法是什么问题上存在疑惑,小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答”用Oracle RMAN备份的方法是什么”的疑惑有所帮助!接下来,请跟着小编一起来学习吧!

数据库周期:

周一0级备份,周二、周三2级备份,周四1级备份,周五、六、日2级备份。

归档备份周期:

每小时备份一次

脚本如下:

###启动归档###

[root@cjcos01~]#mkdir/rman/{db,arch}-p[root@cjcos01~]#chownoracle.oinstall/rman-R[root@cjcos01~]#su-oracle[oracle@cjcos01~]$sqlplus/assysdbaSQL>altersystemsetlog_archive_dest_1='location=/rman/arch';SQL>altersystemsetlog_archive_format="cjcpdb_%t_%s_%r.arc"scope=spfile;SQL>shutdownimmediate;SQL>startupmount;SQL>alterdatabasearchivelog;SQL>alterdatabaseopen;SQL>archiveloglist;

###创建测试数据###

SQL>conncjc/***SQL>CREATEORREPLACEPROCEDUREtest_proisbeginforiin1..10loopinsertintot1values(i,to_char(sysdate,'yyyy/mm/ddhh34:mi:ss'));commit;endloop;end;/

周一:0级备份

###0_rmanbak.shbegin###exportNLS_DATE_FORMAT='yyyy-mm-ddhh34:mi:ss'exportORACLE_SID=cjcdb01rmantarget/log=/rman/db/0_rmanbak.log<<EOFrun{allocatechannelch2typediskmaxpiecesize1000M;allocatechannelch3typediskmaxpiecesize1000M;backupincrementallevel=0filesperset=32format'/rman/db/lev0_%d_%T_%U.bak'skipinaccessibledatabaseincludecurrentcontrolfiletag'0_rmanbak_cjcdb';releasechannelch2;releasechannelch3;}EOFexit###0_rmanbak.shend###

周二、三:2级别备份

###2_rmanbak.shbegin###exportNLS_DATE_FORMAT='yyyy-mm-ddhh34:mi:ss'exportORACLE_SID=cjcdb01rmantarget/log=/rman/db/2_rmanbak.log<<EOFrun{allocatechannelch2typediskmaxpiecesize1000M;allocatechannelch3typediskmaxpiecesize1000M;backupincrementallevel=2filesperset=32format'/rman/db/lev2_%d_%T_%U.bak'skipinaccessibledatabaseincludecurrentcontrolfiletag'2_rmanbak_cjcdb';releasechannelch2;releasechannelch3;}EOFexit###2_rmanbak.shend###

周四:1级备份

###1_rmanbak.shbegin###exportNLS_DATE_FORMAT='yyyy-mm-ddhh34:mi:ss'exportORACLE_SID=cjcdb01rmantarget/log=/rman/db/1_rmanbak.log<<EOFrun{allocatechannelch2typediskmaxpiecesize1000M;allocatechannelch3typediskmaxpiecesize1000M;backupincrementallevel=1filesperset=32format'/rman/db/lev1_%d_%T_%U.bak'skipinaccessibledatabaseincludecurrentcontrolfiletag'1_rmanbak_cjcdb';releasechannelch2;releasechannelch3;}EOFexit###1_rmanbak.shend###

周五、六、日:2级备份

###2_rmanbak.shbegin###exportNLS_DATE_FORMAT='yyyy-mm-ddhh34:mi:ss'exportORACLE_SID=cjcdb01rmantarget/log=/rman/db/2_rmanbak.log<<EOFrun{allocatechannelch2typediskmaxpiecesize1000M;allocatechannelch3typediskmaxpiecesize1000M;backupincrementallevel=2filesperset=32format'/rman/db/lev2_%d_%T_%U.bak'skipinaccessibledatabaseincludecurrentcontrolfiletag'2_rmanbak_cjcdb';releasechannelch2;releasechannelch3;}EOFexit###2_rmanbak.shend###

归档备份:每小时备份一次

###arch_rmanbak.shbegin###exportNLS_DATE_FORMAT='yyyy-mm-ddhh34:mi:ss'exportORACLE_SID=cjcdb01rmantarget/log=/rman/db/arch_rmanbak.log<<EOFrun{allocatechannelch2typediskmaxpiecesize1000M;allocatechannelch3typediskmaxpiecesize1000M;sql"altersystemarchivelogcurrent";backupfilesperset=32format'/rman/db/arch_%d_%T_%U.bak'skipinaccessiblearchivelogalldeleteinputtag'arch_cjcdb';backupformat='ctl_%d_%T_%U.ctl'currentcontrolfile;releasechannelch2;releasechannelch3;}EOFexit###arch_rmanbak.shend###

到此,关于“用Oracle RMAN备份的方法是什么”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注亿速云网站,小编会继续努力为大家带来更多实用的文章!