Re: Error recovering a database with a read-only tablespace
From: David Lord <dlordster_at_gmail.com>
Date: Fri, 18 Apr 2008 09:19:57 +0100
Message-ID: <649030d80804180119u26c87919v368a7bce71f15723@mail.gmail.com>
Date: Fri, 18 Apr 2008 09:19:57 +0100
Message-ID: <649030d80804180119u26c87919v368a7bce71f15723@mail.gmail.com>
Andy,
Aha, that fixed it. The backup was taken after the last resetlogs (18-APR-2008) but the resetlogs_time in v$datafile_header for the read-only datafile is 12-FEB-2007.
Thanks to all who replied.
David Lord
On 17/04/2008, Andy Rivenes <arivenes_at_llnl.gov> wrote:
> Hi David, take a look at Metalink note 266991.1 - Recovering READONLY
> tablespace backups made before a RESETLOGS Open. Since you're in
> noarchivelog mode you may have problems, but this worked for me.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 18 2008 - 03:19:57 CDT