Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HotBackup Dilema
"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