RE: URGENT 8.1.7 recovery question

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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
>Sent: Tuesday, January 15, 2008 9:45 AM
>To: Mark.Bobak_at_proquest.com; Chris.Taylor_at_ingrambarge.com;
>oracle-l_at_freelists.org
>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

--
http://www.freelists.org/webpage/oracle-l