Re: v$log_history
Date: Thu, 22 May 2008 08:55:04 -0700 (PDT)
Message-ID: <b9df0b7c-cb92-4e79-a090-6a96ea931790@79g2000hsk.googlegroups.com>
Comments embedded.
On May 22, 10:01 am, "Uwe Schmidt" <uwe.schm..._at_dataport.de> wrote:
> Hy NG,
>
> how long are the entries stored in the view v$log_history ?
Until the FIRST_CHANGE# is less than the ARCHIVE_CHANGE# in v $database. The value in ARCHIVE_CHANGE# is the SCN below which redo logs are forced to be archived.
> I looked into 2 diffrent databases and saw diffrent entries; 1= 2weeks ***
And the ARCHIVE_CHANGE# in each indicates the earliest entry you'll see in V$LOG_HISTORY.
> 2=3month ??? Wher can i customize the time how long the entries are stored?
You'll need to create a new controlfile to change this, as this is controlled by the MAXLOGHISTORY parameter. An 'alter database backup controlfile to trace;' command will provide the currently set parameters in a script you can modify to increase or decrease the MAXLOGHISTORY value.
>
> So long
> Uwe
David Fitzjarrell Received on Thu May 22 2008 - 10:55:04 CDT