0

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? Thanks.

0

You should be able to use Flashback Database to get the standby back to the point in time (i.e. SCN) to which the primary was restored (Flashback Database is a requirement for automated failover). If you can do this, then Data Guard should be able to wire things back up together again.

Have a look at these:

If in doubt, though, or if you don't have Flashback Database enabled, then trash the standby and recreate it from scratch.

| improve this answer | |
  • 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 – Franco Sep 17 at 13:01
  • ORA-38726: Flashback database logging is not on. – Franco Sep 17 at 13:11
  • Many thanks Phill. – Franco Sep 17 at 14:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.