yxes2013 wrote:What, exactly, do you want the script to do? If you are trying to determine whether a database is running on a particular server is running and to start a (different?) database on a different server if the first database is down, it sounds like you'd want to adapt something that would normally be used to manage a standby database. But you've told us to forget about a standby database
Thanks for the in-depth analogy. :)
But to be simplistic is, I just want a script. or do you mean there is no such script?
Perhaps there are a handful of people crazy enough to attempt to build something similar to what you are trying to build. I can't imagine why you would. But if you're doing something completely custom, it's going to end up being highly unique.You're going to have to develop the scripts that you need for your unique environment.I am not even sure if our environment is unique :( maybe it is not.
I only want a script for the non-unique environment, and then I will make it "unique" fit.So you want a script to start a standby database? You could start with Niall Litchfileld's You Probably Don't Need DataGuard presentation or this Database Journal article on a manual standby
Two, explain why you want such kind of thing and if you can't, bring in that person who suggested itIts my boss, maybe because of expensive licensing that is why.(as maran guessed)
And last, why not active-active, what's the harm in it?I am only new hire in this company and the dba left awol, maybe he does not know how to setup RAC or because its expensive? or because existing resources is not qualified to be RAC?
RAC-ONE may help you.. You need to install oracle home on atleast 2 machines and install grid infrastructure(ASM+CLUSTERWARE) andCan you give me docs on this one?
configure and all the netowkring components. Create a Single instance database via OUI. THe shared storage should be able to be accessed by both Nodes.