Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle log files format

Re: Oracle log files format

From: Simon Gottesman <sgotte_at_prodigy-nospam.net>
Date: Wed, 13 Mar 2002 18:15:53 GMT
Message-ID: <tHMj8.2739$i%6.573401274@newssvr16.news.prodigy.com>


Hello Marek,
I'm still not exactly sure what you're asking. If you're talking about naming convention formats, you supply your own as you please during the "create logfile etc." cmd. If you're talking about a format for reading the information inside a log file, then you need something like Logminer to do that job. Can you elaborate what format it is exactly that you're looking for? Is it one of the above 2?
Hth,
Simon

"lodz" <mjakobczak_at_free.bluenet.pl> wrote in message news:a6n6f3$qv0$1_at_kujawiak.man.lodz.pl...
> 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 - 12:15:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US