Re: strange select issue

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Mon, 22 Sep 2003 17:19:14 +0100
Message-Id: <1064247591.78887.0@eunomia.uk.clara.net>

> Section 9 in the control file is for keeping track of your archived redo
> logs. First, find out what your CONTROL_FILE_RECORD_KEEP_TIME parameter
> is set to. It may be the default of 7. Second, issue the following
> query:
>
> SELECT * FROM v$controlfile_record_section WHERE type='LOG HISTORY';
>
> What is the output from above?

SELECT * FROM v$controlfile_record_section WHERE type='LOG HISTORY';

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

----------------- ----------- ------------- ------------ ----------- ----------

LAST_RECID

LOG HISTORY                36         65535        65535       50568      50567

572525

> You may have to rebuild the control file to fix this problem. You can
> try setting CONTROL_FILE_RECORD_KEEP_TIME to '0'.

where would i find this? in the init.ora file?

> You may also be hitting a bug which was fixed in Oracle 8.0.6. What
> version are you running?

we are seeing this on 8.1.5 so i don't think that bug will apply

thanks again Received on Mon Sep 22 2003 - 11:19:14 CDT