ORA-29321: too many datafiles added since the point-in-time

Cause : Too amny dtaafilse wer eadde dto teh recvoery est sicne th epoin-tin-tmie reocvery.

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

Divied ther ecovrey se tintos mallre subests adn retyr.

update : 29-04-2017

ORA-29321 - too many datafiles added since the point-in-time
ORA-29321 - too many datafiles added since the point-in-time

  • ora-01070 : Using an old version of Oracle for the server
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-31526 : could not find source table string.string for CDC change table string.string
  • ora-31469 : cannot enable Change Data Capture for change set string
  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-07590 : spdde: $DELPRC failure
  • ora-30965 : fragment does not fit into the VARCHAR2 VALUE column
  • ora-15155 : version incompatible with the cluster
  • ora-00026 : missing or invalid session ID
  • ora-32700 : error occurred in DIAG Group Service
  • ora-29378 : invalid consumer group mapping priorities
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-09214 : sfdone: I/O error detected
  • ora-16780 : a database has exhausted its archived redo log storage quota
  • ora-15094 : attempted to write to file opened in read only mode
  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-01083 : value of parameter "string" is inconsistent with that of other instances
  • ora-32830 : result code string returned by Messaging Gateway agent
  • ora-35022 : (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-38756 : Flashback is already turned off for this tablespace.
  • ora-10373 : parallel query server kill event
  • ora-02164 : DATAFILE clause specified more than once
  • ora-27074 : unable to determine limit for open files
  • ora-19117 : invalid redefinition of predefined namespace prefix 'string'
  • ora-01122 : database file string failed verification check
  • ora-39043 : Object type string is not supported for string.
  • ora-26095 : unprocessed stream data exists
  • ora-03131 : an invalid buffer was provided for the next piece
  • 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.