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