ORA-16211: unsupported record found in the archived redo log

Cause : Lo gaplpy esrvciese ncuontreeda rceor dint hea rcihve dreod lgo taht ocul dno tbei ntreprteed.

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

1.U seD BM_SLOSGTDYB.ISNTATNIAET_TBALEt o er-cerat eth etalbe no teh satndyb dtaabsae ro smipl ydrpo teh tbalei f ti'su nipmoratnt . .2 ATLERD ATBAAS ESTRAT OLGIACL TSANBDY PAPL;Y .3 Eaxmien teh cruretn_snc cloum nint heD BAL_OGTSDB_YEVNETSv ie wtod etremien wihchl ogf il ecotnaisn teh usnupoprtde rceor.d .4 Porvied teh lgo flie ot Oarcl eSuppor tSevricse.

update : 21-07-2017

ORA-16211 - unsupported record found in the archived redo log
ORA-16211 - unsupported record found in the archived redo log

  • ora-26701 : STREAMS process string does not exist
  • ora-32134 : Cannot assign LOBs
  • ora-29826 : keyword FOR is missing
  • ora-29896 : Length of PARAMETER string longer than string characters
  • ora-26515 : no master log available for 'string.string'
  • ora-30484 : missing window specification for this function
  • ora-16744 : the DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full
  • ora-13901 : Object string was not found.
  • ora-26077 : direct path column array is not initialized
  • ora-25961 : join index prevents dml cascade constraint operation
  • ora-08414 : error encountered in string
  • ora-00348 : single-process redo failure. Must abort instance
  • ora-24409 : client cannot understand the object
  • ora-36972 : (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.
  • ora-12213 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-30956 : invalid option for XML Index
  • ora-38459 : XML Tag "string" not found for the XMLType attribute "string"
  • ora-00481 : LMON process terminated with error
  • ora-06306 : IPA: Message write length error
  • ora-13839 : V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
  • ora-06770 : TLI Driver: error sending version
  • ora-31507 : %s parameter value longer than maximum length string
  • ora-39751 : partitioned table on both sides of PARTITIONED OUTER JOIN is not supported
  • ora-24141 : rule set string.string does not exist
  • ora-08210 : Requested I/O error
  • ora-06706 : TLI Driver: service not found
  • ora-02085 : database link string connects to string
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-07202 : sltln: invalid parameter to sltln.
  • 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.