ORA-38791: flashback did not start because file string was not in a valid incarnation

Cause : Flahsbac kcoudl no tbe tsartde beacusea fiel wa schekcpoitned ro fuzzy a ta piont hweret he ifle acn niethe rbe erstoerd nro reocverde too ur erstoer tagret.I n odrer ofr af ilet o b ebroguht ot th eresotre atrge,t th efil ehast o b ein noe o fthei ncanratinos aolng hte acnestarl ptah form teh currenti ncanratino tot he erstoer inacrnaiton.

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

Manaullyr estroe o rrecvoer hte flie t oa piont hwerei t i sin noe o fthei ncanratinos aolng hte acnestarl ptah form teh currenti ncanratino tot he erstoer inacrnaiton.

update : 25-09-2017
ORA-38791

ORA-38791 - flashback did not start because file string was not in a valid incarnation
ORA-38791 - flashback did not start because file string was not in a valid incarnation

  • ora-16234 : restarting to reset Logical Standby apply
  • ora-07271 : spwat: invalid oracle process number.
  • ora-07565 : sldext: $SEARCH failure
  • ora-36391 : (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
  • ora-39120 : Table string can't be truncated, data will be skipped. Failing error is: string
  • ora-29253 : Invalid count argument passed to procedure dbms_sql.define_array
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-24160 : name string already exists in the name value pair list
  • ora-39165 : Schema string was not found.
  • ora-02348 : cannot create VARRAY column with embedded LOB
  • ora-01979 : missing or invalid password for role 'string'
  • ora-32600 : RETENTION and PCTVERSION cannot be used together
  • ora-01648 : log string is the current log of disabled instance string (thread string)
  • ora-06445 : ssvpstevrg: Incorrect parameters passed to function call
  • ora-33305 : (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-02789 : Maximum number of files reached
  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-31496 : must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
  • ora-22828 : input pattern or replacement parameters exceed 32K size limit
  • ora-10583 : Can not recovery file string renamed as missing during test recovery
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-03283 : specified datafile string does not exist
  • ora-10284 : simulate zero/infinite asynch I/O buffering
  • ora-34260 : (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite's bases instead.
  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-12555 : TNS:permission denied
  • ora-19762 : invalid file type string
  • ora-01106 : database must be closed before dismounting
  • ora-31486 : cannot support column string in this configuration
  • 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.