Tuesday, June 10, 2014

Overriding controlfile autobackup filename format

1.Default controlfile autobackup filename format
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: