INCREMENTAL LEVEL=0 Backup
On an INCREMENTAL LEVEL=0, you can run either INCREMENTAL LEVEL=1 or INCREMENTAL LEVEL=1 CUMULATIVE backups but on a full backup you cannot.RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';
SEND 'NB_ORA_POLICY=NB_POLICY';
BACKUP
INCREMENTAL LEVEL=0
FILESPERSET 10
FORMAT 'demjop_%s_%p_%t'
(DATABASE include current controlfile);
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
For this purpose, you can run once or twice a week INCREMENTAL LEVEL=0 backup and then daily INCREMENTAL LEVEL=1 or INCREMENTAL LEVEL=1 CUMULATIVE backups.
An incremental backup level 0 includes all the blocks except those blocks compressed because they have never been used.
INCREMENTAL LEVEL=1 Backup
An incremental backup level 1 includes only those blocks that have changed since the parent backup.RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';
SEND 'NB_ORA_POLICY=NB_POLICY';
BACKUP
INCREMENTAL LEVEL=1
FILESPERSET 10
FORMAT 'demjop_%s_%p_%t'
(DATABASE include current controlfile);
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
A level 1 differential incremental takes the blocks altered from the last level 0 or level 1 backup.
INCREMENTAL LEVEL=1 CUMULATIVE Backup
A level 1 cumulative incremental takes the blocks altered from the last level 0 backupRUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';
SEND 'NB_ORA_POLICY=NB_POLICY';
BACKUP
INCREMENTAL LEVEL=1 CUMULATIVE
FILESPERSET 10
FORMAT 'demjop_%s_%p_%t'
(DATABASE include current controlfile);
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
FULL Backup:
A full backup is a backup that includes every allocated block.RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE';
SEND 'NB_ORA_POLICY=NB_POLICY';
BACKUP
FULL
FILESPERSET 10
FORMAT 'demjop_%s_%p_%t'
(DATABASE include current controlfile);
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;