run{ ############################################################################### # RMAN Script: configure_defaults.rcv # # Shows examples of how to utilize new Oracle 9iR2 RMAN CONFIGURE commands # to set default values for backup and recovery # ############################################################################### ### # Set up default configuration settings using the CONFIGURE command: # - Set up default channel(s) for backup and recovery # - Activate auto-backup of control files and SPFILE # - Specify format for storing control file auto-backups # - Set the default device type to disk media using parallelism degree of 2 # and a default disk format # - Set the default retention policy to 3 days # - Set the maximum size of backup sets to 1024K # - Exclude the EXAMPLE, TOOLS, and USERS tablespaces from all backups ### CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'K:\RMANBKUP\cf_%F'; CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = 'k:\rmanbkup\df0_%d_%s_%t'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; CONFIGURE MAXSETSIZE TO 512000K; CONFIGURE EXCLUDE FOR TABLESPACE example; CONFIGURE EXCLUDE FOR TABLESPACE tools; CONFIGURE EXCLUDE FOR TABLESPACE users; }