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: Jared Still <jkstill_at_gmail.com>
Date: Mon, 8 Nov 2004 21:21:53 -0800
Message-ID: <bf463804110821211ffe78e7@mail.gmail.com>


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
Received on Mon Nov 08 2004 - 23:18:06 CST

Original text of this message

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