Re: Error recovering a database with a read-only tablespace

From: David Lord <>
Date: Fri, 18 Apr 2008 09:19:57 +0100
Message-ID: <>


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

Received on Fri Apr 18 2008 - 03:19:57 CDT

Original text of this message