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: