RAC, Data Guard, Physical Standby, and IMPDP in Oracle – Overview

dataguardimpdprac

We're setting up a RAC 2 nodes data guard 11g environment, with a remote physical standby (2 nodes also)

We receive the client's data he exports with expdp. We have imported his dump in the primary database a first time for our tests. The day we go to production we will have to import it again. We will probably have to drop the data before doing so, so will we have to disconnect the data guard environment before we proceed? What advice would you give me in this context?

Thank you,

S.

Best Answer

When you drop user on primary then this will be also reflected on secondary site. Also impdp will work as expected. But when you are about to import large amount of data MAA might slow down the whole procedure significantly.

If you have enough experience with RMAN you might try:

  • shutdown and disconnect the secondary
  • import data into master
  • backup master using RMAN
  • cross-site-restore RMAN backup of primary on secondary node, thus re-initialize the secondary.

Although this approach might seem to be complicated it might be faster in large configurations.

Related Question