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: Reman Recovery Question

Re: Reman Recovery Question

From: Chuck <skilover_nospam_at_softhome.net>
Date: Thu, 14 Apr 2005 13:42:18 -0400
Message-ID: <1113499931.745800258e913e806734fe267e560e00@bubbanews>


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

Original text of this message

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