Oracle HA On A Budget: Manual Standby Database

This is the second in a series of abstracts I’ve submitted for the Collaborate 2008 conference in Denver CO.

A little known fact is that Oracle’s standby technology - the stuff DataGuard is built on top of - is available in Standard Edition of Oracle. With a little elbow grease, and some simple scripts, we can have a rudimentary and functioning HA solution in Oracle SE.

1. Intro
2. Anatomy of a Standby Database
3. What’s there in Oracle SE
4. Setup standby
5. Shipping logs
6. Applying logs
7. Verifying setup
8. Manual Failover
9. Conclusions

Leave a Reply