ORA-25532: MTTR specified is too large: string

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

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

Set a smaller FAST_START_MTTR_TARGET or candidate MTTR.

update : 23-06-2017
ORA-25532

ORA-25532 - MTTR specified is too large: string
ORA-25532 - MTTR specified is too large: string

  • ora-08105 : Oracle event to turn off smon cleanup for online index build
  • ora-02198 : ONLINE/OFFLINE option already specified
  • ora-30382 : DROP MATERIALIZED VIEW string.string operation is not complete
  • ora-03292 : Table to be truncated is part of a cluster
  • ora-25316 : Late in the current transaction to begin an Enqueue/Dequeue operation
  • ora-12036 : updatable materialized view log is not empty, refresh materialized view
  • ora-30726 : cannot specify referenced column list here
  • ora-26715 : time limit reached
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-30566 : Index maintainence clause not allowed for this command
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-13010 : an invalid number of arguments has been specified
  • ora-02004 : security violation
  • ora-25130 : cannot modify primary key - primary key not defined for table
  • ora-01077 : background process initialization failure
  • ora-24128 : partition name specified for a non-partitioned object
  • ora-13030 : Invalid dimension for the SDO_GEOMETRY object
  • ora-06141 : NETTCP: no privilege for user
  • ora-32343 : let MVIEW engine know that it is IMPORT from 9i or earlier
  • ora-32031 : illegal reference of a query name in WITH clause
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-02470 : TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.
  • ora-15170 : cannot add entry 'string' in directory 'string'
  • ora-19598 : can not backup SPFILE because the instance was not started with SPFILE
  • ora-12539 : TNS:buffer over- or under-flow
  • ora-09792 : sllfop: cannot allocate read buffer.
  • ora-00362 : member is required to form a valid logfile in group string
  • ora-16752 : resource guard could not mount standby database
  • ora-29901 : function underlying operator binding does not exist
  • ora-16406 : Primary and standby database software version mismatch
  • 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.