What to do when a database is corrupted?

wanani Posted messages 1 Status Member -  
 Anton -
Hello and thank you in advance.

4 answers

steven44220 Posted messages 168 Status Member 15
 
blux instead of giving stupid answers like that you should respond, right????
and personally, saying stupid things dares everything, you are one of the first, and yeah, you are an idiot who dared to say that phrase. :)

let me know if you appreciated what I just told you.

wanani:

generally, a corrupted database is practically irreparable, unless you have sophisticated material, the equipment costs easily €3,000 at a minimum to repair that.

unless I'm mistaken about something else, but it doesn't seem like I am; if I am mistaken, let me know right away because right now I'm in my period of bad information about breakdowns, etc.... lol
1
blux Posted messages 2021 Registration date   Status Moderator Last intervention   3 452
 
blux instead of giving stupid answers like that you should respond right????
and personally by saying the stupid one dares everything, you are one of the first, and yeah you are a fool who dared to put that phrase there. :)

:-/

you'll tell me if you appreciated what I just said to you.
Aside from the pitiful spelling, I will respond to your arguments...

generally a corrupted database is almost irreparable, unless you have sophisticated material costing at least 3,000 € to repair it.
unless I'm mistaken about something else but it doesn't seem so to me, if I am wrong someone tell me right away because at the moment it's my period of bad information about failure etc.... lol

So I will say it right away...

A database must remain consistent, there are a whole bunch of internal and external mechanisms to ensure that consistency (logs, transaction rollbacks...).
However, there are cases in which consistency can no longer be guaranteed: hardware errors (damaged physical media) or functional errors (bad treatments applied to the database).

In this case, only an analysis of the corruption (visible effects, error messages...) can provide indications on how to repair or on the impossibility of repair.

In the absence of specific elements provided by the requester: type of database, type of corruption (I/O error, Oracle control file, for example), my answer, like that of any database specialist, cannot be more precise...

Your answer only concerns the 'disk error' aspect, which, most of the time, does not happen, because the majority of production databases are stored on arrays managed in RAID (5 or 1, even 15 or 51) with synchronous (two-phase commit) or asynchronous (global mirror replication at IBM or SRDF at EMC²) replications

So yes, I am surely a fool, but I have been assuming my motto for over 10 years, it only bothers those who are not used to it...
0
steven44220 Posted messages 168 Status Member 15
 
And well, when you don't have enough information, act like a professional and ask for more details about mistakes, etc.

A professional will never tell you, for example, if you don't know how to use a computer, don't use it, or something like that. Even if the client speaks up, they'll tell you it's their quote; the client is clear, and they will never come back.

So, if you think like a professional, react like a pro.
1
blux Posted messages 2021 Registration date   Status Moderator Last intervention   3 452
 
And well, when you don't have enough information, act like a professional and ask for more information, the errors, etc...
This site has a charter that, among other things (in addition to an effort on spelling, which you don't seem willing to make), requires that questions be precise enough, whereas, in this case, the question is stated in the title of the message and no detail is provided.

We have outgrown riddles.

https://www.commentcamarche.net/infos/25857-charte-de-commentcamarche-net-conseils-d-ecriture/
0
steven44220 Posted messages 168 Status Member 15
 
blux:

Do as you want, but in that case, don’t talk about professionalism when you don’t react like a professional; you think like one, but you don't react like one.

Moreover, sure, spelling isn't my strong suit, and my keyboard needs to be replaced. Sure, the question is posed in the title, and there is another way instead of a slogan like that to ask for more information.

Sure, we’ve outgrown guessing games, and so what? That doesn't prevent there being another way to ask for information.

And for your information, when you see a professional, you’re going to tell them, "Here’s what’s happening to me, is it fixable?" They’ll say yes, but they also tend to ask, "Does it make this sound, does it do that, etc."

So professionals also ask you questions about your machine.
0
blux Posted messages 2021 Registration date   Status Moderator Last intervention   3 452
 
In that case, don't talk about professionalism
It's you who brought it up, not me...
0
steven44220 Posted messages 168 Status Member 15
 
In the absence of specific elements provided by the requester: type of database, type of corruption (I/O error, Oracle control file, for example), my answer, like that of any database specialist cannot be more precise...

this is a copy-paste of one of your responses; if specialist does not mean professional, what does it mean?
0
blux Posted messages 2021 Registration date   Status Moderator Last intervention   3 452
 
I have never claimed to be a database specialist; it's you who interprets the meaning of the sentence. But since your spelling hurts the eyes, I think you must also have semantic problems, which the excuse of needing to change your keyboard does not justify...
0
jee pee Posted messages 31858 Registration date   Status Moderator Last intervention   9 963
 
Hi,

Another generic response.

We take the last backup (which shouldn't be older than yesterday ;-) and restore it.

Best regards

--
A stranger is a friend we haven't met yet.
0
blux Posted messages 2021 Registration date   Status Moderator Last intervention   3 452
 
Except that in a massively transactional environment, like banks, insurance companies, financial markets, it's not going to work...
0
jee pee Posted messages 31858 Registration date   Status Moderator Last intervention   9 963
 
There you will have implemented transaction logs and you will revert to the last complete backup on which you apply the redo logs.
0
blux Posted messages 2021 Registration date   Status Moderator Last intervention   3 452
 
When you are in 365/24, it is not sustainable.
That is why I spoke about replication (synchronous or asynchronous).
0
Anton
 
I have the same problem, AdwCleaner (by Xplode) tells me that the database is corrupted, I recently had a malware but I have dealt with it, can a factory reset fix the problem (I can no longer open Firefox)? Thank you in advance.
0
blux Posted messages 2021 Registration date   Status Moderator Last intervention   3 452
 
Fix it...

--
A+ blux
 "Idiots, they dare to do anything. It's even how you recognize them" 
-1