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
At 03:39 AM Tuesday, Bobak, Mark wrote:
>You shouldn't replace the controlfile w/ a backup unless it's
>missing or corrupted.
>
>--
>Mark J. Bobak
>
>
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
>Sent: Monday, January 14, 2008 2:28 PM
>To: oracle-l_at_freelists.org
>Subject: RE: URGENT 8.1.7 recovery question
>
>I neglected to mention that I will replace the controlfiles
>(correct?) With the ones from the backup.
>
>Seems like I have to a 'recover database using backup controlfile
>until time to_date('01/14/2008 12:31:00','MM/DD/YYYY HH24:MI:SS');
>
>But that seems an abnormally long command.
>
>A little help? J
>
>Chris Taylor
>Sr. Oracle DBA
>
>----------
>
>

Hemant K Chitale
http://hemantoracledba.blogspot.com

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