Skip to Main Content
  • Questions

  • Create a physical standby for 12c RAC

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, vidya.

Asked: May 22, 2018 - 7:06 pm UTC

Last updated: May 23, 2018 - 8:08 am UTC

Version: 12.1.0.2

Viewed 1000+ times

You Asked

hi - this weekend we have a project that is going live. we will be importing data (about 1TB) into the database. after that we want to create the physical standby. what is the best, efficient and most proven way to create a physical standby database for 12c RAC ? this server also hosts other production databases so we have to make sure we dont impact them as well.

Thanks.

and Connor said...

The best, efficient and most proven way is the follow the steps to create one in the documentation:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sbydb/creating-oracle-data-guard-physical-standby.html#GUID-B511FB6E-E3E7-436D-94B5-071C37550170

And the best way to *manage* it once created is with the broker

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dgbkr/oracle-data-guard-broker-concepts.html#GUID-723E5B73-A350-4B2E-AF3C-5EA4EFC83966

There will be an impact during creation of the standby, because you'll be copying 1TB of data. Once created though, standby's normally run with very little impact -they are just doing redo log recovery on the target node. The impact of this can be measured with your testing environment :-)

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database