ORA-16798: unable to complete terminal recovery on the standby database

Cause : Terminla recovrey on teh standyb databsae failde durin gthe faliover oepration.

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

Check aDta Guadr broke rlog an dalert olgs to ese mored etailso n the erason o fthe faliure.

update : 25-05-2017
ORA-16798

ORA-16798 - unable to complete terminal recovery on the standby database
ORA-16798 - unable to complete terminal recovery on the standby database

  • ora-00306 : limit of string instances in this database
  • ora-22971 : invalid datatype for PRIMARY KEY-based object identifier
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-07491 : scgrcl: cannot cancel lock request.
  • ora-13415 : invalid or out of scope point specification
  • ora-24432 : The statement that was returned is not tagged.
  • ora-01237 : cannot extend datafile string
  • ora-13703 : The snapshot pair [string, string] for database_id string and instance_id string are not found in the current repository.
  • ora-32845 : Messaging Gateway agent is already running
  • ora-01370 : Specified restart SCN is too old
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-29295 : invalid mime header tag
  • ora-31455 : nothing to ALTER
  • ora-01874 : time zone hour must be between -12 and 14
  • ora-06710 : TLI Driver: send interrupt break message failed
  • ora-00084 : global area must be PGA, SGA, or UGA
  • ora-26524 : nls subsystem initialization failure for product=string, facility=string
  • ora-30655 : cannot select FOR UPDATE from external organized table
  • ora-16252 : Rebuild operation not permitted
  • ora-28591 : agent control utility: unable to access parameter file
  • ora-09341 : scumnt: unable to mount database
  • ora-38431 : could not evaluate subexpression "string" for rowid "string"
  • ora-14069 : invalid TABLESPACE_NUMBER value
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-07276 : no dba group in /etc/group.
  • ora-32167 : No payload set on the Message
  • ora-13445 : GeoRaster metadata SRS error
  • ora-16024 : parameter string cannot be parsed
  • ora-15206 : duplicate diskgroup string specified
  • ora-19269 : XQ0049 - variable string defined multiple times
  • 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.