Oracle Solution for Error ora-01171

Solution for Oracle Error ORA-01171

ORA-01171: datafile string going offline due to error advancing checkpoint

What triggered the Error:

The checkpoint in the file header could not be advanced. See accompanying errors for the reason. The datafile will be taken offline the same as for a write error of a data block.

What should we do to fix it:

See accompanying errors for details. Restore access to the file, do media recovery, and bring it back online.