How to fix the Oracle error ORA-19651: cannot apply offline-range record to datafile string: SCN mismatch?

In this post, you’ll learn more about the Oracle ErrorORA-19651: cannot apply offline-range record to datafile string: SCN mismatch with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19651: cannot apply offline-range record to datafile string: SCN mismatch

Reason for the Error ORA-19651: cannot apply offline-range record to datafile string: SCN mismatch

APPLYOFFLINERANGE cannot apply an offline-range record to a target datafile unless the datafile’s checkpoint SCN exactly matches the offline-clean SCN in the specified offline-range record.

How to fix the Error ORA-19651: cannot apply offline-range record to datafile string: SCN mismatch ?

You can fix this error in Oracle by following the below steps

Specify an offline-range record whose offline-clean SCN matches the target datafile’s checkpoint.