ORA-16775: target standby database in broker operation has potential data loss

Cause : The target standby database in the broker operation did not have all the redo logs from the primary database. The switchover or protection mode upgrade to maximum protection could not be performed.

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

Query the SendQEntries monitorable property on the primary database to see which redo logs are missing. Confirm that the redo transport service on the primary database is functioning correctly by checking its status using the StatusReport monitorable property. Perform log switches on the primary database in order to activate the redo log gap fetching mechanism. Once all redo logs are available on the target standby database, reissue the broker command.

update : 20-08-2017
ORA-16775

ORA-16775 - target standby database in broker operation has potential data loss
ORA-16775 - target standby database in broker operation has potential data loss

  • ora-28020 : IDENTIFIED GLOBALLY already specified
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-14270 : table is not partitioned by Range or Hash or List method
  • ora-00438 : %s Option not installed
  • ora-36676 : (XSDPART14) Missing dimension list for string.
  • ora-06401 : NETCMN: invalid driver designator
  • ora-28267 : Invalid NameSpace Value
  • ora-02843 : Invalid value for kernel flag
  • ora-12423 : invalid position specified
  • ora-16556 : error message is in XML already
  • ora-01496 : specified chain row table form incorrect
  • ora-00392 : log string of thread string is being cleared, operation not allowed
  • ora-01352 : tablespace given for Logminer spill does not exist
  • ora-01370 : Specified restart SCN is too old
  • ora-12494 : cannot insert or delete a level, category, or release category
  • ora-36844 : (XSLMGEN14) Dimension string.string!string is missing a string property value
  • ora-06108 : NETTCP: connect to host failed
  • ora-14028 : missing AT or VALUES keyword
  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-23319 : parameter value string is not appropriate
  • ora-37185 : length of string (string) exceeds maximum (string)
  • ora-01425 : escape character must be character string of length 1
  • ora-10563 : Test recovery had to corrupt data block (file# string, block# string) in order to proceed
  • ora-27025 : skgfqsbi: invalid media manager context area size
  • ora-01088 : cannot shut down ORACLE while active processes exist
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-10616 : Operation not allowed on this tablespace
  • ora-29296 : invalid encoded string
  • ora-29295 : invalid mime header tag
  • ora-26515 : no master log available for 'string.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.