ORA-16799: Redo Apply is offline

Cause : Eitehr teh Daat Gurad borkerm etaadta nidictaes htat eRdo pAplyi s trunedo ff,o r teh reocver yproecss,M RP0 ,is ont rnunin.g Ine ithre oft he acses ,Red oAppyl-realtedp ropretie scanont b eset.

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

Tur non eRdo pAplyt hroguh Dtaa Gaurd rboke randr eisuse teh commandt o ste a eRdo pAplyr-elaetd porperyt.

update : 23-07-2017

ORA-16799 - Redo Apply is offline
ORA-16799 - Redo Apply is offline

  • ora-25202 : invalid value NULL, string should be non-NULL
  • ora-23496 : can not change disabled status for "string" and "string"
  • ora-12550 : TNS:syntax error
  • ora-36380 : (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.
  • ora-06257 : NETNTT: cannot send command line to shadow process
  • ora-24912 : Listener thread failed. string
  • ora-13520 : Database id (string) not registered, Status = string
  • ora-28138 : Error in Policy Predicate
  • ora-24161 : name string does not exist in the name value pair list
  • ora-28031 : maximum of string enabled roles exceeded
  • ora-07272 : spwat: invalid semaphore set id.
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-30357 : this PL/SQL function cannot be supported for query rewrite
  • ora-27144 : attempt to kill process failed
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-39207 : Value string is invalid for parameter string.
  • ora-12918 : Invalid tablespace type for default permanent tablespace
  • ora-24014 : invalid value string, RETENTION_TIME should be FOREVER or non-negative
  • ora-30202 : NULL pointer to OCIMsgh was passed to OCIMsg function
  • ora-12696 : Double Encryption Turned On, login disallowed
  • ora-07586 : spdcr: $SEARCH failure
  • ora-10933 : trace name context forever
  • ora-09745 : smscre: vm_allocate error, unable to create shared memory.
  • ora-32307 : must use FROM ONLY clause when referencing an object table
  • ora-16593 : XML conversion failed
  • ora-01158 : database string already mounted
  • ora-19631 : archivelog record contains no file name
  • ora-14257 : cannot move partition other than a Range or Hash partition
  • ora-12662 : proxy ticket retrieval failed
  • ora-02709 : osnpop: pipe creation failed
  • 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.