RMAN Sample Backup Script

Contents:-  Backup Script

Create Global Script backup_script

{

allocate channel c1 type disk;

backup database format '/u01/app/oracle/backup/db_%u_%d_%s';

sql 'alter system archive log current';

backup format '/u01/app/oracle/backup/archivelog/log_t%t_s%s_p%p'

(archivelog all delete all input);

};

*** BACKUP.BAT file

         

          rman target / catalog rman_user/rman_user@rdb

          cmdfile=f:\script\backup.rcv

          log=f:\script\rman.log