Re: restoring from backup when db is open

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Fri, 5 Aug 2011 11:54:46 -0300
Message-ID: <CAJ2dSGTgVfHjxKHDG10aBg70D8HWdyQom_dccvmh5o2Y+BKZaQ_at_mail.gmail.com>

Lets assume the latter as if it was the former this question would be pointless and simply "recover database" would solve the "problem" and 20 seconds with google will tell you that.

Also, Norman's recomendation will probably fail with a "Fuzzy Database" error which is why you need to set the hidden parameters I (didn't) mention and open the database allowing corruption.

hth
Alan.-

On Fri, Aug 5, 2011 at 11:17 AM, Kurt Van Meerbeeck <kurtvm_at_telenet.be>wrote:

> Define open ?
> - open as in - running in archivelog mode, putting tablespaces in backup
> mode, take os copy ?
> or
> - open as in - just take an os copy, don't bother about the rest ?
>
> Kind regards,
> Kurt
>
>
> ----- Originele e-mail -----
> Van: "Joseph William Armstrong-Champ" <Joseph.Armstrong-Champ_at_tufts.edu>
> Aan: "ORACLE-L" <oracle-l_at_freelists.org>
> Verzonden: Vrijdag 5 augustus 2011 15:58:49 GMT +01:00 Amsterdam / Berlijn
> / Bern / Rome / Stockholm / Wenen
> Onderwerp: restoring from backup when db is open
>
>
> I’ve always heard that this is not possible but I have to ask because
> it’s our last resort. Is there any way to restore a db from a backup taken
> when the db was open? The backup in question is an os copy to tape.
>
>
>
> Os: win 2003
>
> Db: oracle 9.2.0.7
>
>
>
> Thanks.
>
> Joe
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 05 2011 - 09:54:46 CDT