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

  • From: "David Lord" <dlordster@xxxxxxxxx>
  • To: "Andy Rivenes" <arivenes@xxxxxxxx>
  • 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.
David Lord

On 17/04/2008, Andy Rivenes <arivenes@xxxxxxxx> 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.

Other related posts: