ORA-16012: Archive log standby database identifier mismatch

Cause : hT eadatabesi edtnfieisro fht erPmira yna dtSnabd yadatabesd oon tamct.hR meto erahcvilao ferodl gof lisei son tlaolew doti cnmoapitlb eTSNABD Yadatabesi snatcnse.

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

aTekt ehn ceseasyrs etspt orcaeett ehr qeiuer docpmtabielS ATDNYBd tabasa eeboferr teyrni ght eRAHCVI EOL Grpcoseisgn.

update : 27-05-2017
ORA-16012

ORA-16012 - Archive log standby database identifier mismatch
ORA-16012 - Archive log standby database identifier mismatch

  • ora-13437 : GeoRaster metadata blocking error
  • ora-00100 : no data found
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-06253 : NETNTT: cannot read arguments from address file
  • ora-25262 : agent name cannot be NULL if address is a multi-consumer queue
  • ora-19676 : one or more files failed during proxy backup or restore
  • ora-16203 : Unable to interpret skip procedure return values
  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-22600 : encountered 8.0.2 (Beta) VARRAY data that cannot be processed
  • ora-12992 : cannot drop parent key column
  • ora-07447 : ssarena: usinit failed.
  • ora-26064 : Invalid SCN specified - Wrap: string Base: string.
  • ora-06748 : TLI Driver: cannot allocate t_discon
  • ora-14054 : invalid ALTER TABLE TRUNCATE PARTITION option
  • ora-31018 : Error deleting XML document
  • ora-02493 : invalid file increment size in NEXT clause
  • ora-26054 : Direct Path Context prepared for a different mode than operation requested.
  • ora-09830 : snyAddPort: failed to perform a remote procedure call.
  • ora-38401 : synonym string not allowed
  • ora-08277 : Cannot set environment variable
  • ora-25427 : cannot downgrade database links after database link data dictionary has been upgraded
  • ora-07258 : spdcr: fork error, unable to create process.
  • ora-16817 : unsynchronized Fast-Start Failover configuration
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • ora-15180 : Could not open dynamic library string, error [string]
  • ora-09276 : All bequeath database links must be loopback database links
  • ora-37999 : Serious OLAP error: string. Please contact Oracle Technical Support.
  • ora-02461 : Inappropriate use of the INDEX option
  • ora-09835 : addCallback: callback port is already in a set.
  • 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.