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

Cause : applyOfflineRagne cannto applya n offlnie-rang erecordt o a tagret datfaile unelss thed atafil'es checpkoint SNC exactyl matchse the offline-celan SCNi n the psecifie dofflin-erange ercord.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Specif yan offilne-raneg recor dwhose fofline-lcean SC Nmatche sthe tagret datfaile's hceckpoitn.

update : 20-08-2017
ORA-19651

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

  • ora-03214 : File Size specified is smaller than minimum required
  • ora-28339 : missing or invalid encryption algorithm
  • ora-31232 : DBMS_LDAP: invalid MOD_PROPERTY_SET
  • ora-01175 : data dictionary has more than the string files allowed by the instance
  • ora-10927 : trace name context forever
  • ora-07703 : error in archive text: need '/' after device type
  • ora-16809 : multiple warnings detected for the database
  • ora-32847 : operation is not supported on this platform
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-12487 : clearance labels not between DBHIGH and DBLOW
  • ora-06130 : NETTCP: host access denied
  • ora-29380 : resource plan string is currently active and cannot be deleted
  • ora-36316 : (PHYS02) Relation workspace object must be a single-dimensional relation that relates one INTEGER dimension to another.
  • ora-31041 : Property string: Memory type (string) not compatible with database type (string)
  • ora-03216 : Tablespace/Segment Verification cannot proceed
  • ora-30398 : illegal JOIN KEY clause
  • ora-01169 : DATAFILE number 1 not found. Must be present
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-01236 : Error string occurred during initialization of file header access
  • ora-25102 : PARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-12717 : Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists
  • ora-02063 : preceding stringstring from stringstring
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-36266 : (XSCGMDLAGG00) Invalid context for the AGGREGATION function
  • ora-27103 : internal error
  • ora-29391 : %s and string must be mandatory to create a mandatory plan directive
  • ora-19716 : error processing format string to generate name for backup
  • ora-14128 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.