RE: control file contents

Guy,

I assume the database involved in 8.0 or higher :) Starting 8.0, the control files retain the list of archive logs in addition to recording both the list of database and redolog files. In fact, I found that it retains a list of backup controlfiles too... The list size for archive logs seems to be controlled by a combination of the init parameter 'control_file_record_keep_time' and the MAXLOGHISTORY. I haven't been able to test this, but if select count(*) from v$log_history is less than MAXLOGHISTORY, then I am willing to bet that you will see a list of all archive logs since database create...

Nice to reply to a question from you after a long time!

John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

>-----Original Message-----
>From: Guy Hammond [mailto:guy.hammond_at_avt.co.uk]
>Sent: Tuesday, October 02, 2001 7:50 AM
>To: Multiple recipients of list ORACLE-L
>Subject: control file contents
>
>
>Hello,
>
>Out of curiosity just now, I ran "strings" on a backup of my control
>file. In it, there are lots of repeated references to archive log files
>- there are groups log file names, and the same name might appear in
>multiple groups. Is this a list of the redo logs that you would need to
>recover the database from the time of the previous backup to the time
>that the control file was written? Because, looking in my archive log
>destination, these are a lot older than the last hot backup.
>
>Cheers,
>
>g
>
>
>--
>Guy Hammond
>AVT Technologies
>12-16 Westland Place
>London N1 7LP UK
>
>Email: guy.hammond_at_avt.co.uk
>Office: +44 (0) 207 454 1224
>Mobile: +44 (0) 7966 164687
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Guy Hammond
> INET: guy.hammond_at_avt.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).