Re: Error recovering a database with a read-only tablespace
Date: Thu, 17 Apr 2008 10:33:52 +0100
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.
On 16/04/2008, TESTAJ3_at_nationwide.com <TESTAJ3_at_nationwide.com> wrote:
> David, datafile 1 is the system tablespace datafile, I've not seen that
> An off the wall question did the database have a patchset and/or upgrade
> done to it since the backup was taken? It almost appears as if the header
> in the datafile is either corrupt or did not get converted during an upgrade
> just throwing out some ideas.
> Thanks, Joe
> You can have it: Fast, Right or Cheap, pick 2 of the 3.
> Fast + Right is Expensive
> Fast + Cheap will be incorrect.
> Right + Cheap will take a while.