Re: User-managed incomplete recovery in noarchivelog mode

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 30 Jun 2008 13:07:03 -0700
Message-ID: <1214856413.121966@bubbleator.drizzle.com>


Helma 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.

http://www.psoug.org/reference/tablespaces.html Look up "Drop tablespace afgter datafile was accidentally dropped"

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jun 30 2008 - 15:07:03 CDT

Original text of this message