From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: <8uhgjn$e9n$1@nnrp1.deja.com> <3A0C33B5.CA1843FE@home.nl> <8ukrgt$t4q$1@nnrp1.deja.com> Subject: Re: Disaster Recovery HELP!! Lines: 34 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Original-NNTP-Posting-Host: 203.134.152.227 Message-ID: <3a0df6ee$1@news.iprimus.com.au> X-Original-Trace: 12 Nov 2000 12:48:30 +1100, 203.134.152.227 Date: Sun, 12 Nov 2000 12:47:33 +1100 NNTP-Posting-Host: 203.134.64.67 X-Trace: news0.optus.net.au 973993711 203.134.64.67 (Sun, 12 Nov 2000 12:48:31 EST) NNTP-Posting-Date: Sun, 12 Nov 2000 12:48:31 EST Organization: CWO Customer - reports relating to abuse should be sent to abuse@optus.net.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" wrote in message news:8ukrgt$t4q$1@nnrp1.deja.com... > In article <3A0C33B5.CA1843FE@home.nl>, > Frank van Bortel 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.