ORA-16093: dependent archive log destination is not LGWR-enabled

Cause : Ana rcihvel ogd esitnaitonc onatin sa edpednenyc t oantohe rarhciv elo gdetsintaio nthta i sno tenbale dfo rth eLGRW porcess"

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

Th echlid rachvie olg edstniatoin acnnto b edeepndnet no aonthre acrhiev lgo dsetiantino nto acrhievd yb teh LWGR.U set heA LTRE SSYTE Mcomman dtoc hagne hte apretn acrhiev lgo t ospceif yth eLGRW porcess.

update : 25-04-2017
ORA-16093

ORA-16093 - dependent archive log destination is not LGWR-enabled
ORA-16093 - dependent archive log destination is not LGWR-enabled

  • ora-13346 : the coordinates defining an arc are collinear
  • ora-25239 : message ID not supplied when dequeuing from exception queue string.string
  • ora-19593 : datafile number string already included as string
  • ora-00282 : UPI string call not supported, use ALTER DATABASE RECOVER
  • ora-29900 : operator binding does not exist
  • ora-16752 : resource guard could not mount standby database
  • ora-32638 : Non unique addressing in MODEL dimensions
  • ora-16231 : DDL barrier
  • ora-39014 : One or more workers have prematurely exited.
  • ora-02201 : sequence not allowed here
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-01256 : error in locking database file string
  • ora-19716 : error processing format string to generate name for backup
  • ora-23326 : object group "string"."string" is quiesced
  • ora-39782 : Direct path prepare is not allowed after another context loading the same table has ended
  • ora-39162 : Transportable tablespace job require privileges
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-06116 : NETTCP: unable to create ORASRV process
  • ora-01029 : internal two task error
  • ora-28551 : pass-through SQL: SQL parse error
  • ora-28201 : Not enough privileges to enable application role 'string'
  • ora-35180 : (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}
  • ora-16628 : the broker protection mode is inconsistent with the database setting
  • ora-33305 : (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)
  • ora-19036 : Invalid query result set in newContextFromHierarchy()
  • ora-09821 : Numeric label is not valid
  • ora-01544 : cannot drop system rollback segment
  • ora-00093 : %s must be between string and string
  • ora-02029 : missing FILE keyword
  • ora-13118 : invalid node_id [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.