RMAN oracle database 12c backup script

Oracle database RMAN level 0 backup script

RUN {

ALLOCATE CHANNEL MY_RMAN1 TYPE disk;

ALLOCATE CHANNEL MY_RMAN2 TYPE disk;

SETLIMIT CHANNEL MY_RMAN1 KBYTES 33554432;

SETLIMIT CHANNEL MY_RMAN2 KBYTES 33554432;

CONFIGURE RETENTION POLICY TO NONE;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

BACKUP

INCREMENTAL LEVEL 0

TAG full_mydb_level0_tag_10312018

FORMAT ‘/backup/rman_backup/INCREMENTAL_LEVEL_0_db_bkup_%d_%U_%t_%T’

DATABASE;

RELEASE CHANNEL MY_RMAN1;

RELEASE CHANNEL MY_RMAN2;

}

Oracle database RMAN level 1 backup script

RUN {

ALLOCATE CHANNEL MY_RMAN1 TYPE disk;

ALLOCATE CHANNEL MY_RMAN2 TYPE disk;

SETLIMIT CHANNEL MY_RMAN1 KBYTES 33554432;

SETLIMIT CHANNEL MY_RMAN2 KBYTES 33554432;

CONFIGURE RETENTION POLICY TO NONE;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

BACKUP

INCREMENTAL LEVEL 1

TAG full_mydb_level1_tag_10312018

FORMAT ‘/backup/rman_backup/INCREMENTAL_LEVEL_1_db_bkup_%d_%U_%t_%T’

DATABASE;

RELEASE CHANNEL MY_RMAN1;

RELEASE CHANNEL MY_RMAN2;

}

Leave a Reply

Your email address will not be published. Required fields are marked *