Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: archive_log_format
oraclei_at_host xxx1> sys
SQL*Plus: Release 10.1.0.4.0 - Production on Thu Oct 6 09:07:31 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected.
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Raj
On 10/6/05, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> Just a wild shot in the dark: what is compatible set at?
>
> rjamya wrote:
> > for some reason it is 0 in my 10.1.0.4 <http://10.1.0.4> database.
> >
> > Raj
> >
> > On 10/5/05, Mark Bole <makbo_at_pacbell.net> wrote:
> >
> >>V$DATABASE_INCARNATION.RESETLOGS_ID column.
> >>
> >>rjamya wrote:
> >>
> >>
> >>>does anyone know where the %r (resetlogs ID that ensures unique names
> >>>are constructed for the archived log files across multiple incarnations
> >>>of the database
> >>>) value comes from in constructing archive log file name??
> >>>
> --
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com <http://www.centrexcc.com>
>
-- ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY'; -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 06 2005 - 08:11:51 CDT
![]() |
![]() |