Re: incomplete recovery question

You can do incomplete recovery to recover from different failures. Using it to recover a lost file is one of them. Other scenarios could be when a table is dropped or prior to a corruption of the database etc. So if you are doing incomplete recovery to recover a lost file then you must use the backup controlfile; not any backup controlfile but one which has the information about the lost file. All other cases you can use current controlfile. Thing to remember is all datafiles and only the datafiles (but neither controlfiles nor online redolog files) from a backup should be restored before trying the incomplete recovery. Hope this helps.

raghuvir

In article <wqW_5.5531$Sl.283445_at_iad-read.news.verio.net>,   "Legend" <legend_at_spacelab.net> wrote:
> Hi all,
>
> I am currently working as a Sybase DBA while also picking up some
 Oracle DBA
> work load as well. The first thing I must learn is backup/recovery. I
 am
> reading the Backup and Recovery handbook and have a couple of
 questions that
> I am not too sure. I hope someone can shed some lights on.
>
> In the incomplete database recovery, is it necessary to use the backup
> control file? In page 272-273, it gives an example with T1 and T2
 time. T1
> => full backup, T2 => lost a file. If I want to recover the "lost"
 file, I
> must use the backup controlfile to recover until <time>. However, in
 another
> example in page 279 step(2), it gave a checklist and said "you can
 use the
> current control file" to do an incomplete recovery.
>
> Someone told me that if I want to do an incomplete recovery, I must
 use the
> backup control file because the current control file contains the
 current
> SCN which does not allow to be "rolled back" to an earier number
 which is in
> the case of performing point-in-time recovery. What confuses me in the
> second example is that it uses "alter database open resetlogs" at the
 end.
> This also sounds logical to me because it resets the SCN in all the
 places.
>
> Am I confusing myself or thinking too much? :-)
>
> Thank you very much,
>
> Benny
>
>

Sent via Deja.com
http://www.deja.com/ Received on Sun Dec 17 2000 - 00:13:23 CST