Zero data loss solution

[chindi]

Team,
We are looking at zero data loss option for one of our customer.
Hows San to San replication with decent bandwidth ?
Db size around 5tb
Oracle 11g , rx2800i4 , No RAC

[Bill Hassell · Accepted solution]

"Zero data loss"

This is a requirement without bounds which means that there is no correct answer.
What if someone cuts the cable?
Or there is a power failure?
Maybe a circuit quits working in an I/O card?

Is the transmission distance less than 1 foot? 1000 feet? 500 miles?
What are the two SANs involved? Do they have replication firmware installed?
What is the replication time frame? 1 second? 1 hour? 1 week?

As you can see, there are just too many questions that are not answered in the specification.