RE: URGENT 8.1.7 recovery question
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <Chris.Taylor@xxxxxxxxxxxxxxx>
- Date: Tue, 15 Jan 2008 23:35:09 +0800
Thomas,
Yes , you are right. Per the syntax, the incomplete recovery
can be done even with the current controlfile.
My incomplete recoveries have always been with backup controlfiles.
Hemant K Chitale
At 10:55 PM Tuesday, Mercadante, Thomas F (LABOR) wrote:
Hemant,
Just a question about your response.
If he has his current control files, he can recover to any point in time
without using backup control files, right? As long as he has all of his
archivelog files, he can spin his database in any direction to any point
in time.
If he has lost his control files, then his options are different - he
has to recover them first.
Just clarifiying for my own mind.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hemant K Chitale
Sent: Tuesday, January 15, 2008 9:45 AM
To: Mark.Bobak@xxxxxxxxxxxx; Chris.Taylor@xxxxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: URGENT 8.1.7 recovery question
Chris,
If you need to recover the database until a specific point in time in
the past you must use the backup controlfile. Your command would be
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL ...
{if you're recovering upto a specific archivelog, you could specify
UNTIL that log file or just UNTIL CANCEL and issue a CANCEL command
after applying that last archivelog}.
Since that would be an Incomplete Recovery you must OPEN RESETLOGS.
If, however, you do have the current controlfiles AND the online redo
log files intact you can do a complete recovery (right upto the last
transaction in the online redo log) using the _current_ controlfile.
Then your command would
be RECOVER DATABASE {not with the "BACKUP CONTROLFILE", not
with the "UNTIL..." syntax}.
That would be a Complete Recovery and you do not need to (should not
have to) OPEN RESETLOGS.
Hemant K Chitale
Hemant K Chitale
http://hemantoracledba.blogspot.com
"There is more to life than increasing its speed."
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
