Production Practice (RMAN)

r  Weekly Level 0 Full Backup (Sunday)

RUN {

  -- Allocate 3 parallel channels

  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 (separate)

  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 channels

  RELEASE CHANNEL c1;

  RELEASE CHANNEL c2;

  RELEASE CHANNEL c3;

}

r  Daily Level 1 Incremental Backup (Mon–Sat)

RUN {

  -- Allocate 3 parallel channels

  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';

  -- Archivelog Backup + delete input

  BACKUP

    ARCHIVELOG ALL

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

    DELETE INPUT;

  -- Optional: Controlfile + SPFILE backup weekly only, not every day

  -- If needed, uncomment below:

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

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

  -- Validate incremental backup

  RESTORE VALIDATE DATABASE;

  -- Release channels

  RELEASE CHANNEL c1;

  RELEASE CHANNEL c2;

  RELEASE CHANNEL c3;

r  Daily Level 1 Cumulative Backup (Mon–Sat) + Archivelog

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';

  -- Archivelog Backup + delete input

  BACKUP

    ARCHIVELOG ALL

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

    DELETE INPUT;

  -- Optional: Controlfile/SPFILE weekly only

  -- Validate incremental backup

  RESTORE VALIDATE DATABASE;

  RELEASE CHANNEL c1;

  RELEASE CHANNEL c2;

  RELEASE CHANNEL c3;

}

}