Re: How to apply archive logs on an cold backup

From: Tim Kearsley <tim.kearsley_at_milton-keynes.gov.uk>
Date: 1 Sep 2004 01:27:58 -0700
Message-ID: <725736ef.0409010027.32153fa8@posting.google.com>

Depending on what was behind the OP question, I'm not sure that Bob was writing "complete nonsense".

A few "ifs":

1. If you have a database in ARCHIVELOG mode and
2. If all you have available is an old, cold backup and
3. If you have all archive logs available since your old, cold backup and
4. If you have a control file creation script (e.g. the output of a BACKUP CONTROLFILE TO TRACE)

then you can recover your database back to the current point in time by issuing a RECOVER DATABASE USING BACKUP CONTROLFILE... can't you?

A lot of "ifs" I know, but the principle is sound I believe, and I have done it myself on one occasion.

Regards,

Tim Kearsley
HBS
Milton Keynes Council

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41351d6f$0$9811$afc38c87_at_news.optusnet.com.au>...
> Bob Jones wrote:
>
> >
> > "robson" <dbanewbie_at_yahoo.com.br> wrote in message
> > news:514f866a.0408311326.68c5d22d_at_posting.google.com...
> >> i have the database with archive log and one cold backup.
> >> how to apply archive log in cold backup?
> >>
> >> thanks,
> >> robson
> >
> > You can specify "RECOVER DATABASE...USING BACKUP CONTROLFILE". This will
> > allow you roll forward to a point of your desire.
>
> Please don't post complete nonsense.
>
> The 'using backup controlfile' clause should only be specified if that's,
> strangely enough, actually what you're using. Unless he restores his
> control files from backup, it would be lunacy to use the clause.
>
> Never mind that an unnecessary use of the clause requires an unnecessary
> resetlogs, with all the massive downtime and requirement to re-backup the
> database that brings.
>
> If he loses one DBF, replace that DBF and issue just plain old 'recover
> datafile X'. If he loses multiple DBFs, restore those DBFS and issue a
> plain old 'recover database'. If he loses all his control files, then
> restore the control file and issue a 'recover database using backup
> controlfile'.
>
> If you don't know how to recover a database, that's fine. But don't mislead
> others who are looking for assistance, OK?
>
> HJR
Received on Wed Sep 01 2004 - 03:27:58 CDT