Re: Block media recovery with standard edition
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 8 Dec 2015 23:26:55 -0500
Message-ID: <5667AD8F.70202_at_gmail.com>
On 12/08/2015 06:53 PM, Andrew Kerber wrote:
> Do you have a time when you could safely move the indexes to a new
> table space? Then drop the tablespace.
Date: Tue, 8 Dec 2015 23:26:55 -0500
Message-ID: <5667AD8F.70202_at_gmail.com>
On 12/08/2015 06:53 PM, Andrew Kerber wrote:
> Do you have a time when you could safely move the indexes to a new
> table space? Then drop the tablespace.
Thanks Andrew! That was a good idea. However, the time was of the essence, so I had to be a bit more creative. I used "backup as copy datafile 36", then switched to the copy and lo and behold, the corrupt blocks were absent from the copy. The only thing left was to drop the original copy of datafile, copy the correct one back from +FRA to +DATA and switch back to the +DATA diskgroup. Essentially, "backup as copy" seems to eliminate the corrupt empty blocks. I learned something tonight. Regards
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 09 2015 - 05:26:55 CET