Re: done something dumb!

From: Antoine BRUNEL <antoinebrunel/yahoo.fr>
Date: Sun, 8 Aug 2004 04:27:39 +0200
Message-ID: <41158f9b$0$22895$79c14f64@nan-newsreader-04.noos.net>

Hi from Paris

if you ever destroy all members of an active online redo logs group, "tu es dans la merde" !!!

in this case, and if this occurs on a production db, call Oracle Support and ask them about _allow_resetlogs_corruption...

this will allow you to full export you db, in order to create another one (cause previous will be fuzzy)

Cdlt

"Tom" <tomNOSPAM_at_teameazyriders.com> a écrit dans le message de news:1091795514.76376.0_at_dyke.uk.clara.net...
> Hi
>
> 9.2.0.4 on Linux
>
> This is thankfully a dev instance but.....
>
> In the process of me testing RMAN recovery from one instance to another i
accidentally deleted all online redo and replaced all the
> control files with backup ones! Oops. Kinda got mixed up as to which box i
was on during the process.
>
> Anyway - Everything is unning OK and i can login and do the selects etc
but i'm wondering what will happen over time. Will it just
> work OK and online redo's get recreated? Or will it all die horribly and i
will have to recreate it correctly from backup?
>
> thanks
>
>
Received on Sat Aug 07 2004 - 21:27:39 CDT