Database Administration (MOSC)

MOSC Banner

ORA-16700 ORA-16766 errors

Hi,

I have got ORA-16700 & 16766 errors on standby database shown as below:

DGMGRL> show database 'JKEPCONSBY';

Database - JKEPCONSBY

 Role:        PHYSICAL STANDBY

 Intended State:   APPLY-ON

 Transport Lag:   (unknown)

 Apply Lag:     (unknown)

 Average Apply Rate: (unknown)

 Real Time Query:  OFF

 Instance(s):

  JKEPCON

 Database Error(s):

  ORA-16700: The standby database has diverged from the primary database.

  ORA-16766: Redo Apply is stopped

 Database Warning(s):

  ORA-16854: apply lag could not be determined

  ORA-16856: transport lag could not be determined

Database Status:

ERROR

=============================

Then I've tried to flashback to scn 6711891, but because the flashback not on, so I've tried to let flashback on, then hit more errors asking for recovery with details below:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center