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: Disaster Recovery HELP!!

Re: Disaster Recovery HELP!!

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 12 Nov 2000 12:47:33 +1100
Message-ID: <3a0df6ee$1@news.iprimus.com.au>

Are you positive you restored ALL data files, and not just one or two?

Incomplete recovery requires that the entire set of data files is taken back to an earlier, consistent time, and then rolled forward to a given point. Synchronisation with the Control Files and Redo Logs is then forced with a resetlogs.

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


"George" <corcorang_at_my-deja.com> wrote in message
news:8ukrgt$t4q$1_at_nnrp1.deja.com...

> In article <3A0C33B5.CA1843FE_at_home.nl>,
> Frank van Bortel <fbortel_at_home.nl> wrote:
> > Did you just _hit_ cancel, or type the word 'cancel'?
> > For the first, it figures, you're still recovering. When the latter,
> > I'll leave it for the dba's
> >
>
> Ok i did just click cancel so i restored everything again and this time
> typed cancel but the same error came up Ora 01195 and 01110 data file
> 1 needs more recovery to be consistent. Any other Ideas Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Nov 11 2000 - 19:47:33 CST

Original text of this message

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