Control file autobackup

I find many large files(each file is about 12M) in dump folder, names are like ,
ISC01P_C-3518282637-20081111-05
I find many large files(each file is about 12M) in dump folder, names are like ,
ISC01P_C-3518282637-20081111-05

since there is no enough space on bdump, I would like to remove such files from the folder. But before that, i also need to figure out what’s the files for… and finally here is the result,

they are the backup image of control file. I find following configuration in the catalog database,

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 35 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘D:\ORACLE\ADMIN\isc01p\BDUMP\%d_%F’;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE ‘SBT_TAPE’ TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE ‘SBT_TAPE’ TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘D:\ORACLE\ORA1020\DATABASE\SNCFISC01P.ORA’; # default
———————————————————-

In above setting, we can find ,
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘D:\ORACLE\ADMIN\isc01p\BDUMP\%d_%F’;

which is to backup control file automatically, and %d_%F stand for,
%d: db_name
%F: complex format ==> c-IIIIIIIIII-YYYYMMDD-QQ, IIIIIIIIII is dbid,YYYYMMDD for year, month and day,QQ is the copy number of backup set 00-ff.

so the control file backup format is
db_name-C-dbid-yyyymmdd-QQ

and I also get following format from internet, they are very useful.

%d  –数据库的db_name
%n  –数据库的8位长度的db_name,不足部分用“x”后面填充
%N  –数据库表空间的name
%I  –数据库的dbid
%T  –年月日(YYYYMMDD) == %Y%M%D
%t  –9位字符的timestamp
%s  –备份集序号
%p  –备份片序号
%c  –备份片的多个copy的序号
%e  –archived redo file 的序列号,只能用在archived redo 上
%f  –datafile filenmuber,只能用在备份datafile、tablespace上,否则没有意义
%F  –复合format == c-IIIIIIIIII-YYYYMMDD-QQ,其中IIIIIIIIII为dbid,YYYYMMDD为年月日,QQ为十六进制的备份片的多个copy的序号(00-ff)。tmd,oracle竟然提示错误!
%u  –8为字母唯一串
%U  –复合format ==  
backupset:%u_%p_%c
copy of datafile:data-D-%d_id-%I_TS-%N_FNO-%f_%u
copy of archived log:arch-D_%d-id-%I_S-%e_T-%h_A-%a_%u
copy of controlfile:cf-D_%d-id-%I_%u

发表评论?

0 条评论。

发表评论


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>