I haven't seen corrupted files in a very long time, but one would
think that finding a backup that predates corruption would be as
easy as finding a backup that has dated information you sometimes
need to look for.
If a bit is flipped between the reading of a block of data and
writing it back, the database integrity mechanism won't detect it
or give you a neat way of recovering.