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

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