RMAN Offline Backup


run { 

   configure controlfile autobackup format for device type disk to 'directory}/%F'; 

   configure controlfile autobackup on; 

   CONFIGURE DEVICE TYPE DISK PARALLELISM 8 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; 

   backup as compressed backupset check logical database format 'directory/DB_%d_%T_%U'; 

   backup as compressed backupset archivelog all delete input format 'directory/ARC_%d_%T_%s.log'; 

   copy current controlfile to 'directory/control_bk}.ctl'; 

} 



SQL> shutdown immediate; 

 SQL> startup mount;  

$ rman target / 

RMAN>  backup as compressed backupset check logical database format 'directory/DB_%d_%T_%U' include current controlfile;