We are in the process of implementing Recover Point to replicate Oracle databases. I am wondering if anyone a similar setup today and any experiences or knowledge they would like to share. With Oracle one concern we have is currently we start the database in "crash recovery mode". This seems to work fine but may not be the optimum method. We are also looking at using CLI to create our own bookmarks during hot backups so Oracle is aware a "sync point" of sorts. Any experience or information you have would be greatly appreciated. Thanks Rod
Hi Rod You are actually in the Replication Manager Forums where the majority of watchers/visitors to this forum would not have any exposure (yet!) to RecoverPoint. You probably may not recieve an replies on your post.
While there is no forum yet for RecoverPoint as you well know (I have seen your post) - we are striving to get this up and running.
There are many instances of RP with Oracle in the field. What OS is Oracle running on and what version of RP are you using?
Hello James, Thanks for working to getting a Recover Point forum up. Today we have HP-UX hosts and will be building out Red Hat servers in 2008. We have some fairly large databases to replicate and Recover Point seems very fast and simple to operate. It would be great to correspond with other clients to see what experience with Oracle they encountered. We are concerned with the aspect of pushing the database and doing Oracle "crash recoveries". We think we have some ways to mitigate that with bookmarks?
Well, where do we start... I recommend firstly you acustomize yourself to the can and can-nots of RecoverPoint. Have a detailed look over the RecoverPoint support matrix on eLab. https://elabnavigator.emc.com/
Currently, there are different scripting approaches to replicating Oracle, depending on the customer requirements. If you would like a crash-consistent copy, then a bookmarked copy of Oracle is good enough, as long as you have the other entities of Oracle replicated too (Control, arch redo, online redo, DBs)
some people peform scripting sqlplus begin backup, take abookmark copy the online logs mount the bookmark copy over the redo logs online the DB with redo.
Lets see if more people reply with their particular experiences. James.
JamesBEMC
257 Posts
374
0
Posted December 7th, 2007 00:00
You are actually in the Replication Manager Forums where the majority of watchers/visitors to this forum would not have any exposure (yet!) to RecoverPoint.
You probably may not recieve an replies on your post.
While there is no forum yet for RecoverPoint as you well know (I have seen your post)
There are many instances of RP with Oracle in the field.
What OS is Oracle running on and what version of RP are you using?
Thanks
James.