Re: User-managed incomplete recovery in noarchivelog mode
From: Helma <helma.vinke_at_hotmail.com>
Date: Mon, 30 Jun 2008 04:02:31 -0700 (PDT)
Message-ID: <faa77867-e321-405d-8323-9cfca80a4e2c@m73g2000hsh.googlegroups.com>
Date: Mon, 30 Jun 2008 04:02:31 -0700 (PDT)
Message-ID: <faa77867-e321-405d-8323-9cfca80a4e2c@m73g2000hsh.googlegroups.com>
> 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. Received on Mon Jun 30 2008 - 06:02:31 CDT