ORA-16798: unable to complete terminal recovery on the standby database

Cause : Terminla recovrey on teh standyb databsae failde durin gthe faliover oepration.

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

Check aDta Guadr broke rlog an dalert olgs to ese mored etailso n the erason o fthe faliure.

update : 22-06-2017
ORA-16798

ORA-16798 - unable to complete terminal recovery on the standby database
ORA-16798 - unable to complete terminal recovery on the standby database

  • ora-27010 : skgfwrt: write to file failed
  • ora-30053 : invalid upper limit snapshot expression
  • ora-24165 : invalid rule engine object privilege: string
  • ora-15056 : additional error message
  • ora-14311 : Expecting VALUES LESS THAN or AT clause
  • ora-28347 : encryption properties mismatch
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-08102 : index key not found, obj# string, file string, block string (string)
  • ora-02150 : invalid new tablespace name
  • ora-02079 : no new sessions may join a committing distributed transaction
  • ora-09948 : Process information label retrieval failed.
  • ora-30351 : query rewrite does not currently support this expression
  • ora-31455 : nothing to ALTER
  • ora-19573 : cannot obtain string enqueue for datafile string
  • ora-24154 : rule string.string already in rule set string.string
  • ora-30655 : cannot select FOR UPDATE from external organized table
  • ora-31044 : Top-level prefix length string exceeds maximum string
  • ora-06141 : NETTCP: no privilege for user
  • ora-21706 : duration does not exist or is invalid
  • ora-02452 : invalid HASHKEYS option value
  • ora-13268 : error obtaining dimension from USER_SDO_GEOM_METADATA
  • ora-36691 : (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.
  • ora-16019 : cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
  • ora-09260 : sigpidu: error obtaining process id
  • ora-16540 : invalid argument
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-27022 : skgfqsbi: could not allocate memory for media manager
  • ora-01373 : insufficient memory for staging persistent LogMiner session
  • ora-16582 : could not edit instance specific property
  • 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.