Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recover database using backup controlfile
Thanks Jared
that would be:
recover database until cancel using backup controlfile;
Note that it is possible to rearrange this syntax to say something like
recover database using backup controlfile until cancel; ... which will not work. At least not the way you expect.
The Velpuri book has still not outlived its usefulness. :)
Jared
On Tue, 9 Nov 2004 09:01:03 +0400, Sultan Syed <ssyed_at_fine.ae> wrote:
> Hi guys
> I have doubt in backup sceneries
>
> For example I have lost my control file,and some of the datafiles and all
Redo logs.
> So I restored control file from last backup and
> data files from inconsistent backups and
> Redo from some other backups
>
> Now how control file will identify upto which SCN it has to
> perform recovery,since all the SCN are different in datafiles
> and Redo also is old.
>
> Thanks is advance
> Syed
>
> --
> http://www.freelists.org/webpage/oracle-l
>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 08 2004 - 23:57:02 CST