Shulou(Shulou.com)05/31 Report--

Editor to share with you what% means in RMAN backup FORMAT format. I hope you will get something after reading this article. Let's discuss it together.

The activation ID of the a:Oracle database is RESETLOG_ID.

% c: the number of copies of the backup segment (numbered from 1, up to 256).

D:Oracle database name.

% D: day in the current time, formatted as DD.

% e: archive serial number.

% f: absolute file number.

% F: unique name determined based on DBID+ time, in the form of c-IIIIIIIIII-YYYYMMDD-QQ, where IIIIIIIIII is the DBID,YYYYMMDD of the database is the date, and QQ is a sequence of 1x 256.

% h: archive log thread number.

DBID of the I:Oracle database.

% M: month in the current time, formatted as MM.

% n: database name, and will be populated with x characters on the right to keep it at 8 in length. For example, if the database name is JSSBOOK, the generated name is JSSBOOKx.

% N: tablespace name.

% p: the number of the backup segment in the backup set, starting at 1.

% s: backup set number.

% t: backup set timestamp.

% T: the year, month and day format of the current time (YYYYMMDD).

% u: is an 8-character name composed of backup set number and establishment time compression. With% u, you can generate a unique name for each backup set.

% U: the default is the shorthand form of% u_%p_%c, which allows you to generate a unique name for each backup fragment (that is, disk file). This is the most commonly used naming method, and different rules are generated when performing different backup operations, as shown below:

% U=%u_%p_%c when generating backup fragments.

% U=data-D-%d_id-%I_TS-%N_FNO-%f_%u when generating data file mirror replication.

% U=arch-D_%d-id-%I_S-%e_T-%h_A-%a_%u when generating archive image replication.

% U=cf-D_%d-id-%I_%u when generating control file mirror replication.

% Y: the year in the current time, formatted as YYYY.

Note: if the FORMAT option is not specified in the BACKUP command, RMAN uses% U to name the backup fragment by default.

After reading this article, I believe you have a certain understanding of "what is the meaning of% in RMAN backup FORMAT format". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.