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:[EMAIL PROTECTED]] >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: [EMAIL PROTECTED] >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
