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).
