Sunday, December 9, 2018

RMAN Backup of Oracle 12c Database


 run
{
 allocate channel c1 device type disk format '/dbexports/FCUBS/RMANBACKUP/FCUB/%u';
 allocate channel c2 device type disk format '/dbexports/FCUBS/RMANBACKUP/FCUB/%u';
 allocate channel c3 device type disk format '/dbexports/FCUBS/RMANBACKUP/FCUB/%u';
 allocate channel c4 device type disk format '/dbexports/FCUBS/RMANBACKUP/FCUB/%u';
 allocate channel c5 device type disk format '/dbexports/FCUBS/RMANBACKUP/FCUB/%u';
 backup database plus archivelog;
}

 run{
 CONFIGURE DEVICE TYPE disk BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 6;
 allocate channel c1 device type disk  format '/dbexports/FCUBS/RMANBACKUP/FCUB/%d_D_%T_%u_s%s_p%p' MAXPIECESIZE 2G ;
 allocate channel c2 device type disk  format '/dbexports/FCUBS/RMANBACKUP/FCUB/%d_D_%T_%u_s%s_p%p' MAXPIECESIZE 2G ;
 allocate channel c3 device type disk  format '/dbexports/FCUBS/RMANBACKUP/FCUB/%d_D_%T_%u_s%s_p%p' MAXPIECESIZE 2G ;
 allocate channel c4 device type disk  format '/dbexports/FCUBS/RMANBACKUP/FCUB/%d_D_%T_%u_s%s_p%p' MAXPIECESIZE 2G ;
 BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG  ;
  backup current controlfile for standby format '/dbexports/FCUBS/RMANBACKUP/FCUB/standbycontrol.ctl';
}