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

From: Andy Rivenes <arivenes_at_llnl.gov>
Date: Thu, 17 Apr 2008 08:51:06 -0700
Message-Id: <7.0.0.16.2.20080417084812.02436318@llnl.gov>


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.

At 02:33 AM 4/17/2008, David Lord wrote:
>Joe,
>
>Thanks for your reply. I think the datafile 1 thing is a red
>herring - everything else points to datafile 13 being the
>problem. I haven't applied any patches or upgrades, but I wouldn't
>be at all surprised if you're right about there being a corruption
>in the datafile header.
>
>Regards
>David Lord
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 17 2008 - 10:51:06 CDT

Original text of this message