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

From: David Lord <dlordster_at_gmail.com>
Date: Thu, 17 Apr 2008 10:33:52 +0100
Message-ID: <649030d80804170233r70a5a4a5hb3698855badf93c@mail.gmail.com>


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

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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 17 2008 - 04:33:52 CDT

Original text of this message