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 : 29-05-2017

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

  • ora-36668 : (XSDPART06) string is not a legal RANGE partition.
  • ora-19900 : RESETLOGS must be specified after recovery to new incarnation
  • ora-39044 : Metadata transform string has already been specified.
  • ora-15027 : active use of diskgroup "string" precludes its dismount
  • ora-27300 : OS system dependent operation:string failed with status: string
  • ora-40103 : invalid case-id column: string
  • ora-30362 : dimension column cannot be a sequence
  • ora-37132 : (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.
  • ora-32005 : error while parsing size specification [string]
  • ora-07502 : scgcmn: $enq unexpected return
  • ora-07260 : spdcr: wait error.
  • ora-32773 : operation not supported for smallfile tablespace string
  • ora-39126 : Worker unexpected fatal error in string [string] string
  • ora-19502 : write error on file "string", blockno string (blocksize=string)
  • ora-10259 : get error message text from remote using explicit call
  • ora-24121 : both cascade and a block range passed to DBMS_REPAIR.CHECK_OBJECT procedure
  • ora-25336 : Cannot contact instance string during Streams AQ operation
  • ora-30338 : illegal dimension hierachy name
  • ora-29318 : datafile string is online
  • ora-16027 : parameter string is missing a destination option
  • ora-01158 : database string already mounted
  • ora-03211 : The segment does not exist or is not in a valid state
  • ora-01554 : out of transaction slots in transaction tables
  • ora-16152 : standby database is in 'no-data-loss' protected mode
  • ora-31185 : DOM Nodes do not belong to the same DOM Document
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-01422 : exact fetch returns more than requested number of rows
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-06530 : Reference to uninitialized composite
  • ora-00960 : ambiguous column naming in select list
  • 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.