rman备份策略以及脚本 0x1 rman推荐每周一次0级备份，其他时间1级备份，不需要搞其他级别备份，麻烦但是节省不了多少空间。 https://www.oracle.com/br/a/tech/docs/technical-resources/best-practices-for-oda.pdf 0x2 0级备份 echo `date +%a` rman target / run { allocate channel t1 type disk; allocate channel t2 type disk; allocate channel t3 type disk; allocate channel t4 type disk; backup as compressed backupset incremental level 0 tag 'db_level0' skip inaccessible format '/rman/back_%s_%p_%T_%d' database; sql 'alter system archive log current'; backup skip inaccessible tag 'archlog' format '/rman/arclogback_%s_%p_%t_%d' archivelog all; backup tag 'controlfile' format='$BACKUPDIR/controlfile_%d_%U_%T.ctl' current controlfile; backup tag 'spfile' format='$BACKUPDIR/spfile_%d_%U_%T.ora' spfile; #delete input; release CHANNEL t1; release CHANNEL t2; release CHANNEL t3; release CHANNEL t4; } allocate channel for maintenance device type disk; crosscheck archivelog all; delete noprompt expired archivelog all; crosscheck backup; delete noprompt expired backup; report obsolete; delete noprompt obsolete; list backup summary; release channel; 1级累积备份 rman target / run { allocate channel t1 type disk; allocate channel t2 type disk; allocate channel t3 type disk; allocate channel t4 type disk; backup as compressed backupset incremental level 1 cumulative tag 'db_level1' skip inaccessible format '/rman/back_%s_%p_%T_%d' database; sql 'alter system archive log current'; backup skip inaccessible tag 'archlog' format '/rman/arclogback_%s_%p_%t_%d' archivelog all; backup tag 'controlfile' format='$BACKUPDIR/controlfile_%d_%U_%T.ctl' current controlfile; backup tag 'spfile' format='$BACKUPDIR/spfile_%d_%U_%T.ora' spfile; #delete input; release CHANNEL t1; release CHANNEL t2; release CHANNEL t3; release CHANNEL t4; } allocate channel for maintenance device type disk; crosscheck archivelog all; delete noprompt expired archivelog all; crosscheck backup; delete noprompt expired backup; report obsolete; delete noprompt obsolete; list backup summary; release channel;