Sunday, 24 June 2018

RMAN SIGN

https://dbissues.blogspot.com/2018/06/rman-sign.html

%a          Specifies the activation id number of the database.

%A         Specifies the activation id number of the database completed 0

%c          Specifies the copy number of the backup piece within a set of duplexed backup pieces. The maximum value is 256.

%d          Specifies the name of the database--

%D         Specifies the current day of the month in format DD--

%e          Specifies the archived log sequence number--

%f           Specifies the absolute file number           
       
%F          Combines the DBID, day, month, year, and sequence into a unique and repeatable generated name--

%h          Specifies the archived redo log thread number--

%I           Specifies the DBID--

%M        Specifies the month in format MM--

%n          Specifies the name of the database. padded on the right with x characters to a total length of eight characters.

%N         Specifies the tablespace name.

%p          Specifies the piece number within the backup set

%r           Resetlogs ID

%s          Specifies the backup set number

%S          Specifies the backup set number completed 0

%t           Specifies the backup set time stamp.

%T          Specifies the year, month, and day in format YYYYMMDD

%u          Specifies an 8-character name constituted by compressed representations of the backup set or image copy number.

%U         Specifies a system-generated unique file name.

%Y          Specifies the year in this format: YYYY.

No comments:

Post a Comment