#配置RMAN设置
#开启备份优化
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
#配置并行度8
RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
#配置控制文件自动备份
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/rman/controlfile/%F'; 

#归档备份删除（备份归档并保留30天归档）
vi archback.rcv
run{
    allocate channel d1 device TYPE disk maxpiecesize=150G;
    allocate channel d2 device TYPE disk maxpiecesize=150G;
    crosscheck archivelog all;
    DELETE NOPROMPT expired archivelog ALL;
    backup as compressed backupset filesperset 15 format '/mnt/NFS/dg2backup/arch_%d_%T_%s_%p' archivelog all;
    delete archivelog all completed before 'sysdate-30';
    release channel d1;
    release channel d2;
}

0级备份

vi backuplevel0.rcv
run{
allocate channel d1 TYPE disk maxpiecesize=150G;
allocate channel d2 TYPE disk maxpiecesize=150G;
crosscheck archivelog all;
DELETE NOPROMPT expired archivelog ALL;
DELETE NOPROMPT obsolete;
sql ‘alter system archive log current’;
backup as compressed backupset incremental level 0 database tag=’level_0’ include CURRENT controlfile format ‘/mnt/NFS/dg2backup/fulldb%d%T%s%p’;
backup current controlfile format ‘/mnt/NFS/dg2backup/fulldbCT%d%T%s%p’;
backup spfile format ‘/mnt/NFS/dg2backup/fulldbSP%d%T%s_%p’;
release channel d1;
release channel d2;
crosscheck backup;
DELETE noprompt obsolete REDUNDANCY 2;
}http://www.cndba.cn/Marvinn/article/2701

#差异level1

vi backuplevel1.rcv
run{
allocate channel d1 TYPE disk maxpiecesize=150G;
allocate channel d2 TYPE disk maxpiecesize=150G;
allocate channel d3 TYPE disk maxpiecesize=150G;
allocate channel d4 TYPE disk maxpiecesize=150G;
allocate channel d5 TYPE disk maxpiecesize=150G;
allocate channel d6 TYPE disk maxpiecesize=150G;
allocate channel d7 TYPE disk maxpiecesize=150G;
allocate channel d8 TYPE disk maxpiecesize=150G;
crosscheck archivelog all;
DELETE NOPROMPT expired archivelog ALL;
sql ‘alter system archive log current’;
backup as compressed backupset incremental level 1 database tag=’level_1diff’ format ‘/mnt/NFS/dg2backup/fulldb_level1%d%T%s_%p’;
release channel d1;
release channel d2;
}http://www.cndba.cn/Marvinn/article/2701http://www.cndba.cn/Marvinn/article/2701

#差异level2

vi backuplevel2.rcv
run{
allocate channel d1 TYPE disk maxpiecesize=150G;
allocate channel d2 TYPE disk maxpiecesize=150G;
crosscheck archivelog all;
DELETE NOPROMPT expired archivelog ALL;
sql ‘alter system archive log current’;
backup as compressed backupset incremental level 2 database tag=’leve2_1diff’ format ‘/mnt/NFS/dg2backup/fulldb_level2%d%T%s_%p’;
release channel d1;
release channel d2;
}

```http://www.cndba.cn/Marvinn/article/2701

版权声明：本文为博主原创文章，未经博主允许不得转载。