Sorry to all if this is a little late, we're got smacked by that NIMDA virus.
Anyway, If you have a full cold backup as you specify then all of the
archive log files from after that backup 'do not exist'. The idea of a cold
backup is to establish a point in time backup that can be used without recovery.
What you should have at a minimum is a copy of the current control file.
Otherwise the 'recover database' command will return an error.
Dick Goulet
____________________Reply Separator____________________
Author: "Smith; Ron L." <[EMAIL PROTECTED]>
Date: 9/21/2001 11:35 AM
I know, but the point is Oracle doesn't know anything about the archive
logs, it just takes whatever you feed it until you cancel.
Correct?
Ron
-----Original Message-----
Sent: Friday, September 21, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L
As long as you have all archived log files in log archive destination
directory, which is defined in init.ora, you don't have to do anything but
type 'auto' while doing recovery. Oracle will automatically apply all
necessary archive log files and then you need to open database.
"Smith, Ron L." <[EMAIL PROTECTED]> wrote:
I have a "what if" question.
Say you had a complete cold backup, including control files from a few days
ago.
You also had all the archive logs for the past few days.
Today you lost your server and had to recover.
You lay down all the database files, including the control files.
Now you want to apply your archive logs.
Oracle can't know about the archive logs because all the files you restored
are old.
Do you just tell Oracle where the archive logs are and it keeps aplying them
until
you say you are finished?
Just wondering.
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
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).
_____
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information in Yahoo!
<http://rd.yahoo.com/mail_us/tag/?http://dailynews.yahoo.com/fc/US/Emergency
_Information/> News.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
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:
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).
