ORA-16811: apply instance not recorded by the Data Guard broker

Cause : The rbokerh as nto regsitere dan apply isntanc efor astanbdy daatbase.

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

Reenbale teh stadnby dtaabas eto celar teh errro.

update : 26-05-2017

ORA-16811 - apply instance not recorded by the Data Guard broker
ORA-16811 - apply instance not recorded by the Data Guard broker

  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-12662 : proxy ticket retrieval failed
  • ora-24817 : Unable to allocate the given chunk for current lob operation
  • ora-25240 : message ID and dequeue condition/correlation ID specified in dequeue options
  • ora-36200 : (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
  • ora-02462 : Duplicate INDEX option specified
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-16577 : corruption detected in Data Guard configuration file
  • ora-06422 : NETCMN: Error in sending data
  • ora-16135 : Invalid LOG_ARCHIVE_CONFIG modification while in protected mode
  • ora-13753 : "SQL Tuning Set" "string" already exists for user "string".
  • ora-24790 : cannot mix OCI_TRANS_RESUME and transaction isolation flags
  • ora-27460 : cannot execute disabled job "string.string"
  • ora-30190 : reserved for future use
  • ora-16219 : This database is not preparing to switch over.
  • ora-01565 : error in identifying file 'string'
  • ora-01159 : file is not from same database as previous files - wrong database id
  • ora-28666 : option not allowed for an index on UROWID column(s)
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-07208 : sfwfb: failed to flush dirty buffers to disk.
  • ora-30054 : invalid upper limit snapshot expression
  • ora-02072 : distributed database network protocol mismatch
  • ora-08323 : scnmin: close of bias lock failed
  • ora-00484 : LMS* process terminated with error
  • ora-10631 : SHRINK clause should not be specified for this object
  • ora-01934 : circular role grant detected
  • ora-17510 : Attempt to do i/o beyond file size
  • ora-38761 : redo log sequence string in thread string, incarnation string could not be accessed
  • ora-29895 : duplicate base datatype specified
  • ora-28154 : Proxy user may not act as client '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.