Re: Oracle log files format

Hello,

I rather think about the physical redo log file format, but thanks Simon.

Marek

Użytkownik "Simon Gottesman" <sgotte_at_prodigy-nospam.net> napisał w wiadomości news:5ftj8.2288$iE7.480297099_at_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 Wed Mar 13 2002 - 03:34:10 CST