ORA-25531: MTTR specified is too small: string

Cause : The current FAST_START_MTTR_TARGET setting or a candidate MTTR setting is too small for MTTR advisory.

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

Set a larger FAST_START_MTTR_TARGET or candidate MTTR.

update : 26-06-2017

ORA-25531 - MTTR specified is too small: string
ORA-25531 - MTTR specified is too small: string

  • ora-00097 : use of Oracle SQL feature not in SQL92 string Level
  • ora-25177 : UNRECOVERABLE option not permitted
  • ora-14453 : attempt to use a LOB of a temporary table, whose data has alreadybeen purged
  • ora-29864 : analyzing domain indexes marked LOADING/FAILED not supported
  • ora-09948 : Process information label retrieval failed.
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-02084 : database name is missing a component
  • ora-08443 : syntax error in BLANK WHEN ZERO clause in mask options
  • ora-27454 : argument name and position cannot be NULL
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • ora-13481 : the destination type is not supported
  • ora-13377 : invalid combination of elements with orientation
  • ora-26718 : transaction limit reached
  • ora-01650 : unable to extend rollback segment string by string in tablespace string
  • ora-12701 : CREATE DATABASE character set is not known
  • ora-16560 : unable to convert document, syntax error at "string"
  • ora-01483 : invalid length for DATE or NUMBER bind variable
  • ora-00307 : requested INSTANCE_NUMBER out of range, maximum is string
  • ora-26028 : index string.string initially in unusable state
  • ora-22064 : invalid NLS parameter string [string]
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-13267 : error reading data from layer table string
  • ora-01135 : file string accessed for DML/query is offline
  • ora-28137 : Invalid FGA audit Handler
  • ora-16607 : one or more databases have failed
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-01478 : array bind may not include any LONG columns
  • ora-32512 : type 'string' is unknown
  • ora-26098 : direct path context is not prepared
  • ora-02431 : cannot disable constraint (string) - no such constraint
  • 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.