1.Default controlfile autobackup filename format
2. Script to override configured controlfile autobackup filename format
2.Output of the script execution
RMAN> show controlfile autobackup format; RMAN configuration parameters for database with db_unique_name CVRMAN are: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
2. Script to override configured controlfile autobackup filename format
run { set controlfile autobackup format for device type disk to '/tmp/%F'; backup as backupset datafile 1 tag="full_bkp_dbf1"; }
2.Output of the script execution
RMAN> run 2> { 3> set controlfile autobackup format for device type disk to '/tmp/%F'; 4> backup 5> as backupset 6> datafile 1 7> tag="full_bkp_dbf1"; 8> } executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 10-JUN-14 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=+DATA/cvrman/datafile/system.304.849559339 channel ORA_DISK_1: starting piece 1 at 10-JUN-14 channel ORA_DISK_1: finished piece 1 at 10-JUN-14 piece handle=+DATA/cvrman/backupset/2014_06_10/nnndf0_full_bkp_dbf1_0.498.849910203 tag=FULL_BKP_DBF1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:02:16 Finished backup at 10-JUN-14 Starting Control File and SPFILE Autobackup at 10-JUN-14 piece handle=/tmp/c-659771233-20140610-02 comment=NONE Finished Control File and SPFILE Autobackup at 10-JUN-14
No comments:
Post a Comment