oracle数据库全备份和增量备份

检查数据库模式：sqlplus/nologconn/assysdbaarchiveloglist（查看数据库是否处于归档模式中）若为非归档,则修改数据库归档模式。startupmountalterdatabasearchivelogalterdatabaseopen连接到target数据库命令：connecttarget/（connecttargetsystem/oracle@ora10g,如果数据库没有起来，也可要直接在rman命令下用startup进行启动数据库）可以连接到targetdatabase.（rman一边连接到target数据库，另外一边连接到controlfile（nocatalogmode）,controlfile中存储rman的备份信息）用listbackupset命令查看有没有备份常用备份命令：备份全库：RMAN>backupdatabaseplusarchivelogdeleteinput;（备份全库及控制文件、服务器参数文件与所有归档的重做日志，并删除旧的归档日志）备份表空间：RMAN>backuptablespacesystemplusarchivelogdeleteinput; （备份指定表空间及归档的重做日志，并删除旧的归档日志）_备份归档日志：RMAN>backuparchivelogalldeleteinput;全库备份（备份数据文件中有数据的，有数据文件，控制文件，归档日志文件,spfile文件，不备份联机重做日志文件或临时文件）RMAN>CONFIGURECONTROLFILEAUTOBACKUPON;—控制文件自动备份RMAN>CONFIGUREDEVICETYPEDISKPARALLELISM2backuptypetocompressedbackupset;一压缩RMAN>CONFIGUREchannelDEVICETYPEDISKformat'D:\APP\rman\full_%s.bk';—备份的路径RMAN>BACKUPDATABASE;—全备份RMAN>listbackupofdatabase;—检查备份信息RMAN>backuparchivelogalldeleteinput;一备份归档日志并删除归档日志RMAN>listbackupofarchivelogall;一检查归档日志差异增量备份RMAN>backupincrementallevel0database;—0级全备份RMAN>backupincrementallevel2database;--2级备份

RMAN〉listbackupofdatabase;―检查备份信息DifferentialIncrementalBackup:ExampleRMAN〉listbackupofdatabase;―检查备份信息DifferentialIncrementalBackup:Examplenlev^lbackupofallblocksthathavechangedsincethemMtrocwjlbBckunntlov«lnorlowor.L<?v«40Lwq）0Mon-3.累积增量备份（2c不做参照对象）RMAN>backupincrementallevel2cumulativedatabase;CumulativeIncrementalBackup:Examplenlevelbackupwht匚林containsallblock.5changedsincetheprcvlou*backupatatevcln-1orlowerL«vd*UvalOi~i~~I~:i-H——\―~iLvl 0 2 2C 1 2 2C2C 0QaySunMonTwo WffdlThuFriSatSun

中心数据库,RMAN—周备份方案0.星期天晚上1.星期一晚上2.星期二晚上3.星期三晚上0.星期天晚上1.星期一晚上2.星期二晚上3.星期三晚上4.星期四晚上5.星期五晚上6.星期六晚上-level2backupperformed-level2backupperformed-level1backupperformed-level2backupperformed-level2backupperformed-level2backupperformed如果星期二需要恢复的话，只需要0+1,如果星期四需要恢复的话，只需要0+3,如果星期五需要恢复的话，只需要0+3+4,如果星期六需要恢复的话，只需要0+3+4+5具体步骤：1.创建0,1,2级备份脚本D:\rman_bak_scriptrun{allocatechannelc1typedisk;allocatechannelc2typedisk;allocatechannelc3typedisk;backupascompressedbackupsetincrementallevel0tag'db_level0'databaseformat'H:\RMAN_BAK\level0_%u_%s_%p.bak';sql'altersystemarchivelogcurrent';backupascompressedbackupsetarchivelogallformat'H:\ARCHIVELOG_BAK\arch0_%u_%s_%p'deleteinput;deletenopromptobsolete;releasechannelc1;releasechannelc2;releasechannelc3;}run{allocatechannelc1typedisk;allocatechannelc2typedisk;allocatechannelc3typedisk;backupascompressedbackupsetincrementallevel1tag'db_level1'databaseformat'H:\RMAN_BAK\level1_%u_%s_%p.bak';sql'altersystemarchivelogcurrent';backupascompressedbackupsetarchivelogallformat'H:\ARCHIVELOG_BAK\arch1_%u_%s_%p'deleteinput;

deletenopromptobsolete;releasechannelc1;releasechannelc2;releasechannelc3;}run{allocatechannelc1typedisk;allocatechannelc2typedisk;allocatechannelc3typedisk;backupascompressedbackupsetincrementallevel2tag'db_level2'databaseformat'H:\RMAN_BAK\level2_%u_%s_%p.bak';sql'altersystemarchivelogcurrent';backupascompressedbackupsetarchivelogallformat'H:\ARCHIVELOG_BAK\arch2_%u_%s_%p'deleteinput;deletenopromptobsolete;releasechannelc1;releasechannelc2;releasechannelc3;}创建周日至周六执行的批处理文件D:\rman_bak_script\Mon・・・Sun星期天rmantarget/logD:\rman_bak_script\Sun\rmanlog_Sun%date:~0,4%_%date:~5,2%_%date:~8,2%.txtcmdfile=D:\rman_bak_script\rman_level0.cmd星期一rmantarget/logD:\rman_bak_script\Mon\rmanlog_Mon%date:~0,4%_%date:~5,2%_%date:~8,2%.txtcmdfile=D:\rman_bak_script\rman_level2.cmd星期二rmantarget/logD:\rman_bak_script\Tue\rmanlog_Tue%date:~0,4%_%date:~5,2%_%date:~8,2%.txtcmdfile=D:\rman_bak_script\rman_level2.cmd星期三rmantarget/logD:\rman_bak_script\Wen\rmanlog_Wen%date:~0,4%_%date:~5,2%_%date:~8,2%.txtcmdfile=D:\rman_bak_script\rman_level1.cmd星期四rmantarget/log星期四rmantarget/logD:\rman_bak_script\Thu\rmanlog_Thu%date:~0,4%_%date:~5,2%_%date:~8,2%.txtcmdfile=D:\rman_bak_script\rman_level2.cmd星期五rmantarget/logD:\rman_bak_script\Fri\rmanlog_Fri%date:~0,4%_%date:~5,2%_%date:~8,2%.txtcmdfile=D:\rman_bak_script\rman_level2.cmd星期六rmantarget/logD:\rman_bak_script\Sat\rmanlog_Sat%date:~0,4%_%date:~5,2%_%date:~8,2%.txtcmdfile=D:\rman_bak_script\rm