the "using backup controlfile" is what is known as a open ended
SCN in the command "recover using backup controlfile until cancel;" for
recovery and therefore recovers and applies archive logs generated after
the timestamp at which it was created. Somethnig similar to a standby controlfile.
So even though a cold backup is restored and the above command is used
it would recover and apply the logs beyond the point of time when the backup
was taken.
Maybe a more knowledgeable lister could throw more light on this.
Anjan
"Koivu, Lisa" wrote:
No. The control file
has the current state of the database. It will consider the database
up to date if all the scn's match.
You could fool the database
into rolling forward with a more recent copy of the control file (say at
the time of crash), but if you are recovering with an old version of the
control file (at the time of the day-old backup) you can't make Oracle
apply archive logs that are newer, and have newer SCN's, to the database.
did I explain that clearly?
Ron, try it sometime.
Recovering with a more recent control file is kinda slick :)
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-----Original Message-----
From:
Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
Sent:
Friday, September 21, 2001 3:35 PM
To:
Multiple recipients of list ORACLE-L
Subject:
RE: Oracle Recovery from Cold backup.
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." <rlsmith_at_kmg.com>
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: rlsmith_at_kmg.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).
_____
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: rlsmith_at_kmg.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).
Received on Sat Sep 22 2001 - 03:00:44 CDT
