Re: Oracle log files format

From: Simon Gottesman <sgotte_at_prodigy-nospam.net>
Date: Tue, 12 Mar 2002 20:08:33 GMT
Message-ID: <5ftj8.2288$iE7.480297099@newssvr16.news.prodigy.com>

Look at log_archive_format in your init<sid>.ora file or "show parameter
log_archive_format" in svrmgr.  Also, looking in the directory that
log_archive_dest points to and divining the format from how the names of the

archive logs are turning out is another possibility. If you are actually asking about the possible formats that you can put for log_archive_format, here's something I've cut and pasted a while back into my notes:

LOG_ARCHIVE_FORMAT can have the following variables: Parameter Description Example

%T  thread number, left-zero-padded  arch0000000001
%t  thread number, not padded  arch1
%S  log sequence number, left-zero-padded  arch0000000251
%s  log sequence number, not padded  arch251

Hth,
Simon

"lodz" <mjakobczak_at_free.bluenet.pl> wrote in message news:a6kjne$k9o$1_at_kujawiak.man.lodz.pl...
> Can any body know Oracle DB log file format?
>
> Thanks.
>
>
Received on Tue Mar 12 2002 - 14:08:33 CST