ORACLE CLASSICAL BACKUP POLICY

1. Every half year make full backup

2. Every month level 0 backup

3. Every week level 1 backup --> cumulative (backup incremental level 1 cumulative )

4. Every day level 2 backup --> incremental (backup incremental level 1)

 

Full backup Script:

run{     allocate channel c1 type disk;     allocate channel c2 type disk;     allocate channel c3 type disk;     backup full tag 'dbfull' format '/u01/oradata/backup/full%u_%s_%p' database     include current controlfile;     sql 'alter system archive log current';     backup filesperset 3 format '/u01/oradata/backup/arch%u_%s_%p'     archivelog all delete input; #备份归档可选，可以单独定期备份     release channel c1;     release channel c2;     release channel c3;     }

 

Level 0 backup script:

run{     allocate channel c1 type disk;     allocate channel c2 type disk;     allocate channel c3 type disk;     backup incremental level 0 tag 'db0' format '/u01/oradata/backup/db0%u_%s_%p'     database skip readonly;     sql 'alter system archive log current';     backup filesperset 3 format '/u01/oradata/backup/arch%u_%s_%p'     archivelog all delete input; #备份归档可选，可以单独定期备份     release channel c1;     release channel c2;     release channel c3;     }

Level 1 backup script:

run{     allocate channel c1 type disk;     allocate channel c2 type disk;     allocate channel c3 type disk;     backup incremental level 1 cumulative tag 'db1' format '/u01/oradata/backup/db1%u_%s_%p'     database skip readonly;     sql 'alter system archive log current';     backup filesperset 3 format '/u01/oradata/backup/arch%u_%s_%p'     archivelog all delete input; #备份归档可选，可以单独定期备份     release channel c1;     release channel c2;     release channel c3;     }

  

Level 2 backup script:

run{     allocate channel c1 type disk;     allocate channel c2 type disk;     allocate channel c3 type disk;     backup incremental level 1 tag 'db2' format '/u01/oradata/backup/db2%u_%s_%p'     database skip readonly;     sql 'alter system archive log current';     backup filesperset 3 format '/u01/oradata/backup/arch%u_%s_%p'     archivelog all delete input; #备份归档可选，可以单独定期备份     release channel c1;     release channel c2;     release channel c3;     }