Failover with Oracle Standard Edition 2 19c [message #682673] |
Sun, 08 November 2020 03:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/70464a5906f6fba7b307b3cb2b24e015?s=64&d=mm&r=g) |
bluefoxxp
Messages: 7 Registered: November 2020
|
Junior Member |
|
|
Hello,
I have a customer that doesnt want to have VM but physical machines for Oracle Database. Version is 19c.
Also he doesnt want to buy Enterprise Edition but only Standard Edition, which means I don't have Data Guard available.
Which possibilities do I have to perform manual failover in this scenario?
One scenario that I have in mind:
I use RMAN to duplicate the main database regularly. If the main DB is not accessible by the Oracle clients, the Oracle clients will automatically listen to the duplicated database as both are contained in the tnsname.org file.
Is this scenario working with Standard Edition 19c?
Thanks!
|
|
|
|
|
Re: Failover with Oracle Standard Edition 2 19c [message #682676 is a reply to message #682674] |
Sun, 08 November 2020 05:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
An alternative is an incrementally updated backup. You don't have block change tracking in Standard Edition, but (depending on the size of the database) you may still be able to do an update two or three times an hour. Saves the cost of a second database licence.
And of course have you looked at Standard Edition High Availability? It isn't database failover, but the instance failover is near zero downtime and zero data loss. And does not need a second licence.
|
|
|
|
|
|
|
|
|
Re: Failover with Oracle Standard Edition 2 19c [message #682686 is a reply to message #682684] |
Mon, 09 November 2020 12:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:do I need a second license for the machine that is taken as replacement for the died one or not? For questions like this, you really need to pay an Oracle partner (I work for good one ) for advice. Technical questions, sure, you can get help on a forum from public-spirited people who give their time for free, but for licensing you need something that you can quote when you are busted for being out of compliance.
|
|
|