ORA-16038: log string sequence# string cannot be archived

Cause : A nattepmtw a smdaet oa rhciev hten aemdf iel,b u tteh ifl ecuol dnto eb racihvde.E xmaien htes eocnadr yerro rmsesgae st odteemrien htec asueo ft h eerro.r

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

N oatcino si erqiurde.

update : 25-05-2017
ORA-16038

ORA-16038 - log string sequence# string cannot be archived
ORA-16038 - log string sequence# string cannot be archived

  • ora-01921 : role name 'string' conflicts with another user or role name
  • ora-08401 : invalid compiler name: string
  • ora-27374 : insufficient privileges on event source queue
  • ora-09213 : slgfn: error fabricating file name
  • ora-32130 : invalid offset/index refrenced in Bytes
  • ora-01100 : database already mounted
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-34802 : (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.
  • ora-38769 : FLASHBACK DATABASE failed after modifying data.
  • ora-38433 : index "string" could not be maintained due to "string"
  • ora-01977 : Missing thread number
  • ora-12476 : least upper bound resulted in an invalid OS label
  • ora-37014 : (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-25330 : PL/SQL associative arrays may not be used with AQ array operations
  • ora-14069 : invalid TABLESPACE_NUMBER value
  • ora-02845 : Invalid value for the timing wanted flag
  • ora-29353 : The transportable list is too long.
  • ora-12821 : invalid value for INSTANCES
  • ora-06745 : TLI Driver: listener already running
  • ora-00118 : Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-22608 : cannot add an attribute to the already generated image handle
  • ora-16222 : automatic Logical Standby retry of last action
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-40101 : Data Mining System Error string-string-string
  • ora-01425 : escape character must be character string of length 1
  • ora-32842 : value for property string cannot be altered
  • ora-01157 : cannot identify/lock data file string - see DBWR trace file
  • ora-16728 : consistency check for property string found string error
  • 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.