Home » RDBMS Server » Server Administration » Anyone work with EMC SRDF?
icon5.gif  Anyone work with EMC SRDF? [message #132228] Thu, 11 August 2005 08:05 Go to next message
Chad Heidema
Messages: 6
Registered: May 2002
Junior Member
Wondering if anyone out there has used EMC SRDF to replicate data to a secondary storage array. We're looking to do SRDF Semi Syncronous replication and I don't think Oracle supports this mode, only syncronous.
Re: Anyone work with EMC SRDF? [message #132518 is a reply to message #132228] Sat, 13 August 2005 15:37 Go to previous messageGo to next message
dallas
Messages: 9
Registered: April 2005
Junior Member
Using SRDF is a viable option for replicating your Oracle database. However, you only gaurantee success by placing your device pairs in synchronous mode prior to splitting. This is required by EMC unless a force is given. If you are not in synchronous mode your database is chronologically inconsistent and cannot be gauranteed to open as the current redo log group might be corrupt. You have three options with SRDF. 1) Go into synchronous mode prior to splitting while having your entire database in user-managed backup mode (copy backup controlfile and archive logs to your remote machine and recover). 2) You can create a consistency group and perform a consistent split operation (also requires synchronous mode). Or, 3) suspend your database and perform a split operation. The impact to your front-end I/O during a consistent split is a function the number of devices in your consistency group. The consistent split operation will suspend writes to the devices in question for a second or two while splitting the RDF pairs.
Re: Anyone work with EMC SRDF? [message #132626 is a reply to message #132228] Mon, 15 August 2005 06:37 Go to previous messageGo to next message
Chad Heidema
Messages: 6
Registered: May 2002
Junior Member
Thanks for the reply, but we're going to use SRDF for disaster recovery so it would be an unplanned outage where we couldn't put the pairs in in synchronous mode as we wouldn't know when the outage would occur. We'll be essentially disconnecting the network connection on the secondary array and seeing if the database will open.
Re: Anyone work with EMC SRDF? [message #132630 is a reply to message #132626] Mon, 15 August 2005 07:08 Go to previous messageGo to next message
dallas
Messages: 9
Registered: April 2005
Junior Member
Without your device pairs being in synchronous mode and/or the use of hot-backup mode or consistent splits I am very doubtful your database will open. One other option is to periodically establish and split. This of course may affect your recover point objective and recovery time objective. But you will at least have a stable version of your database as of X hours before the unplanned outage. Another option is Data Guard and a Standby Database.
Re: Anyone work with EMC SRDF? [message #132634 is a reply to message #132228] Mon, 15 August 2005 07:13 Go to previous messageGo to next message
Chad Heidema
Messages: 6
Registered: May 2002
Junior Member
We'll be testing it so I'll let you know.
icon7.gif  Re: Anyone work with EMC SRDF? [message #132636 is a reply to message #132228] Mon, 15 August 2005 07:18 Go to previous messageGo to next message
dallas
Messages: 9
Registered: April 2005
Junior Member
Good luck.
Re: Anyone work with EMC SRDF? [message #132644 is a reply to message #132228] Mon, 15 August 2005 08:15 Go to previous message
Chad Heidema
Messages: 6
Registered: May 2002
Junior Member
Jason from EMC is referenced on this web page (http://www.oracle.com/technology/deploy/availability/htdocs/vendors_remote_mirror.html), he says it is supported. The whitepaper from EMC says it is not, but when I asked him about it, he said the "comments in the whitepaper
about Semi-Sync SRDF being not supported with Oracle are out of date".
Previous Topic: Migrating from Oracle 8i to 10g
Next Topic: intial extents question?
Goto Forum:
  


Current Time: Tue Feb 04 00:11:19 CST 2025