Re: Is there a limit of rows in V$ARCHIVED_LOG

In our last gripping episode Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> Howard,
>
> I did some more checking on this...
>
> If I look at the entries in V$ARCHIVED_LOG, I can see that the entries
> go back exactly 7 days!! This matches my CONTROL_FILE_RECORD_KEEP_TIME
> parameter. If I examine my control file, I can see that I have
> MAXLOGHISTORY set to 3630. But my V$ARCHIVED_LOG view only contains
 1524
> entries for those 7 days. So it seems to me that the
> CONTROL_FILE_RECORD_KEEP_TIME parameter is the factor that determines
> how long entries are kept in V$ARCHIVED_LOG.
>
> More food for thought...
> Brian
>
> "Howard J. Rogers" wrote:
> >
> > "Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message
> > news:3A6DA7C9.CABE38BF_at_edcmail.cr.usgs.gov...
> > > > I may be hopelessly wrong about this, but I could almost swear
 that
> > > > control_file_record_keep_time only becomes of relevance when
 using RMAN
> > > > without a catalogue, and that the real problem is maxloghistory
 when
> > > > creating the database.
> > >
> > > Actually, I thought that it was somewhere in the middle....
> > >
> > > I believe that the MAXLOGHISTORY is as you say it to be. But the
> > > CONTROL_FILE_RECORD_KEEP_TIME does *not only* apply to RMAN. I've
 never
> > > used RMAN on any of my databases. But when I migrate a database,
 I will
> > > see my control file expand for the number of days specified in
 the above
> > > parameter. This is due to the control file having to capture more
> > > information than the previous db version. So the control file
 expands in
> > > size. Once the CONTROL_FILE_RECORD_KEEP_TIME number of days has
> > > passed,the control file doesn't have to expand since it can write
 over
> > > previous information. If one uses RMAN, then RMAN gets
 information from
> > > the control file and it can go back the number of days specified
 in this
> > > parameter. So this parameter must be adjusted if you want RMAN to
 go
> > > back far enough. IIRC, I believe the default for this parameter
 is 7
> > > days (Oracle 8i on Solaris).
> > >
> > > Of course, this is just my experiences with a not so obviously
> > > documented parameter and I could be wrong......
> > >
> > > Brian
> > >
> >
> > Hi Brian -well, you're dead right that the default for keep_time is
 7 days.
> > I guess there's likely an interaction between the two things as
 well. Live
> > and Learn, eh!?
> >
> > Regards
> > HJR
> >
> > >
> > > --
> > > ========================================
> > > Brian Peasland
> > > Raytheons Systems at
> > > USGS EROS Data Center
> > > These opinions are my own and do not
> > > necessarily reflect the opinions of my
> > > company!
> > > ========================================
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
>

Every once in a great while I get one right...

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/