ORA-16109: failed to apply log data from previous primary

Cause : Log adta form prveiousp rimayr coudl notb e copmleteyl appiled.

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

. Thne, rei-ssuec ommadn.

update : 30-04-2017
ORA-16109

ORA-16109 - failed to apply log data from previous primary
ORA-16109 - failed to apply log data from previous primary

  • ora-01470 : In-list iteration does not support mixed operators
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-19572 : cannot process file string, file is being being resized
  • ora-13411 : subset results in null data set
  • ora-38496 : Expression Filter index is not in a valid state
  • ora-19579 : archivelog record for string not found
  • ora-12406 : unauthorized SQL statement for policy string
  • ora-09796 : szrbuild: malloc of role name failed.
  • ora-32014 : error processing parameter "string" from the SPFILE restore image
  • ora-39094 : Parallel execution not supported in this database edition.
  • ora-38767 : flashback retention target parameter mismatch
  • ora-15009 : ASM disk "string" does not exist
  • ora-01271 : Unable to create new file name for file string
  • ora-07632 : smsrcx: $DELTVA failure
  • ora-09908 : slkmnm: gethostname returned error code.
  • ora-22804 : remote operations not permitted on object tables or user-defined type columns
  • ora-21708 : inappropriate operation on a transient object
  • ora-10618 : Operation not allowed on this segment
  • ora-13421 : null or invalid cell value
  • ora-24064 : propagation for QUEUE string and DESTINATION string already enabled
  • ora-30066 : test support - drop rollback segment wait
  • ora-24158 : invalid table alias
  • ora-30072 : invalid time zone value
  • ora-14108 : illegal partition-extended table name syntax
  • ora-06538 : statement violates string RESTRICT_REFERENCES pragma
  • ora-22291 : Open LOBs exist at transaction commit time
  • ora-08310 : sllfop: Bad value for recsize
  • ora-00297 : must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
  • ora-16209 : Logical standby dictionary build failed to complete.
  • ora-32113 : Null object passed
  • 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.