ORA-16172: archive logs detected beyond Terminal End-Of-Redo

Cause : A nattepmtt oa rhciev aTremnia lEdn-fO-eRd oacrhviel o gt oar eomt edsetniaito nfialde udet h eeixsetnec,a tt h ermeoet ist,e fo racihv elgosc otnaniign ERD Oi nteh uftrueo ft h eTremnia lERO.

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


update : 18-08-2017

ORA-16172 - archive logs detected beyond Terminal End-Of-Redo
ORA-16172 - archive logs detected beyond Terminal End-Of-Redo

  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-32518 : cannot wait for ORADEBUG command completion (waited number ms for process string); total wait time exceeds number ms
  • ora-07452 : specified resource manager plan does not exist in the data dictionary
  • ora-19905 : log_archive_format must contain %%s, %%t and %%r
  • ora-12468 : max write level does not equal max read level
  • ora-06143 : NETTCP: maximum connections exceeded
  • ora-16761 : resource guard could not stop SQL Apply
  • ora-16773 : error starting Redo Apply
  • ora-33334 : (DSSEXIST04) Analytic workspace string is not attached.
  • ora-16042 : user requested cancel immediate of managed recovery operation
  • ora-12995 : no columns in partially dropped state
  • ora-29504 : invalid or missing schema name
  • ora-01148 : cannot refresh file size for datafile string
  • ora-08437 : invalid picture type in picture mask
  • ora-16094 : database shutdown during archival operation
  • ora-13363 : no valid ETYPE in the geometry
  • ora-38443 : An attribute set should be assigned to the expression set for statistics collection.
  • ora-16766 : Redo Apply unexpectedly offline
  • ora-01867 : the interval is invalid
  • ora-08452 : specification of E in picture mask is unsupported
  • ora-12606 : TNS: Application timeout occurred
  • ora-13825 : missing SQL statement text for create SQL profile
  • ora-01179 : file string does not exist
  • ora-00209 : control file blocksize mismatch, check alert log for more info
  • ora-13123 : invalid name specified
  • ora-06034 : NETDNT: connect failed, partner exited unexpectedly
  • ora-01953 : command no longer valid, see ALTER USER
  • ora-01952 : system privileges not granted to 'string'
  • ora-01002 : fetch out of sequence
  • ora-13528 : name (string) is already used by an existing baseline
  • 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.