Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reman Recovery Question
amerar_at_iwc.net wrote:
> Quick question here,
>
> I've read all over that if you lose all members of an online redo log
> group, you need to perform incomplete recovery.
>
> Why incomplete recovery? Can you not just shut down the instance,
> recreate new online logs, and then re-open the database? What am I
> missing that you need to recover the database in this case??
>
> Something with the SCN maybe???
>
Sure, assuming it's not the current log group that was completely lost, and your databae is open. If your instance is down however, and the current log group from the time of the crash is gone, incomplete recovery is the only recourse.
-- To reply by email remove "_nospam"Received on Thu Apr 14 2005 - 12:42:18 CDT