1、1、備份數(shù)據(jù)庫備份的詳細列表RMAN list backup vere;刪除備份文件RMAN host rm -rf /u01/app/oracle/rmanback/*;核對所有備份集RMANCROSSCHECK BACKUP;核對所有數(shù)據(jù)文件的備份集RMAN CROSSCHECK BACKUP OF DATABASE;核對特定表空間的備份集RMANCROSSCHECK BACKUP OF TABLESPAYSTEM;核對特定數(shù)據(jù)文件的備份集 RMANCROSSCHECK BACKUP OF DATAFILE 4;核對控制文件的備份集RMANCROSSCHECK BACKUP OF CONT

2、ROLFILE;6核對 SPFILE 的備份集RMAN CROSSCHECK BACKUP OF SPFILE;說明：AVALIABLE 表示可用，EXPIRED 表示過期列出過期的備份文件RMAN list expired backup; RMAN delete expired backupset; RMAN DELETE BACKUPSET 12;刪除備份集RMAN delete backupset;備份整個數(shù)據(jù)庫并壓縮備份集:RMAN backup as compressed backupset database format /u01/app/oracle/rmanback/whole

3、_%d_%U;手動分配一個通道，指定備份片的大小為 2g，壓縮備份集，指定備份集中允許容納的文件數(shù)為 3 個，通道備份整個數(shù)據(jù)庫:備份整個數(shù)據(jù)庫，默認路徑/u01/app/oracle/flash_recovery_area/ORCL/backupset RMAN backup database;備份整個數(shù)據(jù)庫，路徑/u01/app/oracle/rmanbackRMAN backup database format /u01/app/oracle/rmanback/whole_%d_%U;列出數(shù)據(jù)文件的備份信息RMAN list backup summary; RMAN list backu

4、p of database;RMAN list backup of database summary；RMAN list backup of datafile 1,2,3,4,5 summary; RMAN list backup by file;列出備份集的詳細信息 RMAN list backup;RMAN list backup of spfile; RMAN list backup of controlfile;RMAN list backup of datafile 1,2,3,4,5;RMAN list backup of tablespaystem,users;RMAN runa

5、llocate channel ch1 type diskmaxpieize=2g;backup as compressed backupset format /u01/app/oracle/rmanback/whole_%d_%U filesperset=3 database;release channel ch1;將并行度改為 3: 并行度改為 3 之后，自動啟用了 3 個通道:RMAN configure device type disk parallelism 3;RMAN backup as compressed backupset format /u01/app/oracle/rm

6、anback/whole_%d_%U filesperset=3 database;備份片大小設置為 100m,則一個備份集包含多個備份片,且每個備份片大小為 100mRMAN runallocate channel ch1 type diskmaxpieize=100m;backup format /u01/app/oracle/rmanback/whole_%d_%U database;release channel ch1;RMAN list backup summary;RMAN list backupset tag=TAG20101014T171115;2.備份數(shù)據(jù)文件鏡像備份:RM

7、AN backup as copy datafile 4 format /u01/app/oracle/rmanback/df_%d_%U;RMAN list copy;RMAN list copy of datafile 4;RMAN list copy of tablespace users;RMAN list copy of database;RMAN list copy of archivelog all;RMAN host rm -rf /u01/app/oracle/rmanback/*;核對所有數(shù)據(jù)文件的映像副本RMAN CROSSCHECK COPY OF DATABASE;R

8、MAN DELETE EXPIRED COPY;RMAN DELETE COPY;備份類型為備份集:RMAN backup datafile 4,5 format /u01/app/oracle/rmanback/df_%d_%U;RMAN list backup of database summary;RMAN list backup of datafile 4,5;RMAN host rm -rf /u01/app/oracle/rmanback/*;RMANCROSSCHECK BACKUP OF DATAFILE 4;RMAN list backup of datafile 4,5;R

9、MANdelete expired backup;RMAN backup datafile 4,5 format /u01/app/oracle/rmanback/df_%d_%U;刪除指定備份片RMAN DELETE BACKUPPIECE /u01/app/oracle/rmanback/df_ORCL_0coqmhit_1_1;3.備份表空間:RMANbackup tablespace users format /u01/app/oracle/rmanback/tb_%d_%U;RMAN list backup of tablespace usermmary;RMAN list back

10、up of tablespace users;RMAN DELETE BACKUPSET 13;臨時表空間不需要備份(出錯):RMANbackup tablespace temp;4.備份控制文件自動備份控制文件置為 on 狀態(tài),將自動備份控制文件和參數(shù)文件RMAN backup tablespace users format /u01/app/oracle/rmanback/tb_%d_%U;驗證是否備份控制文件RMAN list backup of controlfile;RMAN list backup of tablespace users;RMAN DELETE BACKUPSET

11、14;RMAN configure controlfile autobackup on;RMAN backup tablespace users format /u01/app/oracle/rmanback/tb_%d_%U;驗證是否備份控制文件RMAN list backup of controlfile;RMAN DELETE BACKUPSET 15;RMAN DELETE BACKUPSET 16;注：在備份 system01.dbf 或 system 表空間時將會自動備份控制文件和參數(shù)文件，即使自動備份控制文件參數(shù)為 off單獨備份控制文件及參數(shù)文件:RMAN backup cur

12、rent controlfile;或RMAN backup current controlfile format /u01/app/oracle/rmanback/sp_%d_%U;RMAN list backup of controlfile;RMAN DELETE BACKUPSET;備份數(shù)據(jù)文件時包含控制文件RMAN backup datafile 4 include current controlfile;或RMAN backup datafile 4 include current controlfile format /u01/app/oracle/rmanback/sp_%d_%

13、U;RMAN sql alter database backup controlfile to /u01/app/oracle/rmanback/orclcontrol.bak;RMAN sql alter database backup controlfile to trace as /u01/app/oracle/rmanback/orclcontrol.sql;單獨備份 spfileRMAN backup spfile format /u01/app/oracle/rmanback/sp_%d_%U;RMAN backup copies 2 device type disk spfile

14、 format /u01/app/oracle/rmanback/sp_%d_%U;RMAN DELETE BACKUPSET5.備份歸檔日志文件備份歸檔日志時僅僅備份歸檔過的數(shù)據(jù)文件(不備份聯(lián)機重做日志文件)，備份歸檔日志時總是對歸檔日志做完整備份，RMAN 對歸檔日志備份前會自動做一次日志切換，且從一組歸檔日志中備份未損壞的歸檔日志，RMAN 會自動判斷哪些歸檔日志需要進行備份，歸檔日志的備份集不能包含其它類型的文件。delete input 刪除所有已經備份過的歸檔日志RMAN backup archivelog all format /u01/app/oracle/rmanback/l

15、f_%d_%U;RMAN backup format /u01/app/oracle/rmanback/lf_%d_%U archivelog all delete input;RMAN list backup of archivelog all;RMAN list backup of archivelog all summary;RMAN list backup of archivelog from sequence 4;RMAN list backup of archivelog from sequence 5;RMAN list backup of archivelog until se

16、quence 5;RMAN list backup of archivelog from scn 500360;RMAN list backup of archivelog until scn 514173;RMAN list backup of archivelog from sequence 4 until sequence 6;RMAN list backup of archivelog from scn 500360 until scn 514173;RMAN DELETE BACKUPSET 22使用 plus archivelog 時備份數(shù)據(jù)庫完成的動作(backup database plus archivelog)1.首先執(zhí)行 alter system archive log current 命令(對當前日志歸檔)2.執(zhí)行 backup archivelog all