Performing takeover and takeover by force
Performing a takeover operation simply means the primary database and the standby database will exchange their roles. Usually, a role switching is appropriate during a database upgrade or other planed operation, such as server maintenance, operating system upgrades, and so on.
A takeover by force is suitable in the case that the primary host is no longer available for some reason.
Getting ready
In this recipe, we will perform a takeover from NAV
primary to NAV
standby, and vice versa. We'll also proceed to do a takeover by force, simulating a host failure.
How to do it...
Using Control Center
Right-click on the
NAV
database and select High availability disaster recovery | Manage, and then click on the Takeover HADR button:Next, we get the following dialog box; choose Takeover and click OK:
Now, we can observe that the database roles are changed:
Repeat steps 1 to 4 to switch back the
NAV
standby database to primary role.