RelationalDBDesign RelationalDBDesign


Archiving Redo log   «Prev 

Naming Conventions for archive Log Files

Archive format
Archive format

log_archive_format The initialization parameter that specifies the format of archived log filenames.
log_ Archived log filenames will start with these characters.
%s Places the log sequence number into the name.
%t Places the thread number into the name.
The numbers 387-389 The log sequence number as it will appear in the actual filename.
The three "1"s The thread number as it will appear in the actual filename.
%T The thread number in a fixed-width format.
%S The log sequence number in a fixed-width format.
The three 001s The thread number appears as 001.
00387 - 00389 The log sequence numbers also appear with leading zeros.