RMAN BACKUP SCRIPTS

RMAN BACKUP WITH CONTROLFILE AND SPFILE

run

{

ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT 'C:\db_home\app\oradata\ORCL_BKP\rman_backup\ORCL_%U';

ALLOCATE CHANNEL CH2 DEVICE TYPE DISK FORMAT 'C:\db_home\app\oradata\ORCL_BKP\rman_backup\ORCL_%U';

ALLOCATE CHANNEL CH3 DEVICE TYPE DISK FORMAT 'C:\db_home\app\oradata\ORCL_BKP\rman_backup\ORCL_%U';

BACKUP tag 'COLD_ORCLBKP' FORCE AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

BACKUP CURRENT CONTROLFILE TAG 'ORCL_SPFILE_CTL' FORMAT 'C:\db_home\app\oradata\ORCL_BKP\rman_backup\ORCL_%u';

BACKUP SPFILE TAG 'ORCL_SPFILE' FORMAT 'C:\db_home\app\oradata\ORCL_BKP\rman_backup\ORCL_%U';

RELEASE CHANNEL CH1;

RELEASE CHANNEL CH2;

RELEASE CHANNEL CH3;

}