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 : 22-09-2017
ORA-16012

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

  • ora-29933 : object being disassociated has some user defined statistics stored
  • ora-32690 : Hash Table Infrastructure ran out of memory
  • ora-30133 : reserved for future use
  • ora-07247 : skgfrfms, skgfrnms: read error, unable to read block from database file
  • ora-25352 : no current transaction
  • ora-01232 : cannot start online backup - file string is being made read-only
  • ora-30485 : missing ORDER BY expression in the window specification
  • ora-32619 : incorrect use of MODEL ITERATION_NUMBER
  • ora-25109 : standby lock name space has illegal character 'string'
  • ora-04089 : cannot create triggers on objects owned by SYS
  • ora-22316 : input type is not a collection type
  • ora-24238 : object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-33213 : (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
  • ora-24950 : unregister failed, registeration not found
  • ora-38476 : abstract type used for an Attribute set may not be modified.
  • ora-31019 : Recursive deletion snapshot too old for string/string
  • ora-25153 : Temporary Tablespace is Empty
  • ora-01216 : thread string is expected to be disabled after CREATE CONTROLFILE
  • ora-16529 : bad sender id
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-06977 : X.25 Driver: X.25 Level 2 failure
  • ora-30204 : buffer is not large enougth
  • ora-12664 : Services required by server not available on the client
  • ora-10704 : Print out information about what enqueues are being obtained
  • ora-12231 : TNS:No connection possible to destination
  • ora-22814 : attribute or element value is larger than specified in type
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-23291 : Only base table columns may be renamed
  • ora-31693 : Table data object string failed to load/unload and is being skipped due to error: string
  • ora-12673 : Dedicated server: context not saved
  • 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.