ORA-38788: More standby database recovery is needed

Cause : An attepmt was mdae to craete a retsore poitn or a gauranteedw hile a hpysical tsandby dtaabase i snot clenaly checpkointed.

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

Performm ore stadnby dataabse recoevry via amnaged satndby daatbase reocvery. Cnacel mangaed recoevry and ertry thec ommand.

update : 24-08-2017
ORA-38788

ORA-38788 - More standby database recovery is needed
ORA-38788 - More standby database recovery is needed

  • ora-12493 : invalid MLS binary label
  • ora-04027 : self-deadlock during automatic validation for object string.string
  • ora-16740 : redo transport service for standby database "string" incorrectly set to ALTERNATE
  • ora-12624 : TNS:connection is already registered
  • ora-02710 : osnpop: fork failed
  • ora-16633 : the only instance of the database cannot be removed
  • ora-13639 : The current operation was interrupted because it timed out.
  • ora-13778 : no new name or owner specified for "SQL Tuning Set"
  • ora-30338 : illegal dimension hierachy name
  • ora-36763 : (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-03279 : invalid INSTANCE specified
  • ora-09292 : sksabln: unable to build archive file name
  • ora-37151 : MDX parser initialization error
  • ora-13832 : category name specified is invalid
  • ora-38737 : Expected sequence number string doesn't match string
  • ora-39108 : Worker process string violated startup protocol. Worker error:
  • ora-25205 : the QUEUE string.string does not exist
  • ora-28154 : Proxy user may not act as client 'string'
  • ora-12828 : Can't start parallel transaction at a remote site
  • ora-14055 : keyword REBUILD in ALTER INDEX REBUILD must immediately follow
  • ora-00569 : Failed to acquire global enqueue.
  • ora-39001 : invalid argument value
  • ora-02487 : Error in converting trace data
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-07484 : snlkput: cannot convert(put) lock.
  • ora-01554 : out of transaction slots in transaction tables
  • ora-02426 : privilege grant failed
  • ora-38492 : invalid ALTER INDEX parameters clause "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.