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: HotBackup Dilema

Re: HotBackup Dilema

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 18 Dec 2002 23:06:09 +1000
Message-ID: <BhZL9.5769$jM5.16752@newsfeeds.bigpond.com>


"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:TSLL9.5143$jM5.15117_at_newsfeeds.bigpond.com...
> "Startup" on its own means 'startup open', so the command is attempting to
> completely open the database.
>
> It would appear, however, that a previous incomplete recovery has been
> performed, and this is still awaiting the 'alter database open resetlogs'
> command to terminate it.
>
> Incomplete recoveries are performed either (a) after a user stuff-up (such
> as 'Ooops. I just deleted the entire sales table and hit the commit button
> instead of the rollback one') or (b) when there's a gap in your stream of
> redo which prevents a complete recovery succeeding.

Hi Howard

Or (c), as you mention at some other point, a binary copy of a control file was used to recover from the loss of all controlfiles (when in most cases, the trace file would have been a better option)

Richard Received on Wed Dec 18 2002 - 07:06:09 CST

Original text of this message

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