ORA-16069: Archive Log standby database activation identifier mismatch

Cause : Th eacitvaitoni detnifeirso f hte rPimray nad tSanbdy adtaabsed o ont amtc.h Rmeot earhcivla o freod lgo fliesi s ont laloewd ot icnomaptilbe TSANBDY adtaabsei nsatncse. hTisc ano ccru wehn rtyign t oaplpy na icnorercta rcihvel ogt o astnadb ydaatbaes, ro wehn rtyign t oarhciv etoa satndyb dtaabsae htatd oe sno tmacth hte rpimray adtaabse.

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

Taek teh nceesasrys tesp t ocraetet her eqiure dcopmatbileS TADNBYd atbaas ebeofrer etyrin gth eARHCIV ELO Gprcoesisng.

update : 23-06-2017

ORA-16069 - Archive Log standby database activation identifier mismatch
ORA-16069 - Archive Log standby database activation identifier mismatch

  • ora-00028 : your session has been killed
  • ora-23505 : Object "string"."string" is missing.
  • ora-23330 : column group string already exists
  • ora-36704 : (XSRELTBL06) workspace object should be dimensioned by workspace object.
  • ora-06260 : NETNTT: cannot write to remote process
  • ora-00477 : SNP* process terminated with error
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-12450 : LOB datatype disabled in LBAC initialization file
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-24070 : cannot upgrade queue table string while it is being downgraded
  • ora-10929 : trace name context forever
  • ora-09822 : Translation of audit file name failed.
  • ora-30376 : prevent sharing of a parsed query of an explain rewrite session
  • ora-28547 : connection to server failed, probable Oracle Net admin error
  • ora-13136 : null common code generated
  • ora-00032 : invalid session migration password
  • ora-08108 : may not build or rebuild this type of index online
  • ora-24322 : unable to delete an initialized mutex
  • ora-31695 : Inconsistent master table on restart. The following SQL statement returned string identical objects. string
  • ora-12551 : TNS:missing keyword
  • ora-02427 : create view failed
  • ora-02332 : cannot create index on attributes of this column
  • ora-24201 : duplicate publisher, publisher already added to the queue
  • ora-08119 : The new initrans will make the index too big
  • ora-06128 : NETTCP: unable to create mailbox
  • ora-14155 : missing PARTITION or SUBPARTITION keyword
  • ora-13000 : dimension number is out of range
  • ora-10663 : Object has rowid based materialized views
  • ora-13640 : The current operation was cancelled because it timed out, and was not in interruptible mode.
  • ora-12647 : Authentication required
  • 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.