oracle數(shù)據(jù)庫全備份和增量備份

1、1. 檢查數(shù)據(jù)庫模式:查看數(shù)據(jù)庫是否處于歸檔模式中 sqlplus /no log conn /as sysdba archive log list (假設(shè)為非歸檔，那么修改數(shù)據(jù)庫歸檔模式。startup mountalter database archivelogalter database ope n2. 連接到target數(shù)據(jù)庫命令：connect target / (c onnect也可要直接在 rman命令下用startup 可以連接至U target database.(rman file(nocatalog mode),control filetarget system/orac

2、leora10g,如果數(shù)據(jù)庫沒有起來，進行啟動數(shù)據(jù)庫con trol一邊連接到target數(shù)據(jù)庫，另外一邊連接到 中存儲rman的備份信息3. 用list backupset命令查看有沒有備份4. 常用備份命令：備份全庫：RMAN> backup database plus archivelog delete in put;備份全庫與控制文件、服務(wù)器參數(shù)文件與所有歸檔的重做日志，并刪除舊的歸檔日志備份表空間：RMAN> backup tablespace system plus archivelog delete in put; 備份指定表空間與歸檔的重做日志，并刪除舊的歸檔日志_

3、備份歸檔日志：RMAN> backup archivelog all delete in put;1.全庫備份備份數(shù)據(jù)文件中有數(shù)據(jù)的，有數(shù)據(jù)文件，控制文件，歸檔日志文件，spfile文件，不備份聯(lián)機重做日志文件或臨時文件RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON 控制文件自動備份RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 2 backup type to compressedbackupset;- 壓縮RMAN>CONFIGURE cha nnel DEVICE TYPE DISK for

4、mat 'D:APPrma nfull%s.bk'-備份的路徑RMAN>BACKUP DATABASE;全備份RMAN>list backup of database;-檢查備份信息RMAN>backup archivelog all delete in put;-備份歸檔日志并刪除歸檔日志RMAN> list backup of archivelog all;-檢查歸檔日志2.差異增量備份RMAN>backup in creme ntal level 0 database; -0級全備份RMAN>backup in creme ntal l

5、evel 2 database;-2級備份RMAN> list backup of database;-檢查備份信息Differential Incremental Backup: Examplen level backup of all blocks that have changed since the mott r*c*nt backup al l«v*l n or Iowog3.累積增量備份2c不做參照對象RMAN> backup in creme ntal level 2 cumulative database;Cumulative Incremental Ba

6、ckup: Examplen level backup which contains all blocks changed sinco the previous backup a level n - 1 or lower中心數(shù)據(jù)庫，RMAN一周備份方案0.星期天晚上1. 星期一晚上2. 星期二晚上3. 星期三晚上4. 星期四晚上5. 星期五晚上6. 星期六晚上-level 0 backup performed( -level 2 backup performed -level 2 backup performed -level 1 backup performed -level 2 backu

7、p performed -level 2 backup performed -level 2 backup performed全備份如果星期二需要恢復(fù)的話，只需要 0+1,如果星期四需要恢復(fù)的話，只需要 0+3,如果星期五需要恢復(fù)的話，只需要 0+3+4, 如果星期六需要恢復(fù)的話，只需要 0+3+4+5具體步驟：1.創(chuàng)立 0,1,2 級備份腳本 D:rman_bak_scriptrunallocate cha nnel c1 type disk;allocate cha nnel c2 type disk;allocate cha nnel c3 type disk;backup as com

8、pressed backupset in creme ntal level 0 tag 'db_level0' format 'H:RMAN_BAKlevel0_%u_%s_%p.bak：sql 'alter system archive log curre nt：backup as compressed backupset archivelog all format 'H:ARCHIVELOG_BAKarch0_%u_%s_%p' delete in put;delete no prompt obsolete;release cha nnel

9、c1;release cha nnel c2;release cha nnel c3;runallocate cha nnel c1 type disk;allocate cha nnel c2 type disk;allocate cha nnel c3 type disk;backup as compressed backupset in creme ntal level 1 tag 'db_level1' format 'H:RMAN_BAKlevel1_%u_%s_%p.bak'sql 'alter system archive log curr

10、e nt：backup as compressed backupsetarchivelog alldatabasedatabaseformat'H:ARCHIVELOG_BAKarch1_%u_%s_%p' delete in put;delete no prompt obsolete; release cha nnel c1;release cha nnel c2;release cha nnel c3;runallocate cha nnel cl type disk;allocate cha nnel c2 type disk;allocate cha nnel c3 t

11、ype disk;backup as compressed backupset in creme ntal level 2 tag 'db_level2' database format 'H:RMAN_BAKlevel2_%u_%s_%p.bak：sql 'alter system archive log curre nt：backup as compressed backupsetarchivelog all format'H:ARCHIVELOG_BAKarch2_%u_%s_%p' delete in put;delete no prom

12、pt obsolete;release cha nnel c1;release cha nnel c2;release cha nnel c3;2.創(chuàng)立周日至周六執(zhí)行的批處理文件MonSun星期天 rma n target / logD:rman_bak_scriptSu nrma nlog_Su n%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rma n_bak_scriptrma n_levelO d星期一 rma n target / logD:rman_bak_scriptM onrma nlog_Mo n%date:0,4%_%date

13、:5,2%_%date:8,2%.txt cmdfile=D:rma n_bak_scriptrma n_level2 d星期二 rma n target / logD:rman_bak_scriptTuerma nlog_Tue%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rma n_bak_scriptrma n_level2 d星期三 rma n target / logD:rman_bak_scriptWe nrma nlog_We n%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rma n_bak_scriptrma n_level1 d星期四 rma n target / logD:rman_bak_scriptThurma nlog_Thu%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rma n_bak_scriptrma n_level2 d星期五 rma n target / logD:rman_bak_scriptFrirma nlog_Fri%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rma n_bak_scriptrma