RMAN 5 - Backup Strategy (BN)

·       Level 0 Full Backup: weekly (Sunday)

·       Level 1 Incremental Backup: daily (Mon–Sat)

·      Level 1 Incremental Cumulative Backup (Mon–Sat): 

·       Archive Log Backup: Every after 2 Hours

·       Controlfile + SPFILE separate backup (weekly)

·       TAG

·       3 parallel channels

·       Validation included

%d = Database name
%T = Date (YYYYMMDD)
%U = Unique identifier

RMAN Supporting Configurations:

Weekly Level 0 Full Backup (Sunday):

RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE DISK;

  ALLOCATE CHANNEL c2 DEVICE TYPE DISK;

  ALLOCATE CHANNEL c3 DEVICE TYPE DISK;

  -- Level 0 Full Database Backup

  BACKUP

    INCREMENTAL LEVEL 0

    DATABASE

    FORMAT '/u01/backup/%d_L0_%T_%U'

    TAG 'LEVEL0_FULL';

  -- Archivelog Backup + delete input

  BACKUP

    ARCHIVELOG ALL

    FORMAT '/u01/backup/%d_ARC_%T_%U'

    DELETE INPUT;

  -- Controlfile + SPFILE Backup

  BACKUP CURRENT CONTROLFILE FORMAT '/u01/backup/%d_C_%T_%U' TAG 'CONTROLFILE';

  BACKUP SPFILE FORMAT '/u01/backup/%d_S_%T_%U' TAG 'SPFILE';

  -- Validate backup immediately

  RESTORE VALIDATE DATABASE;

  RELEASE CHANNEL c1;

  RELEASE CHANNEL c2;

  RELEASE CHANNEL c3;

}

Daily Level 1 Incremental Backup (Mon–Sat):

RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE DISK;

  ALLOCATE CHANNEL c2 DEVICE TYPE DISK;

  ALLOCATE CHANNEL c3 DEVICE TYPE DISK;

  -- Level 1 Incremental Backup (Differential)

  BACKUP

    INCREMENTAL LEVEL 1

    DATABASE

    FORMAT '/u01/backup/%d_L1_%T_%U'

    TAG 'LEVEL1_INC';

  -- Optional: Controlfile/SPFILE weekly only

  -- Validate incremental backup

  RESTORE VALIDATE DATABASE;

  RELEASE CHANNEL c1;

  RELEASE CHANNEL c2;

  RELEASE CHANNEL c3;

}

Daily Level 1 Cumulative Backup (Mon–Sat): 

RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE DISK;

  ALLOCATE CHANNEL c2 DEVICE TYPE DISK;

  ALLOCATE CHANNEL c3 DEVICE TYPE DISK;

  -- Level 1 Cumulative Backup

  BACKUP

    INCREMENTAL LEVEL 1

    CUMULATIVE

    DATABASE

    FORMAT '/u01/backup/%d_L1C_%T_%U'

    TAG 'LEVEL1_CUM';

  -- Validate incremental backup

  RESTORE VALIDATE DATABASE;

  RELEASE CHANNEL c1;

  RELEASE CHANNEL c2;

  RELEASE CHANNEL c3;

}

Archive Log Backup Every 2 Hours:

RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE DISK;

  BACKUP

    ARCHIVELOG ALL

    FORMAT '/u01/backup/%d_ARC_%T_%U'

    DELETE INPUT;

  RELEASE CHANNEL c1;

}