Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recover database using backup controlfile

Re: Recover database using backup controlfile

From: Sultan Syed <ssyed_at_fine.ae>
Date: Tue, 9 Nov 2004 10:00:52 +0400
Message-ID: <001501c4c621$78124460$05000081@SULTAN1>


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-l
Received on Mon Nov 08 2004 - 23:57:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US