How to Build a Manual Standby Database with Oracle Database Standard Edition (SE2)!
Near zero data loss! Save on the cost of Enterprise Edition!
Data Guard can deliver zero data loss. Consider the worst case: someone steals your DB server and sells it on EBay. If you have Data Guard appropriately configured to replicate and apply changes to a remote standby you will lose no data, failover will be automatic, and downtime will be minimal. However, Data Guard requires Enterprise Edition licenses.
What can you do if you are running on Standard Edition?
You can configure a Manual Standby instead. It requires a bit more work because you don’t have all the automation that comes with Data Guard, and you are vulnerable to a small loss of data. But the work can be scripted, and the data loss kept down to a few minutes.
In this tutorial we’ll demonstrate the whole process.
Some of the content could be described as “advanced”. Basic DBA skills will be needed, and familiarity with OS and database command line tools.
John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database
- Lectures 1
- Quizzes 0
- Duration 57 minutes
- Skill level All levels
- Language English
- Students 8
- Assessments Yes