Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: too much references to old archive log in v$history_log
drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0302241602.b3eb877_at_posting.google.com>...
> The number of files kept in the log history is most likely kept in the
> controlfile. If you execute the following statement:
> (assuming that you have the privileges to do so)
>
> SQL> alter database backup controlfile to trace;
>
> And examine trace file created in \udump,
> you will see the current maxloghistory parameter specified.
> I believe that you need to re-create the controlfile to alter this
> parameter, which means that your existing loc history will be cleared.
Actually, it's resetlogs that does the cleanup. Recreating the controlfiles can do this. But you can also use other methods to reset logs, such as a fake incomplete recovery (recover database until cancel).
Yong Huang Received on Tue Feb 25 2003 - 13:27:21 CST