資源描述：
《oracle rman備份腳本》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、oraclerman備份腳本2，常用備份腳本：備份到磁盤：(如果是磁帶，將DISK改成'SBT_TAPE')0級(jí)備份腳本：RUN{ALLOCATECHANNELch00TYPEDISK;ALLOCATECHANNELch01TYPEDISK;BACKUP???INCREMENTALLEVEL=0???SKIPINACCESSIBLE???TAGhot_db_bk_level0???FILESPERSET5???FORMAT'bk_%s_%p_%t'???DATABASE;???sql'altersystem
2、archivelogcurrent';RELEASECHANNELch00;RELEASECHANNELch01;ALLOCATECHANNELch00TYPEDISK;ALLOCATECHANNELch01TYPEDISK;BACKUP??filesperset20??FORMAT'al_%s_%p_%t'??ARCHIVELOGALLDELETEINPUT;RELEASECHANNELch00;RELEASECHANNELch01;ALLOCATECHANNELch00TYPEDISK;BACKUP??
3、?FORMAT'cntrl_%s_%p_%t'???CURRENTCONTROLFILE;RELEASECHANNELch00;}1級(jí)差異增量備份：RUN{ALLOCATECHANNELch00TYPEDISK;ALLOCATECHANNELch01TYPEDISK;BACKUP???INCREMENTALLEVEL=1???SKIPINACCESSIBLE???TAGhot_db_bk_level0???FILESPERSET5???FORMAT'bk_%s_%p_%t'???DATABASE;???sq
4、l'altersystemarchivelogcurrent';RELEASECHANNELch00;RELEASECHANNELch01;ALLOCATECHANNELch00TYPEDISK;ALLOCATECHANNELch01TYPEDISK;BACKUP??filesperset20??FORMAT'al_%s_%p_%t'??ARCHIVELOGALLDELETEINPUT;RELEASECHANNELch00;RELEASECHANNELch01;ALLOCATECHANNELch00TYPE
5、DISK;BACKUP???FORMAT'cntrl_%s_%p_%t'???CURRENTCONTROLFILE;RELEASECHANNELch00;}1級(jí)累積增量備份腳本：RUN{ALLOCATECHANNELch00TYPEDISK;ALLOCATECHANNELch01TYPEDISK;BACKUP???INCREMENTALLEVEL=1CUMULATIVE???SKIPINACCESSIBLE???TAGhot_db_bk_level0???FILESPERSET5???FORMAT'bk_%
6、s_%p_%t'???DATABASE;???sql'altersystemarchivelogcurrent';RELEASECHANNELch00;RELEASECHANNELch01;ALLOCATECHANNELch00TYPEDISK;ALLOCATECHANNELch01TYPEDISK;BACKUP??filesperset20??FORMAT'al_%s_%p_%t'??ARCHIVELOGALLDELETEINPUT;RELEASECHANNELch00;RELEASECHANNELch0
7、1;ALLOCATECHANNELch00TYPEDISK;BACKUP???FORMAT'cntrl_%s_%p_%t'???CURRENTCONTROLFILE;RELEASECHANNELch00;}恢復(fù)腳本：RUN{ALLOCATECHANNELch00TYPEDISK;ALLOCATECHANNELch01TYPEDISK;RESTOREDATABASE;RECOVERDATABASE;RELEASECHANNELch00;RELEASECHANNELch01;}
