RMAN restore of primary database – impact on standby database

dataguardoracle-11g-r2restorerman

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.

Best Answer

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.

Related Solutions

In a two-server dataguard setup, can I store the recovery catalog in the same database

If I correctly understand your question as: "I want to create a standby database and later on take backups on the primary like if there would be no standby present"

In this case, you do not need a recovery catalog: quote "An RMAN recovery catalog is required so that backups taken on one database server can be restored to another database server. It is not sufficient to use only the control file as the RMAN repository because the primary database will have no knowledge of backups taken on the standby database." See http://download.oracle.com/docs/cd/E11882_01/server.112/e25608/rman.htm#BAJEDHFB

Row level restore with Oracle Recovery Manager (RMAN)

The answer to your question is no, however....

It sounds like a flashback query is what you need. Query the data as of a time when it existed and when it returns the correct data, insert it into the current table. This solution does require space in the UNDO tablespace sufficient to meet your UNDO_RETENTION requirements. It also doesn't use RMAN, but is significantly simpler than importing the entire schema.

INSERT INTO T1 (
   SELECT * FROM T1 AS OF TIMESTAMP sysdate-1 
   WHERE MyDateColumn = to_date('05/25/2011','MM/DD/YYYY')
);

Best Answer

Related Solutions

In a two-server dataguard setup, can I store the recovery catalog in the same database

Row level restore with Oracle Recovery Manager (RMAN)

Related Question