backup-botw
10 years agoLevel 6
Backup Set Identifier (Oracle Intelligent Policy)
Is it possible to use something like this in the backup set identifier field of an Oracle Intelligent Policy?
DATE +"%b-%d-%y
These are the RMAN identifiers you can use
%a Current database activation id %A Zero-filled activation ID %c The copy number of the backup piece within a set of duplexed backup pieces.bMaximum value is 256 %d Database name %D Current day of the month from the Gregorian calendar in format DD %e Archived log sequence number %f Absolute file number %F Combines the DBID, day, month, year, and sequence into a unique and repeatable generated name %h Archived redo log thread number %I DBID %M Month in the Gregorian calendar in the format MM %n Database name, padded on the right with x characters to a total length of eight characters %N Tablespace name. Only valid when backing up datafiles as image copies. %p Piece number within the backup set. This value starts at 1 for each backup set and is incremented by 1 for each backup piece created. If a PROXY is specified, the %p variable must be included in the FORMAT string either explicitly or implicitly within %U. %r Resetlogs ID %s 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 and is unique for the lifetime of the control file. If you restore a backup control file, then duplicate values can result. CREATE CONTROLFILE initializes the counter at 1. %S Zero-filled sequence number %t Backup set time stamp, a 4-byte value derived as the number of seconds elapsed since a fixed reference time. The combination of %s and %t can be used to form a unique name for the backup set. %T Year, month, and day in the Gregorian calendar in the format: YYYYMMDD %u 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 A system-generated unique filename (default). %U is different for image copies and backup pieces. For a backup piece, %U is a shorthand for %u_%p_%c and guarantees uniqueness in generated backup filenames. For an image copy of a datafile, %U means the following:
data-D-%d_id-%I_TS-%N_FNO-%f_%u
For an image copy of an archived redo log, %U means the following:
arch-D_%d-id-%I_S-%e_T-%h_A-%a_%u
For an image copy of a control file, %U means the following:
cf-D_%d-id-%I_%u%Y Year in this format: YYYY %% Percent (%) character. For example, %%Y translates to the string %Y Its configurable in the "Oracle" tab in the Oracle Intelligent Policy - The section is called "Use specified Backup File Name Formats",
Be aware that the format must always end with %t, because it help Netbackup search for Oracle backups.
Fast forward to 7.00:
https://www-secure.symantec.com/connect/videos/new-oracle-intelligent-policy-netbackup-76