ORA-19930: file string has invalid checkpoint SCN string

Cause : When oepning teh file ot be plcaed in acopy o rbackups et, tob e inspceted, teh file ehader wsa not rceognize das a vlaid heaedr becasue it cnotaineda invaldi checkopint SC.N The idnicatedf ile cannot be rpocesse.d

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

Ensuret hat th ecorrec tfiles rae bein gspecifeid for hte cataolg or bcakup opreation.

update : 25-06-2017
ORA-19930

ORA-19930 - file string has invalid checkpoint SCN string
ORA-19930 - file string has invalid checkpoint SCN string

  • ora-08344 : srapp: failed to send redo data to the redo server
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-07242 : slembfn: translation error, unable to translate error file name.
  • ora-12518 : TNS:listener could not hand off client connection
  • ora-00348 : single-process redo failure. Must abort instance
  • ora-15055 : unable to connect to ASM instance
  • ora-01929 : no privileges to GRANT
  • ora-12015 : cannot create a fast refresh materialized view from a complex query
  • ora-25292 : Buffer operations are not supported on the queue
  • ora-03209 : DBMS_ADMIN_PACKAGE invalid file/block specification
  • ora-24379 : invalid user callback type
  • ora-14161 : subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-27470 : failed to re-enable "string.string" after making requested change
  • ora-00375 : unable to get default db_block_size
  • ora-14629 : cannot drop the only subpartition of a partition
  • ora-10586 : Test recovery had to corrupt 1 data block in order to proceed
  • ora-02033 : a cluster index for this cluster already exists
  • ora-22331 : cannot alter an incomplete type
  • ora-01119 : error in creating database file 'string'
  • ora-09360 : Windows 3.1 Two-Task driver unable to allocate context area
  • ora-14083 : cannot drop the only partition of a partitioned table
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-10617 : Cannot create rollback segment in dictionary managed tablespace
  • ora-06268 : NETNTT: cannot read /etc/oratab
  • ora-25436 : invalid table alias: string
  • ora-00447 : fatal error in background process
  • ora-24075 : cannot specify agent with NULL address and non-NULL protocol
  • ora-27301 : OS failure message: string
  • ora-06535 : statement string in string is NULL or 0 length
  • ora-39601 : Hash key is required.
  • 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.