# # Script: rman_hotbkp.sql # Author: James Colestock, Oracle DBA # Date: 10/2/04 # # Summary: Performs a Hot Backup of the Database # in question. This Backup is taken # using Oracle's Recovery Manager Utility # a.k.a. RMAN. This backup is a complete # Backup, which includes: all data files; # control files; archive logs, as well as # the SPFILE a.k.a. Server Parameter File. # # This backup uses: # # D:\BACKUP as the default backup directory # 10GB as the Maximum size of any 'Backup Piece' # The controlfile autobackup feature # connect target / crosscheck archivelog all; configure controlfile autobackup on; configure controlfile autobackup format for device type disk to 'D:\backup\%d_%F.ORABKP'; configure channel device type disk maxpiecesize 10G; run { backup database format 'D:\backup\%d_FHB_%t.ORABKP' plus archivelog format 'D:\backup\%d_ARC_%t.ORABKP' delete input; } exit;