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 : 30-04-2017

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

  • ora-39503 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-29315 : tablespace 'string' has been recreated
  • ora-16607 : one or more databases have failed
  • ora-13864 : Statistics aggregation for service (module/action) string is already enabled
  • ora-06813 : TLI Driver: the configured ethernet address is incorrect
  • ora-39052 : cannot specify SKIP_CURRENT on initial start of a job.
  • ora-27486 : insufficient privileges
  • ora-02425 : create table failed
  • ora-12466 : default level is greater than the user's maximum
  • ora-37039 : (XSMLTDCL05) You cannot maintain triggers in analytic workspace string because it is attached in MULTI mode.
  • ora-01096 : program version (string) incompatible with instance (string)
  • ora-02441 : Cannot drop nonexistent primary key
  • ora-24141 : rule set string.string does not exist
  • ora-16007 : invalid backup control file checkpoint
  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-27504 : IPC error creating OSD context
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • ora-12431 : invalid audit action
  • ora-19622 : archivelog thread string sequence string not restored due to string
  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-01635 : rollback segment #string specified not available
  • ora-02246 : missing EVENTS text
  • ora-25302 : Operation not possible for non-buffered queue string
  • ora-08466 : raw buffer length string is too short for string
  • ora-04089 : cannot create triggers on objects owned by SYS
  • ora-12410 : internal policy error for policy: string Error: string
  • ora-31469 : cannot enable Change Data Capture for change set string
  • ora-16951 : Too many bind variables supplied for this SQL statement.
  • ora-28338 : cannot encrypt indexed column(s) with salt
  • ora-16751 : resource guard encountered errors in switchover to primary database
  • 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.