RMAN Backup


         CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET; 

         crosscheck copy; 

         crosscheck backup; 

         crosscheck archivelog all; 

         delete noprompt expired copy; 

         delete noprompt obsolete; 

         delete noprompt expired backup; 

         delete noprompt backup of database; 

         run 

           { 

           allocate channel dev1 device type disk; 

           allocate channel dev2 device type disk; 

           allocate channel dev3 device type disk; 

           backup database plus archivelog delete all input; 

           }


         shutdown immediate; 

         startup mount; 

         backup full database format ''/%U' tag 'myfullbackup'; 

         alter database open;

run {
configure controlfile autobackup format for device type disk to '/bkp_clouds3z031/rman/SNDDEV01/DBID2768777566/BKPS/%F';
configure controlfile autobackup on; CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
backup database format '/bkp_clouds3z031/rman/SNDDEV01/DBID2768777566/BKPS/DB_%d_%T_%U';
backup archivelog all format '/bkp_clouds3z031/rman/SNDDEV01/DBID2768777566/BKPS/ARC_%d_%T_%s.log';
copy current controlfile to '/bkp_clouds3z031/rman/SNDDEV01/DBID2768777566/BKPS/control_bk.ctl';
}

HOME