In a previous blog, I discussed the differences between high availability and disaster recovery. Then, in my second post in this series, I looked at how SharePlex can help with disaster recovery. So, in this final post, I’ll discuss how Quest SharePlex…
In my earlier post, I defined the differences between high availability (HA) and disaster recovery (DR). I noted that in designing for DR, you want to build your secondary system so it will survive a large or widespread event, such as a hurricane, earthquake…
If you’re one of the busiest travel sites on the internet and want to perform an AWS cloud migration of your bookings database while simultaneously upgrading your Oracle version, you know that any interruption in service could be costly. It’s simply not…
What if you woke up one morning and found that you had a doppelganger who was enthusiastically running around pretending to be you, spending your hard-earned money and doing who knows what with your identity. It sounds like a nightmare, right? But this…
We all remember Abbott and Costello’s skit “Who’s On First?”. If you haven’t seen it, I highly recommend you pop over to YouTube and give it a watch. It has become one of the legendary classic comedies of all times, with Costello not knowing baseball…
We all remember the movie that came out years ago about a dinosaur theme park where you could see living dinosaurs on an island. Everything worked great until the “bad” guys stepped in and crashed everything causing havoc and of letting the dinos out…
Woohoo! Just got word that my boss approved my January vacation and now I’ll get the opportunity to check several items off my bucket list as I hop across country to the Quest Database Fed Forum in DC on February 20th.
On my First stop I will…
I’ve been interested in weather, meteorology and clouds in the sky for as long as I can remember; which may explain why one of my favorite songs is Joni Mitchell’s “Both Sides Now”. I’ve learned that some clouds are pretty, and…
In recent SharePlex blogs, my colleagues and I have discussed using the Analyze Config command to help gather information to tune SharePlex, and the importance of tuning the target database. In this blog, I’ll attempt to put it all together. This…
When a large customer appreciation company needed to categorize their Oracle auditing data by region, SharePlex came to their rescue. They were already using SharePlex’s Change History feature to track the userid’s, timestamp, before and after data values…
A large educational Institution recently approached us with a problem. Their Student Information and Financial databases were in Oracle, and a data warehouse containing extracts from both of these used for decision making, including opening more sections…
A major financial institution recently completed a project to consolidate all of their employee information, including credentials for building and online access, into a single database. Of course, they protected their…
Moving big amounts of data can be very stressful and quite often requires all of your technical skills. Users expect data migrations to be done quickly and ideally with no downtime and impact on the applications that they are working with.
Sometimes it…
I was looking at my losing Mega Millions ticket last night and thought 'can I ever win this?'
I am not holding out much hope but then I thought, 'how about if I took the winning numbers for the year so far and tried to find a pattern in them?…
SharePlex peer-to-peer setup
Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer replication is not appropriate…
Does the process of replicating data from one source to another fill your body with an inner joy like it does mine? The thrill of changing data in one location and watching those changes appear in another, in my eyes is better than well you know….. Ice…
When installing SharePlex one of the things you need to do is verify the installation is working by using the SharePlex test tables before using your own tables.
There are a couple of scripts you can run to do this but in the video I recorded I show you…
SharePlex has an interesting feature termed Auto-Add that allows objects to be brought into replication as and when they are created on the source. Essentially the ongoing replication creates the objects in the target database once they are created on…
When very large tables are out of sync on the target and Compare is not a suitable sync option, it requires a set of coordinated steps to bring them in sync with the source tables. This is especially true if the downtime on the source table is not acceptable…
When you’re up to your ears in a database upgrade project, like an upgrade to Oracle 12c, you begin to look forward to little things.
Like going a few hours with no system notifications or text messages from your DevOps team.
 |
|
|
Like buying…
If 40,000 tickets for a high-demand concert went on sale at noon today, Ticketmaster could accept all the orders and sell out the venue by 12:03 P.M.
That’s one smooth-running, high-availability box office.
I mentioned in my previous post that…
I’m sure Oracle DBAs everywhere are keeping their collective ears close to the ground waiting for the official announcement on 12cR2. We still, rightly or wrongly, have a habit of waiting for the 2nd release of Oracle versions, but that’s for another…
I remember as a young lad of 12 years of age writing letters to friends and family that I had grown up with. As I would finish the letter, I would jump on my bike and run to the local post office to purchase a stamp for the letter. I’m not going…
During October 2015, Oracle announced that the Extended Support Fee for Oracle Database 11g R2 will be waived until May 31, 2017. After this period, Extended Support for Oracle Database 11g R2 will be offered until December 2020.
A primary concern for…
In database replication, “immediately” never feels quite fast enough for your users, does it?
“We replicate transactions from production databases in real time,” you tell them. “You’ll see the change immediately, as soon as the transactions…
