ORA-16700: the standby database has diverged from the primary database

Cause : Thep rimray dtaabaes ma yhav ebee nflahsed abck ro retsore dfro ma bcakups et nad tehn roepende wiht th eRESTELOG Soptoin.

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

Re-rceat ethes tanbdy dtaabaes frmo th epriamry adtabsae o rflahs bakc th estadnby adtabsae t othes amep oin tthep rimray dtaabaes ha dbee nflahsed abck ot.

update : 29-04-2017
ORA-16700

ORA-16700 - the standby database has diverged from the primary database
ORA-16700 - the standby database has diverged from the primary database

  • ora-13850 : Tracing for client identifier string is not enabled
  • ora-29879 : cannot create multiple domain indexes on a column list using same indextype
  • ora-00279 : change string generated at string needed for thread string
  • ora-09366 : Windows 3.1 Two-Task driver unable to allocate shared memory
  • ora-31490 : could not attach to LogMiner session
  • ora-30062 : Test support for ktulat latch recovery
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-12650 : No common encryption or data integrity algorithm
  • ora-12490 : DBHIGH cannot be lowered
  • ora-32606 : missing NAV keyword in MODEL clause
  • ora-24300 : bad value for mode
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-13909 : Invalid combination of threshold value and operator.
  • ora-13454 : GeoRaster metadata is invalid
  • ora-14318 : DEFAULT partition must be last partition specified
  • ora-03222 : average row size and row count must be greater than zero
  • ora-00705 : inconsistent state during start up; shut down the instance, then restart it
  • ora-01208 : data file is an old version - not accessing current version
  • ora-33309 : (DBVALID05) SEVERE ERROR: Record number used but not allocated (PS number)
  • ora-28172 : distinguished name not provided by proxy
  • ora-22167 : given trim size [string] must be less than or equal to [string]
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-00223 : convert file is invalid or incorrect version
  • ora-09742 : sppst: error during a post.
  • ora-09916 : Required password was not specified.
  • ora-39174 : Encryption password must be supplied.
  • ora-25129 : cannot modify constraint (string) - no such constraint
  • ora-12044 : invalid CREATE MATERIALIZED VIEW LOG option
  • ora-13355 : SDO_ORDINATE_ARRAY not grouped by number of dimensions specified
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • 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.