Kevin Closson's Blog: Platforms, Databases and Storage

9 Responses to “Oracle OpenWorld 2007”

1. 1 Mike October 12, 2007 at 5:51 am

   Hey Kevin,

   How about blogging on replication? Almost every DR site I’ve seen wether they are using Ostreams, Dataguard or SRDF ends up with some problems during DR fail back. Fail over works ok but fail back is a bitch.

   Especially for large databases (8-12TBs).

   What are your experiences with it?

   Reply
2. 2 marius October 12, 2007 at 7:03 am

   Are you going to present at the unconference?

   Reply
3. 3 kevinclosson October 12, 2007 at 3:25 pm

   Hi Mike,

   I have limited DR experience, sorry.

   Hi Marius,

   I have no idea what the “unconference” is, sorry.

   Reply
4. 4 Paul Rosham October 25, 2007 at 7:52 am

   OK, I have a technical question and you may know the answer.
   If there was a clustered storage system with the same database failes available on a range of IP addresses, would it be possible to direct RAC to write to a file over only one of those IP addresses at a time and from one RAC node, but read from any of them?

   Reply
5. 5 kevinclosson October 26, 2007 at 5:23 pm

   Paul,

   This is easily done. Have and Oracle Net service called “write” executing against one instance and other services called “read[1-N]”. Connect the readers to those services. In general, however, it is really not that healthy to separate your readers from your writers. Cache is faster than wire.

   Reply
6. 6 daniel October 30, 2007 at 3:05 pm

   Your session is up against RAC best practices.
   Is this the only day/time you will be presenting it?

   Reply
7. 7 kevinclosson October 30, 2007 at 6:01 pm

   Hi Daniel,

   No, that will be the only day.

   Reply
8. 8 daniel November 19, 2007 at 9:24 pm

   Kevin,
   anyway to get a copy of the preentation? I wasn’t able to make your session, but I’m very interested in the topic.

   Reply
9. 9 kevinclosson November 20, 2007 at 12:27 am

   Hi Daniel,

   Honestly, the presentation didn’t cover anything that wasn’t spelled out in the paper…the Q&A went beyond, put that is now lost information. Sorry.

   Reply