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>
>
>
> " 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.
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.orgReceived on Mon Jun 30 2008 - 15:07:03 CDT