Re: v$log_history

From: <>
Date: Thu, 22 May 2008 08:55:04 -0700 (PDT)
Message-ID: <>

Comments embedded.
On May 22, 10:01 am, "Uwe Schmidt" <> 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

Original text of this message