Having recently written an article on it (here), I though a quick run through might help people see how easy it is. Maybe they will get converted like me. 🙂
The star of this video is Liron Amitzi, whose shopping habits have probably boosted the Canadian economy since his move there. By now I expect all the shelves in all the shops in Vancouver have been emptied. 🙂
PS. I know I kept exiting to reconnect when I could have used CONNECT. I told you I’m new to this broker stuff. 🙂
I’ve been using standby databases, on and off, since Oracle 8i. I first wrote about Data Guard for Oracle 9i. I’ve had an article on 11gR2 Data Guard for ages, but up until recently I’ve always used the manual setup.
We’ve got a project coming up that *may* use Data Guard and *may* be installed by a 3rd party, so I figured I better get up to speed with the Data Guard Broker, in case they go that route. It’s been on my list of things to look at since 10g, but I’ve never got round to it until now. 🙂
At this point, I still don’t know if the project will use 11g or 12c, so I had a play with both, which resulted in a couple of overview articles.
From the overview perspective, the usage is pretty much the same. I really only did the 11g one in case that’s the route this project goes. I didn’t bother putting the 11g one on the front page of the website, because I consider it a “backfill” article. 🙂
After having a play with the broker, I actually quite like it. It definitely feels like a simpler and neater solution than doing all the configuration manually.
Remember, this Data Guard stuff is for EE installations. If you use SE, you might want to take a look at Dbvisit, who have a product that allows you to manage standby databases for Oracle SE.
PS. I’m not sponsored by Dbvisit and I have no business links with them. I just think they are a great bunch of people and I like what they do.
While I was in Chile at the CLOUG event I met Arjen and Bertie from Avisit Solutions Limited, who produce an alternative to Oracle Data Guard called Dbvisit. Unlike Data Guard, you can use Dbvisit with Standard Edition, so it can be a real money saver.
The company have started a new blog, so if you have an interest in disaster recovery (and if you don’t, you should) you might want to keep your eye on it.