ORA-19904: test recovery not allowed for datafile string

Cause : The specified datafile has been restored from a backup that was taken before the last resetlogs. Recovering this datafile will require a file header update that is incompatible with test recovery.

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

Perform actual recovery.

update : 29-04-2017
ORA-19904

ORA-19904 - test recovery not allowed for datafile string
ORA-19904 - test recovery not allowed for datafile string

  • ora-25316 : Late in the current transaction to begin an Enqueue/Dequeue operation
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • ora-01613 : instance string (thread string) only has string logs - at least 2 logs required to enable.
  • ora-23396 : database link "string" does not exist or has not been scheduled
  • ora-12432 : LBAC error: string
  • ora-13014 : a topology identifier outside the range of 1 to 8 was specified
  • ora-01634 : rollback segment number 'string' is about to go offline
  • ora-29964 : missing ADD or DROP keyword
  • ora-30385 : specified attribute relationship ('string' determines 'string') exists
  • ora-23607 : invalid column "string"
  • ora-13124 : unable to determine column id for column string
  • ora-09746 : smscre: shared memory attach address incorrect.
  • ora-13336 : failure in converting standard diminfo/geometry to LRS dim/geom
  • ora-13466 : format not appropriate for specified compression method
  • ora-38429 : invalid datatype for a stored attribute: string
  • ora-10269 : Don't do coalesces of free space in SMON
  • ora-30063 : Internal Event to Test NTP
  • ora-14612 : Duplicate lob segment name string for lob column string in template
  • ora-01171 : datafile string going offline due to error advancing checkpoint
  • ora-01270 : %s operation is not allowed if STANDBY_PRESERVES_NAMES is true
  • ora-06537 : OUT bind variable bound to an IN position
  • ora-29279 : SMTP permanent error: string
  • ora-16661 : the standby database needs to be reinstated
  • ora-07476 : slsget: cannot get mapped memory statistics.
  • ora-32035 : unreferenced query name defined in WITH clause
  • ora-01917 : user or role 'string' does not exist
  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-38622 : Decision Tree not enough memory, requires at least stringKB
  • ora-10262 : Don't check for memory leaks
  • ora-19513 : failed to identify sequential file
  • 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.