So, BACKUP AS COPY behaved differently from BACKUP AS BACKUPSET when it
viewed the supposedly corrupt block ?
Hemant K Chitale
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mladen Gogala
Sent: Wednesday, December 09, 2015 12:27 PM
To: Andrew Kerber
Cc: oracle-l-freelists
Subject: Re: Block media recovery with standard edition
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
This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html
