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 : 24-06-2017

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

  • ora-30107 : parameter name abbreviation 'string' is not unique
  • ora-13249 : %s
  • ora-09884 : Two Task interface: SID doens't match current PU
  • ora-25128 : No insert/update/delete on table with constraint (string.string) disabled and validated
  • ora-25285 : Invalid value string for array_mode
  • ora-24380 : invalid mode specification
  • ora-00487 : CTWR process terminated with error
  • ora-06310 : IPA: Environment variable(s) not set
  • ora-13345 : a compound polygon geometry has fewer than five coordinates
  • ora-00040 : active time limit exceeded - call aborted
  • ora-27071 : unable to seek to desired position in file
  • ora-38446 : Error with embedded ADT "string" in the attribute set.
  • ora-22615 : attribute is not a collection
  • ora-32740 : The requested operation cannot be proceeded
  • ora-07753 : slemcf: fseek before write failure
  • ora-23313 : object group "string"."string" is not mastered at string
  • ora-16036 : invalid MANAGED recovery CANCEL option
  • ora-31443 : deadlock detected while acquiring lock on string
  • ora-30463 : 'string' is not a detail table of any summary
  • ora-01656 : max # extents (string) reached in cluster string.string
  • ora-06902 : CMX: cannot attach to cmx subsystem
  • ora-01616 : instance string (thread string) is open - cannot disable
  • ora-07229 : slcpuc: error in getting number of CPUs.
  • ora-16208 : Logical standby dictionary build failed to start.
  • ora-06914 : CMX: unexepected event during start of oracle
  • ora-30434 : refresh method must be one of FC?AN, not 'string'
  • ora-16790 : the value of the configurable property is invalid
  • ora-01500 : failure in getting date/time
  • ora-16805 : change of LogXptMode property violates overall protection mode
  • ora-22835 : Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
  • 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.