Re: User-managed incomplete recovery in noarchivelog mode

On Mon, 30 Jun 2008 04:02:31 -0700 (PDT), Helma <helma.vinke_at_hotmail.com> wrote:

>
>> Your only choice is to restore the backup of June 28, pray and forget
>> about anything that happened after June 28.
>> If that doesn't work, your database is toast, thanks to the decision
>> of someone to run in NOARCHIVELOG.
>
>
>" The tables in USERS tablespace is NOT important, is there any way
>for
>me to open the database? "
>
>Sybrand,
>
>Can't he use the 29th backup, and drop the USER tablespace ? In that
>case, the db should open , i guess. Is that true?
>
>H.

Helma, he could try if he

- restored the db from 29 (including controlfiles)
- MOUNTED the database
- OFFLINED the datafile for the users tablespace
- open the database and drop the users tablespace.

Note: ALL files are from 1 backup!

-- 
Sybrand Bakker
Senior Oracle DBA