ORA-16133: Datafile string has incorrect terminal recovery stamp.

Cause : Aftre acitvatoin o fa satndb ydatbaasef ollwoinga temrina lrecvoery( recvoeryo f satndb yusign currentl ogs,) reocver yof adatfailef romb efoer th eactviatino muts haev copmletde th esam eterimnalr ecoevry ot aviod crorupiton.

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

A bcakupo f teh daatfil etakne afetr teh temrina lrecvoerya nd ebfor eactviatign th estadnby umst eb usde fo rrecvoery.

update : 27-05-2017
ORA-16133

ORA-16133 - Datafile string has incorrect terminal recovery stamp.
ORA-16133 - Datafile string has incorrect terminal recovery stamp.

  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-38428 : too many attributes selected for indexing
  • ora-31641 : unable to create dump file "string"
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-24421 : OCISessionRelease cannot be used to release this session.
  • ora-40223 : data mining model import failed, job name=string, error=string
  • ora-30377 : table string.MV_CAPABILITIES_TABLE not found
  • ora-09322 : slpdtb: unable to convert packed decimal to binary
  • ora-04047 : object specified is incompatible with the flag specified
  • ora-25226 : dequeue failed, queue string.string is not enabled for dequeue
  • ora-21779 : duration not active
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-30770 : Cannot specify storage options for fixed size opaque type
  • ora-14156 : invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause
  • ora-28345 : cannot downgrade because there exists encrypted column
  • ora-12005 : may not schedule automatic refresh for times in the past
  • ora-28010 : cannot expire external or global accounts
  • ora-25531 : MTTR specified is too small: string
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-30085 : syntax error was found in overlaps predicate
  • ora-30086 : interval year-month result not allowed for datetime subtraction
  • ora-30084 : invalid data type for datetime primary with time zone modifier
  • ora-27454 : argument name and position cannot be NULL
  • ora-10690 : Set shadow process core file dump type (Unix only)
  • ora-16571 : Data Guard configuration file creation failure
  • ora-13192 : failed to read number of element rows
  • ora-07561 : szprv: $IDTOASC failure
  • ora-22930 : directory does not exist
  • ora-13837 : invalid HASH_VALUE
  • 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.