ORA-29307: datafile string error, string

Cause : The datfaile is ont readyf or tablsepace ponit-in-tiem recoveyr.

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

Check teh correc ttablespcae pointi-n-time ercovery rpocedure.

update : 20-08-2017

ORA-29307 - datafile string error, string
ORA-29307 - datafile string error, string

  • ora-15036 : disk 'string' is truncated
  • ora-09353 : Windows 32-bit Two-Task driver unable to open event semaphore
  • ora-36991 : (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
  • ora-28577 : argument string of external procedure string has unsupported datatype string
  • ora-27210 : syntax error in device PARMS
  • ora-09977 : skxfqhini: Error Connecting
  • ora-16735 : error executing dbms_logstdby.unskip_error procedure
  • ora-16041 : Remote File Server fatal error
  • ora-29345 : cannot plug a tablespace into a database using an incompatible character set
  • ora-40207 : duplicate or multiple function settings
  • ora-16646 : Fast-Start Failover is disabled
  • ora-40287 : invalid data for model - cosine distance out of bounds
  • ora-30459 : 'string.string' cannot be refreshed because the refresh method is NONE
  • ora-19653 : cannot switch to older file incarnation
  • ora-16128 : User initiated stop apply successfully completed
  • ora-12832 : Could not allocate slaves on all specified instances
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-01573 : shutting down instance, no further change allowed
  • ora-33223 : (CMOVE03) You cannot move a session-only dimension value.
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-30457 : 'string.string' cannot be refreshed because of unmnanaged NOT NULL columns in container
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-19620 : %s is not of string type
  • ora-12093 : invalid interim table "string"."string"
  • ora-15133 : instance recovery required for diskgroup string
  • ora-19024 : Cursor expression must be named
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-06756 : TLI Driver: cannot open oratab
  • ora-28354 : wallet already open
  • ora-32505 : too many watchpoints
  • 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.