Re: HELP: Recover from inconsistent backups

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 18 Feb 2000 17:55:09 +0100
Message-ID: <950894291.9776.2.pluto.d4ee154e@news.demon.nl>

An inconsistent HOT backup on an instance running in NOARCHIVELOG!!!! Running hot backup precludes use of NOARCHIVELOG, you MUST run in ARCHIVELOG.
That said: alter database open resetlogs and of course you will loose everything that happened beyond the point you issue this statement, but there seems to be no other option, the predictable disaster already occurred.

Hth,

Sybrand Bakker, oracle DBA

<schud_at_pegasystems.com> wrote in message news:88jol9$3d5$1_at_nnrp1.deja.com...
> Anyone know of a trick to recover from an inconsistent hot backup taken
> of a NOARCHIVELOG DB (Ora8 on Sun Solaris).
>
> Every time I try to restore I get messages saying that certain files
> still need media recovery. Can I force my way around this and just
> open the db to get at the data.
>
> Don Schuerman
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 18 2000 - 10:55:09 CST