Skip to Main Content
  • Questions

  • Active Data Guard different Block Sizes?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ali.

Asked: June 20, 2016 - 1:13 pm UTC

Last updated: July 19, 2017 - 11:25 pm UTC

Version: 12.1.0.2.0

Viewed 1000+ times

You Asked

Dear Tom,
Can we have different block sizes between active and pasiv databases, when using Active DataGuard?

For example:
Block size of 8K for Active and 64 for pasiv database which is in Read only mode?

If so, what can be concicvences when having different block sizes between active and pasiv database?



Thank you
Ali

and Connor said...

I do not believe so. I could not find an explicit remark in the documentation stating it, but since we are copying *files* during the instantiation of the dataguard replica, I can't see how it would be even possible.

Rating

  (1 rating)

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

Comments

Alex, July 10, 2017 - 9:49 pm UTC

Hi team,

I wanted to confirm with you guys, assuming current versions of Oracle, when you do a switchover or failover, be it planned or unplanned, are read-only connections for active dataguard disconnected? Can you use any TAF, FAN etc type features to prevent that if so?

Thank you.
Connor McDonald
July 19, 2017 - 11:25 pm UTC

So just to clarify your question:

- you have a primary db (read/write)
- it is supported by an active dataguard (read only)
- you have sessions on both

Now there is a failover event, so

- active gataguard node becomes an read/write primary node

and in that scenario, will the read only sessions stay/resume connection to the database ?
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.