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

  • From: "David Lord" <dlordster@xxxxxxxxx>
  • To: "TESTAJ3@xxxxxxxxxxxxxx" <TESTAJ3@xxxxxxxxxxxxxx>
  • Date: Thu, 17 Apr 2008 10:33:52 +0100

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@xxxxxxxxxxxxxx <TESTAJ3@xxxxxxxxxxxxxx> 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.
>
>

Other related posts: