Skip to Main Content
  • Questions
  • San to San replication over using Data Guard

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, John.

Asked: June 24, 2011 - 5:50 pm UTC

Last updated: June 26, 2011 - 2:23 pm UTC

Version: 10.2.0.4

Viewed 1000+ times

You Asked

Hello, Tom.

What do you think about using SAN to SAN replication as a standby database solution. Do you have any advise or warnings about using SAN to SAN replication with Oracle databases?

Thanks,

John

and Tom said...

I would not even really consider it.

The amount of data transferred using disk based replication on a database is HUGE compared to just shipping redo. Think about it - an insert into a table would:

modify an 8k block of table data
modify at least 3 or 4 other 8k leaf blocks in indexes
generate at least an 8k block of undo data
generate redo to the primary and secondary online redo logs
which eventually turn into your archives

so a single insert could trigger lots of disk to disk based activity. If you used data guard - just the one stream of redo would be sent over. Yes, it is true that a block might be modified many times before being written to disk - but all disk writes of datafiles will be in the block size (typically 8k) regardless of the amount of data modified. It is not unusual for a disk to disk scenario to genearate 7, 8 or more times as much network traffic.

And then there is the fact you have a 'cold' failover site. You cannot use that database on the failover site for anything using disk to disk (except maybe for backing up). No queries, no nothing. In order to failover - you have to script that up.

Data guard was built to easily provide for failover/switchover of your single largest consume of disk - the database. It is what it does.



You use disk to disk for things outside of the database, but to use it for the database - no, I wouldn't do it.

Rating

  (1 rating)

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

Comments

A reader, June 28, 2011 - 3:14 pm UTC

1. If you have a block corruption you would be replicating it...so continue using rman for your backups.
2. If you're on standard edidion you don't get DG so disk replication might be the way to go.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library