I've just restored an 11g primary DB that was destroyed. Restored the controlfile from tape and performed a full restore, recovery, and open resetlogs. Looks fine now. How will my physical standby (using dataguard) handle this? When I 'show configuration' in dgmgrl I see:
Configuration - DG_Config Protection Mode: MaxPerformance Databases: TESTDB11 - Primary database TESTDB11A - Physical standby database Error: ORA-16810: multiple errors or warnings detected for the database Fast-Start Failover: DISABLED Configuration Status: ERROR
How can I repair this standby after a restore of the primary?
This is the output from standby status report:
DGMGRL> SHOW DATABASE 'TESTDB11A' 'StatusReport'; STATUS REPORT INSTANCE_NAME SEVERITY ERROR_TEXT * ERROR ORA-16700: the standby database has diverged from the primary database * ERROR ORA-16766: Redo Apply is stopped
ORA-38726: Flashback database logging is not on.