Re: User-managed incomplete recovery in noarchivelog mode
Date: Mon, 30 Jun 2008 13:28:49 +0200
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
>me to open the database? "
>Can't he use the 29th backup, and drop the USER tablespace ? In that
>case, the db should open , i guess. Is that true?
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 DBAReceived on Mon Jun 30 2008 - 06:28:49 CDT