Re: HELP - corrupted test scheme - V 8.05

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Mon, 13 Jul 2009 05:06:55 -0700 (PDT)
Message-ID: <3ab504be-8ca8-4c4e-8942-04d80d7c3088_at_z28g2000vbl.googlegroups.com>

On Jul 12, 6:30 pm, Palooka <nob..._at_nowhere.com> wrote:

snip

Someone suggested trying this ...

> Is the data important?
> 1) Backup
> 2) Startup mount
> 3) Drop tablespace test
> 4) Alter database open

One option is to substitute for 4 a recover database until cancel using backup controlfile ... then apply archive logs ( if you have them ) ... then do an alter database open resetlogs ... followed by another backup. Received on Mon Jul 13 2009 - 07:06:55 CDT