转自:
http://blog.csdn.net/kai27ks/article/details/7719561
例如;backup incremental level 0 database format='lev0_%d_%t_%u_%s_%p'
format=string文件路径和名称的格式串,其中的含义是:
%c copy ID
%p backup piece ID
%s backup set ID
%e log Sequence
%h log thread ID
%d database name
%n database name(x填充到8个字符)
%I DBID
%f file ID
%F DBID , day ,month ,year and sequence的复合格式 ---多用于全备份
%N tablespace name
---表空间备份
%t timestamp
%M mh mm格式
%Y year yyyy格式
%D day dd格式
%u backup set time(x填充到8个字符))
%U %u_%p_%c
---- 采用备份冗余时使用
以下来自另一文
转自:
http://hunt1574.blog.51cto.com/1390776/862297
OCP试题一道
You
are
using
Oracle
Database
10g.
The
LOG_ARCHIVE_FORMAT
parameter
is
set
to
'LOG%t_%s_%r.dbf'.
Why is
%r
used
in
the
file
name
format?
A.to uniquely
identify
the
archived
log
files
with
the
restore
operation
B.to uniquely
identify
the
archived
log
files
with
the
redo
log
group
number
C.to uniquely
identify
the
archived
log
files
for
each
incarnation
of
the
database
D.to uniquely
identify
the
archived
log
files
with
the
number
of
recovery
operations
performed
Answer: C
例如;backup incremental level 0 database format='lev0_%d_%t_%u_%s_%p'
format=string文件路径和名称的格式串,其中的含义是:
%c copy ID
%p backup piece ID
%s backup set ID
%e log Sequence
%h log thread ID
%d database name
%n database name(x填充到8个字符)
%I DBID
%f file ID
%F DBID , day ,month ,year and sequence的复合格式
%N tablespace name
%t timestamp
%M mh mm格式
%Y year yyyy格式
%D day dd格式
%u backup set time(x填充到8个字符))
%U %u_%p_%c
以下来自另一文
The following table lists RMAN substitution variables that are valid in format strings.
Syntax Element | Description |
---|---|
%a | Specifies the activation ID of the database. |
%c | Specifies the copy number of the backup piece within a set of duplexed backup pieces. If you did not duplex a backup, then this variable is 1 for backup sets and 0 for proxy copies. If one of these commands is enabled, then the variable shows the copy number. The maximum value for %c |
%d | Specifies the name of the database (see |
%D | Specifies the current day of the month from the Gregorian calendar in format DD . |
%e | Specifies the archived log sequence number. |
%f | Specifies the absolute file number (see |
%F | Combines the DBID, day, month, year, and sequence into a unique and repeatable generated name. This variable translates into c-IIIIIIIIII-YYYYMMDD-QQ , where:
|
%h | Specifies the archived redo log thread number. |
%I | Specifies the DBID. |
%M | Specifies the month in the Gregorian calendar in format MM . |
%N | Specifies the tablespace name. This substitution variable is only valid when backing up datafiles as image copies. |
%n | Specifies the name of the database, padded on the right with x prod1 prod1xxx . |
%p | Specifies the piece number within the backup set. This value starts at 1
Note:
PROXY , then the
%p
FORMAT
|
%s | Specifies the backup set number. This number is a counter in the control file that is incremented for each backup set. The counter value starts at 1 CREATE CONTROLFILE 1 . |
%t | Specifies the backup set time stamp, which is a 4-byte value derived as the number of seconds elapsed since a fixed reference time. The combination of %s %t |
%T | Specifies the year, month, and day in the Gregorian calendar in this format: YYYYMMDD . |
%u | Specifies an 8-character name constituted by compressed representations of the backup set or image copy number and the time the backup set or image copy was created. |
%U | Specifies a system-generated unique filename (default).
The meaning of
%U
%U specifies a convenient shorthand for
%u_%p_%c
%U
data-D-%d_id-%I_TS-%N_FNO-%f_%u
For an image copy of an archived redo log,
%U
arch-D_%d-id-%I_S-%e_T-%h_A-%a_%u
For an image copy of a control file,
%U
cf-D_%d-id-%I_%u
|
%Y | Specifies the year in this format: YYYY . |
%% | Specifies the percent (% ) character. For example, %%Y %Y . |
OCP试题一道
'LOG%t_%s_%r.dbf'.
Why
A.to
B.to
C.to
D.to
Answer: