Re: Are we screwed??

BD wrote:
> >Any help on opening this sucker?
>
> Personally, given that this is a test database, I think your energies
> would be better spent by trashing the db on the test server, reviewing
> your procedures, and doing it all over again until you get it right.
>
> Oracle Support could certainly help you fix this, but to what end? You
> still would not have established exactly what part of your process
> caused the problem in the first place.
>
> My vote: dump the test db, research your procedures until you get it
> sorted out, test and document these procedures so they can be
> replicated by your junior dba without incidcent, take the document,
> boil it in water with some beef broth, and feed it to your junior dba.

That sounds about right to me.

Sure you can do it with rman and at some point learning how exactly is a good learning point.

But you can shutdown production, copy the files, and then re-create control files if needed.

Several different ways to do it but don't blame the junior guy unless you have a plan and procedure that he is supposed to be operating from. Received on Fri Jan 13 2006 - 11:53:30 CST