We are thinking of solution for fialover database. We need to decide technology.
Does any body share there experience (pros and cron) with
Oracle Parrallel server
Automatic standby database.
Thinking of OPS but do not know it is worth and liable or not.
Veritas no idea baout it.
ANY help appriciated.
if it's fail over use veritas or standby db
If it is veritas does it require to install oracle parallel server.
which one is more better veritas or standby
Your desisions depend from couple of factors:
- how long time you have for rectore database
- how many boxes you have
- what type of disk equepment you have and may you
create shared disk array or not
If time for restore DB less than 1 min you haven't any desicions exept OPS (or ORC).
If time for restore DB less than 1 h then you can use standby database
But should be ready, that you may lost last transactions.
If time for restore DB more than 1 day you can use veritas volume manager, because if you lost 1 box VVM doesn't help you.
Is Oracle transparent failover option a valid option?
Harware is to be decided based upon selection of filover.
This are basic factor for selection
1. one is better and easy to maintain
2 less amount of loss of transaction.
It is 24/7 database.
You want Oracle failover or OS failover?
Oracle failover there is Oracle Parallel Failsafe, it works like OS failover, OS failover usually takes a while to startup the database whereas Parallel failsafe is much faster
Forget OPS because it's hard to maintainm and because the application has to adapt to OPS not the other way round
Here's my 2 cents worth: if purely from a DB failover, auto standby is good - just remember, you may not get ALL the data over (online redos), but it'll be a quick switchover and config/maintenance is much better now in 8i. Haven't used Oracle Parallel Failover. If from OS, we use Veritas Cluster Server, which is reliable. Also there is SUN Clustering on SUN servers and HP ServiceGuard for HP-UNIX servers that are excellent for OS failover.