Format specifiers allow backup file names to be customized.
The following substitiion variables can be used:
%a | Database Activition ID |
%b | Base name - only vaied for SET NEWNAME and image copies |
%c | Backup piece copy number |
%d | Database name |
%D | Day of month (DD) |
%e | Archive log sequence number |
%f | Absolute file number |
%F | System-generated name. See below |
%h | Archived redo log thread number |
%I | DBID |
%M | Month (MM) |
%N | Tablespace name |
%n | Database name - Right padded with 'x' character e.g. TESTxxxx |
%p | Piece number within backup set |
%s | Backup set number |
%t | Backup set timestamp. Use with %s to provide unique name |
%T | Date (YYYYMMDD) |
%u | Short system generated file name. See below |
%U | Long System generated file name. See below |
%Y | Year (YYYY) |
%% | Percent (%) character |
The following section describes the system-generated names in more detail:
For backup pieces equivalent to %u_%p_%c where:
For image copies depends on file type: