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

1、1. 檢查數(shù)據(jù)庫(kù)模式： sqlplus /nolog conn /as sysdba archive log list (查看數(shù)據(jù)庫(kù)是否處于歸檔模式中) 若為非歸檔,則修改數(shù)據(jù)庫(kù)歸檔模式。 startup mount alter database archivelog alter database open2.連接到target數(shù)據(jù)庫(kù)命令： connect target / (connect target system/oracleora10g,如果數(shù)據(jù)庫(kù)沒(méi)有起來(lái)，也可要直接在rman命令下用startup進(jìn)行啟動(dòng)數(shù)據(jù)庫(kù)) 可以連接到target database.(rman 一邊連接到tar

2、get數(shù)據(jù)庫(kù)，另外一邊連接到control file(nocatalog mode),control file 中存儲(chǔ)rman 的備份信息)3.用list backupset 命令查看有沒(méi)有備份4. 常用備份命令： 備份全庫(kù)：RMAN> backup database plus archivelog delete input; (備份全庫(kù)及控制文件、服務(wù)器參數(shù)文件與所有歸檔的重做日志，并刪除舊的歸檔日志)備份表空間：RMAN> backup tablespace system plus archivelog delete input; (備份指定表空間及歸檔的重做日志，并刪除舊的歸

3、檔日志)_備份歸檔日志：RMAN> backup archivelog all delete input;1. 全庫(kù)備份（備份數(shù)據(jù)文件中有數(shù)據(jù)的，有數(shù)據(jù)文件，控制文件，歸檔日志文件，spfile文件，不備份聯(lián)機(jī)重做日志文件或臨時(shí)文件）RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; -控制文件自動(dòng)備份RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 backup type to compressed backupset; -壓縮RMAN> CONFIGURE channel DEVICE T

4、YPE DISK format 'D:APPrmanfull_%s.bk' -備份的路徑RMAN>BACKUP DATABASE; -全備份RMAN>list backup of database; -檢查備份信息RMAN>backup archivelog all delete input; -備份歸檔日志并刪除歸檔日志RMAN> list backup of archivelog all; -檢查歸檔日志2. 差異增量備份 RMAN> backup incremental level 0 database; -0級(jí)全備份RMAN> bac

5、kup incremental level 2 database;-2級(jí)備份RMAN> list backup of database; -檢查備份信息3. 累積增量備份（2c 不做參照對(duì)象）RMAN> backup incremental level 2 cumulative database;中心數(shù)據(jù)庫(kù),RMAN一周備份方案=0.星期天晚上 -level 0 backup performed(全備份)1.星期一晚上 -level 2 backup performed2.星期二晚上 -level 2 backup performed3.星期三晚上 -level 1 backup

6、performed4.星期四晚上 -level 2 backup performed5.星期五晚上 -level 2 backup performed6.星期六晚上 -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級(jí)備份腳本 D:rman_bak_scriptrunallocate channel c1 type disk;allocate channel c2 type disk;allocate c

7、hannel c3 type disk;backup as compressed backupset incremental level 0 tag 'db_level0' database format 'H:RMAN_BAKlevel0_%u_%s_%p.bak'sql 'alter system archive log current'backup as compressed backupset archivelog all format 'H:ARCHIVELOG_BAKarch0_%u_%s_%p' delete inp

8、ut;delete noprompt obsolete;release channel c1;release channel c2;release channel c3;runallocate channel c1 type disk;allocate channel c2 type disk;allocate channel c3 type disk;backup as compressed backupset incremental level 1 tag 'db_level1' database format 'H:RMAN_BAKlevel1_%u_%s_%p.

9、bak'sql 'alter system archive log current'backup as compressed backupset archivelog all format 'H:ARCHIVELOG_BAKarch1_%u_%s_%p' delete input;delete noprompt obsolete;release channel c1;release channel c2;release channel c3;runallocate channel c1 type disk;allocate channel c2 type

10、 disk;allocate channel c3 type disk;backup as compressed backupset incremental level 2 tag 'db_level2' database format 'H:RMAN_BAKlevel2_%u_%s_%p.bak'sql 'alter system archive log current'backup as compressed backupset archivelog all format 'H:ARCHIVELOG_BAKarch2_%u_%s_%p

11、' delete input;delete noprompt obsolete;release channel c1;release channel c2;release channel c3;2. 創(chuàng)建周日至周六執(zhí)行的批處理文件 D:rman_bak_script MonSun星期天 rman target / log D:rman_bak_scriptSunrmanlog_Sun%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rman_bak_scriptrman_level0.cmd星期一 rman target / log D:rm

12、an_bak_scriptMonrmanlog_Mon%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rman_bak_scriptrman_level2.cmd星期二 rman target / log D:rman_bak_scriptTuermanlog_Tue%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rman_bak_scriptrman_level2.cmd星期三 rman target / log D:rman_bak_scriptWenrmanlog_Wen%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rman_bak_scriptrman_level1.cmd星期四 rman target / log D:rman_bak_scriptThurmanlog_Thu%date:0,4%_%date:5,2%_%date:8,2%.txt cmdfile=D:rman_bak_scriptrman_level2.cmd星期五 rman target / log D:rman_bak_scriptFrirmanlog_Fri%date:0,4%_%d