Block corruption Error.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Block corruption Error.

vinod kale
Hello Team,

We have generated one scenario for learning purpose regarding block corruption. 
We have manually corrupt the one table file at disk level and after queried to that table we got below attached error.
So could you please help me out in below scenario?
What is the best method to resolve below error. ?

PFA screenshot.

Thanks in advance !!!

--
Thanks & Regards,
Vinod Kale

IMG-20200602-WA0015.jpg (99K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Block corruption Error.

Adam Scott

On Tue, Jun 2, 2020 at 8:12 AM vinod kale <[hidden email]> wrote:
Hello Team,

We have generated one scenario for learning purpose regarding block corruption. 
We have manually corrupt the one table file at disk level and after queried to that table we got below attached error.
So could you please help me out in below scenario?
What is the best method to resolve below error. ?

PFA screenshot.

Thanks in advance !!!

--
Thanks & Regards,
Vinod Kale
Reply | Threaded
Open this post in threaded view
|

Re: Block corruption Error.

vinod kale
Hi Team,

Thanks for ur response.
But this url is not helping me. Could you please provide proper steps or accurate solution to resolve the same. 

On Tue, 2 Jun 2020, 21:20 Adam Scott, <[hidden email]> wrote:

On Tue, Jun 2, 2020 at 8:12 AM vinod kale <[hidden email]> wrote:
Hello Team,

We have generated one scenario for learning purpose regarding block corruption. 
We have manually corrupt the one table file at disk level and after queried to that table we got below attached error.
So could you please help me out in below scenario?
What is the best method to resolve below error. ?

PFA screenshot.

Thanks in advance !!!

--
Thanks & Regards,
Vinod Kale
Reply | Threaded
Open this post in threaded view
|

Re: Block corruption Error.

Jeff Janes
In reply to this post by vinod kale
On Tue, Jun 2, 2020 at 11:11 AM vinod kale <[hidden email]> wrote:
Hello Team,

We have generated one scenario for learning purpose regarding block corruption. 
We have manually corrupt the one table file at disk level and after queried to that table we got below attached error.
So could you please help me out in below scenario?
What is the best method to resolve below error. ?

I don't understand what you are asking.  You intentionally created corruption, so now you have corruption.  Restore from a backup plus archived WAL files, or promote your standby, or do whatever your recovery plan dictates.

Of course you could just edit the file and reverse whatever it is you did (while the db is shutdown), but that would not constitute a  plan.

Cheers,

Jeff
Reply | Threaded
Open this post in threaded view
|

Re: Block corruption Error.

Michaeldba@sqlexec.com
Loop thru the affected tables using primary key or ctid and catch exception rows and delete them


Sent from my iPhone

On Jun 4, 2020, at 10:50 AM, Jeff Janes <[hidden email]> wrote:


On Tue, Jun 2, 2020 at 11:11 AM vinod kale <[hidden email]> wrote:
Hello Team,

We have generated one scenario for learning purpose regarding block corruption. 
We have manually corrupt the one table file at disk level and after queried to that table we got below attached error.
So could you please help me out in below scenario?
What is the best method to resolve below error. ?

I don't understand what you are asking.  You intentionally created corruption, so now you have corruption.  Restore from a backup plus archived WAL files, or promote your standby, or do whatever your recovery plan dictates.

Of course you could just edit the file and reverse whatever it is you did (while the db is shutdown), but that would not constitute a  plan.

Cheers,

Jeff