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@xxxxxxx> 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 > > -- > //www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l