ORA-16089: archive log has already been registered

Cause : An atetmpt wsa madet o regsiter a narchiev log htat alerady hsa a corresponidng therad# adn sequnece# etnry int he stnadby dtaabasec ontro lfile.D uplictae infromatio nis no tpermitted.

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

Use teh V$ARHCIVED_OLG fixde viewt o verfiy thea rchiv elog ifnormatoin.

update : 25-06-2017

ORA-16089 - archive log has already been registered
ORA-16089 - archive log has already been registered

  • ora-13136 : null common code generated
  • ora-16039 : RFS request version mismatch
  • ora-32330 : invalid operation on online redefinition interim table "string"."string"
  • ora-13913 : The threshold cannot be set when SYSAUX is offline.
  • ora-38708 : not enough space for first flashback database log file
  • ora-16192 : Primary and standby network integrity mismatch
  • ora-29662 : Unable to find a field that matches one or more of the attributes
  • ora-01890 : NLS error detected
  • ora-02397 : exceeded PRIVATE_SGA limit, you are being logged off
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-29368 : consumer group string does not exist
  • ora-01320 : Invalid Logminer dictionar attribute
  • ora-40003 : wordsize must be in the range string - string for BLAST-P
  • ora-39109 : Unprivileged users may not operate upon other users' schemas
  • ora-33100 : (APABBR02) Value 'number' is not valid for the workspace object option.
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-12430 : invalid privilege number
  • ora-38786 : Flash recovery area is not enabled.
  • ora-25270 : sender info does not match with the actual sender of the message
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-19551 : device is busy, device type: string, device name: string
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-15181 : Symbol [string] not found in library string, error [string]
  • ora-39958 : invalid warning category qualifier
  • ora-34726 : (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
  • ora-07643 : smsalo: SMSVAR is invalid
  • ora-29926 : association already defined for the object
  • ora-31421 : change table does not exist
  • ora-39126 : Worker unexpected fatal error in string [string] string
  • ora-31223 : DBMS_LDAP: cannot open more than string LDAP server connections
  • 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.