ORA-16014: log string sequence# string not archived, no available destinations

Cause : An attempt was made to archive the named log, but the archive was unsuccessful. The archive failed because there were no archive log destinations specified or all destinations experienced debilitating errors.

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

Verify that archive log destinations are being specified and/or take the necessary step to correct any errors that may have occurred.

update : 24-07-2017

ORA-16014 - log string sequence# string not archived, no available destinations
ORA-16014 - log string sequence# string not archived, no available destinations

  • ora-19262 : XQ0042 - namespace constructor not inside an element constructor
  • ora-16031 : parameter string destination string exceeds string character limit
  • ora-06111 : NETTCP: disconnect failure
  • ora-16257 : Switchover initiated stop apply successfully completed
  • ora-17506 : I/O Error Simulation
  • ora-28132 : Merge into syntax does not support security policies.
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-19115 : too many context items specified
  • ora-19222 : XP0002 - XQuery dynamic context component string not initialized
  • ora-25960 : join index cannot be based on a temporary table
  • ora-24185 : transformation string.string does not exist
  • ora-31408 : invalid value specified for begin_scn or end_scn
  • ora-07237 : slemcl: invalid file handle, seals do not match.
  • ora-14167 : only one subpartition may be moved
  • ora-19320 : Host name not specified in HTTP URL
  • ora-25152 : TEMPFILE cannot be dropped at this time
  • ora-26730 : %s 'string' already exists
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-22806 : not an object or REF
  • ora-03124 : two-task internal error
  • ora-01028 : internal two task error
  • ora-13369 : invalid value for etype in the 4-digit format
  • ora-00723 : Initialization parameter COMPATIBLE must be explicitly set
  • ora-00822 : MMAN process terminated with error
  • ora-06034 : NETDNT: connect failed, partner exited unexpectedly
  • ora-26699 : STREAMS message consumer string already exists
  • ora-25469 : data not specified for alias: string column name: string
  • ora-30044 : 'Retention' can only specified for undo tablespace
  • ora-39764 : specified stream is not in the specified direct path context
  • ora-14306 : List value 'string' specified twice in partitions '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.