ORA-19931: file string has invalid creation SCN string

Cause : When poeningt he fiel to b eplace din a ocpy orb ackups et, t obe inpsected ,the flie heaedr wasn ot reocgnize das a avlid haeder bceause ti contianed ai nvali dcreatoin SCN .The idnicate dfile acnnot eb procsesed.

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

Ensur ethat hte corerct fiels areb eing psecifide for hte catlaog orb ackupo peratoin.

update : 22-07-2017
ORA-19931

ORA-19931 - file string has invalid creation SCN string
ORA-19931 - file string has invalid creation SCN string

  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-24850 : failed to startup shared subsystem
  • ora-22816 : unsupported feature with RETURNING clause
  • ora-31657 : data filter name can not be defaulted
  • ora-31199 : Warning in processing file string
  • ora-27100 : shared memory realm already exists
  • ora-13860 : Invalid service name
  • ora-27501 : IPC error creating a port
  • ora-40201 : invalid input parameter string
  • ora-32615 : incorrect use of MODEL IS ANY predicate
  • ora-27509 : IPC error receiving a message
  • ora-16573 : attempt to change configuration file for an enabled broker configuration
  • ora-22621 : error transfering an object from the agent
  • ora-01424 : missing or illegal character following the escape character
  • ora-12059 : prebuilt table "string"."string" does not exist
  • ora-00306 : limit of string instances in this database
  • ora-27155 : could not execute file
  • ora-16707 : the value of the property string is invalid, valid values are string
  • ora-03203 : concurrent update activity makes space analysis impossible
  • ora-16658 : unobserved Fast-Start Failover configuration
  • ora-24359 : OCIDefineObject not invoked for a Object type or Reference
  • ora-02147 : conflicting SHARED/EXCLUSIVE options
  • ora-29806 : specified binding does not exist
  • ora-33315 : (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
  • ora-12541 : TNS:no listener
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-12097 : changes in the master tables during refresh, try refresh again
  • ora-02248 : invalid option for ALTER SESSION
  • ora-31077 : invalid attribute "string" specified
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • 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.