Failover Technology- Clustering

[Kumud]

hi!
We are thinking of solution for fialover database. We need to decide technology.

Does any body share there experience (pros and cron) with

Veritas Clustering
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.

[pando]

if it's fail over use veritas or standby db

[Kumud]

If it is veritas does it require to install oracle parallel server.
which one is more better veritas or standby

[Shestakov]

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.

[Zaggy]

Is Oracle transparent failover option a valid option?

[Kumud]

Thanks guys
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.
3. Reliable

It is 24/7 database.

[pando]

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

[buffalodba]

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.