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;