RMAN將備份片分佈在不同的掛載點

snowdba發表於2014-12-03
此次資料遷移,需要將資料庫備份到儲存上。由於檔案系統的限制,每個掛載點的lv不能超過2TB。這就需要將資料庫備份到不同掛載點的目錄上,可以採用分配通道中的format關鍵字實現該需求。

run{
allocate channel c1 device type disk format '/orabak1/bj_db_full_%U' maxpiecesize=20G;
allocate channel c2 device type disk format '/orabak2/bj_db_full_%U' maxpiecesize=20G;
allocate channel c3 device type disk format '/orabak3/bj_db_full_%U' maxpiecesize=20G;
allocate channel c4 device type disk format '/orabak4/bj_db_full_%U' maxpiecesize=20G;
allocate channel c5 device type disk format '/orabak5/bj_db_full_%U' maxpiecesize=20G;
allocate channel c6 device type disk format '/orabak6/bj_db_full_%U' maxpiecesize=20G;
allocate channel c7 device type disk format '/orabak7/bj_db_full_%U' maxpiecesize=20G;
allocate channel c8 device type disk format '/orabak8/bj_db_full_%U' maxpiecesize=20G;
backup tag 'BJ_DB_FULL' as compressed backupset database
include current controlfile;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
release channel c7;
release channel c8;
}

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29047826/viewspace-1355665/,如需轉載,請註明出處,否則將追究法律責任。

相關文章