Re: EMC SRDF or Advanced Replication????

Pete,

Thanks for the response. A follow-up question for you: From an administration standpoint, it
seems like using updateable snapshots or replication could turn into just an amazing nightmare.
In theory, I would like to believe all the *claims* regarding advanced replication or snapshots,
however how easy/difficult is it in real-life to coordinate all the areas of the snapshot/replication
methodology? For example, if I have to cut over to the failover database at 3:30am, and don't have
access from my telnet session at home to the GUI replication manager, and have to run scripts that
access the replication API, is this fairly easy to do, or very complex?

Thanks in advance,

Steve

Pete Sharman <psharman_at_us.oracle.com> wrote in message news:36FC2197.704DBF87_at_us.oracle.com...
> Steve
>
> Been there done that, but I don't have an answer for you. It's not just
> the transactions per minute that has a bearing here, but the overall data
> volume. It's a lot easier to do 3000 transactions that change 1 byte than
> 3000 that change 200 bytes.
>
> The only answer with these sort of decisions is volume test, volume test,
> volume test. Remember SRDF is supported in synchronous mode, and that the
> version of Oracle you run has a big bearing too (8.1 has greater
> throughput than 8.0, which likewise has greater throughput than 7.3).
>
> HTH.
>
> Pete
>
> Steve Graham wrote:
>
> > Fellow Gurus,
> >
> > Would you use SRDF or Replication for a failover system,
> > that had to keep current on approximately 2000-3000 transactions
> > per minute. Oracle8 on Solaris 2.6 is the platform. All transactions
> > would be propagated over whatever network bandwidth is necessary, I
> > could conceivably do it either way, looking for feedback from people
> > who've 'been there done that'.
> >
> > Regards,
> >
> > Steve
>
> --
>
>
> Regards
>
> Pete
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Peter Sharman Email: psharman_at_us.oracle.com
> WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> Worldwide Internal Services Education (650)607 0109 (local)
> San Francisco
>
> SQL> select standard_disclaimer, witty_remark
> 2 from company_requirements;
>
> Opinions are mine and do not necessarily reflect those of Oracle
> Corporation
>
> "Controlling application developers is like herding cats."
> Kevin Loney, ORACLE DBA Handbook
> "Oh no it's not! It's much harder than that!"
> Bruce Pihlamae, long term ORACLE DBA
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
Received on Fri Mar 26 1999 - 21:03:10 CST