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

Home -> Community -> Usenet -> c.d.o.server -> Re: Recover question: ALTER DATABASE USING BACKUP CONTROLFILE

Re: Recover question: ALTER DATABASE USING BACKUP CONTROLFILE

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 15 Apr 2003 05:29:47 +1000
Message-ID: <1QDma.14385$1s1.236489@newsfeeds.bigpond.com>


But if *all* you've lost are you redo logs, then you don't need the 'using backup controlfile' command. Incomplete recoveries work perfectly well with the simple command 'recover database until cancel'. Even faked ones.

Regards
HJR "Steve" <smontgomerie_at_hotmail.com> wrote in message news:156709aa.0304140437.6ae1ef65_at_posting.google.com...
> mokat67_at_hotmail.com wrote in message

news:<3e99db18.3088651_at_news.hccnet.nl>...
> > Supposing that I lost my online redo-log files and still in posession
> > of controle and archive files
> >
> > I would like to know what is against the method:
> >
> > A) ALTER DATABASE USING BACKUP CONTROLFILE
> >
> > Instead of:
> >
> > B) Recover Database
> >
> > I know that method (A) is used when the latest control files are not
> > available anymore. But if the current control files still exits is
> > there a reason why not to choose for method (A) in combination with a
> > cold backup restore action? What can be negative consequences if there
> > are any?
> >
> > Thanks
>
> I assume you mean RECOVER DATABASE UNTIL CANCEL USING BACKUP
> CONTROLFILE?
>
> Any - ho...
>
> If you had a clean shutdown and lost your redo logs you could issue
> that statement to open the db and create new logs.
>
> You could not simply issue Recover Database.
>
> To open with new logs Oracle will only let you do so if it believes
> you are performing incomplete media recovery. To to do issue
>
> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
>
> then when prompted for a log type CANCEL <this is faking media
> recovery>
>
> then issue
>
> alter database open restelogs
>
>
> steve
Received on Mon Apr 14 2003 - 14:29:47 CDT

Original text of this message

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