Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Saturday, 12 May 2012

Format Parameter of Rman Backup

%d : Specifies the database name - ORCL3
%n : Specifies the database name padded with the right with 8 characters - ORCL3XXXX
%s : specifies the backupset. This number is a counter in controlfile that is incremented with each backupset.
          It is started with 1 and unique for lifetime. Maximum 7 character long (9,999,999)
%p : specifies the backup set timestamp
%c : specifies the backup copy number.
%u : specifies an 8-character name constituted by compressed representations of the backup set number and
          the time the backup set was created.
%D : specifies the current day of the month from the Gregorian Calendar in DD format.
%F : specifies the DBID, yerar, day, month and sequence be combined so that generated name is unique and
%M : specifies the current month from the Gregorian Calendar in MM format.
%T : stands for year, month and day in the format YYMMDD. This will always be 6 characters in length.
%U : specifies that guarantees uniqueness in generated backup filenames.
%Y : specifies the current year from the Gregorian Calendar in YYYY format.

Note: If you do not specify a value for the FORMAT parameter, then RMAN either creates the backup in the
flash recovery area if it is enabled, or in a platform-specific directory (for example, ?/dbs on UNIX) if a flash recovery area is not enabled. In either case, RMAN uses the variable %U to name the backup.
For more details follow the link:


Post a Comment