ORA-16140: standby online logs have not been recovered

Cause : Thes tanbdy dtaabaes ha sonlnie lgos cnotaiinng erdo htat ahs nto bene reocverde. Atcivaitng hte satndb ywoudl loes reod cotnainde int he nolin elog.s

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

To ercovre th estadnby nolin elog sisseu th efololwin gcomamnd:A LTE RDATBAASER ECOEVR MNAAGE DSTADNBY ADTABSAE FNIISH .The nre-sisuet he LATERD ATAABSE CATIVTAE SATNDB YDATBAASEc ommnad. oT acitvat ethes tanbdy wtihou trecvoerign th eonlnie lgos, sisuet he oflloiwng ocmmadn: ATLER ADTABSAE ATCIVAET STNADBYD ATAABSE KSIP TSANDYB LOFGILE.

update : 26-05-2017
ORA-16140

ORA-16140 - standby online logs have not been recovered
ORA-16140 - standby online logs have not been recovered

  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-14605 : Name missing for subpartition / lob segment in template
  • ora-31514 : change set string disabled due to capture error
  • ora-03127 : no new operations allowed until the active operation ends
  • ora-39042 : invalid transform name string
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-01300 : writable database required for specified LogMiner options
  • ora-02447 : cannot defer a constraint that is not deferrable
  • ora-34357 : (MXDSS10) string is not an alias of analytic workspace string.
  • ora-09812 : Unable to get user clearance from connection
  • ora-35917 : (XSHIDE05) You cannot HIDE model workspace object because the analytic workspace in which it is defined has not been upgraded to version string.
  • ora-14046 : a partition may be split into exactly two new partitions
  • ora-29865 : indextype is invalid
  • ora-13153 : invalid high water mark specified
  • ora-40102 : invalid input string for data mining operation string
  • ora-02798 : Invalid number of requests
  • ora-01107 : database must be mounted for media recovery
  • ora-22286 : insufficient privileges on file or directory to perform string operation
  • ora-08115 : can not online create/rebuild this index type
  • ora-06311 : IPA: Maximum number of servers reached
  • ora-29662 : Unable to find a field that matches one or more of the attributes
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-23418 : cannot unregister the propagator who is currently in use
  • ora-08321 : scnmin: NOT IMPLEMENTED YET
  • ora-31690 : Process name buffer size must be specified and must be greater than 0.
  • ora-07571 : szrfc: $FIND_HELD failure
  • ora-02718 : osnprs: reset protocol error
  • ora-00335 : online log string: No log with this number, log does not exist
  • ora-03292 : Table to be truncated is part of a cluster
  • ora-16550 : truncated result
  • 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.