Re: Error recovering a database with a read-only tablespace
Date: Fri, 18 Apr 2008 09:19:57 +0100
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.
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.