Primary and Standby Databases
SQL Server has an option to do log shipping to another database server. The logs are then applied to the database that is in recovery mode. The failover does not happen automatically, but the database is kept current by applying the recent transactions. If there is a failure on the primary server, the database on the secondary server can have the latest possible log applied, and then be taken out of recovery mode for regular use by connections.
Oracle offers the option of a standby database with Oracle Data Guard as another type of failover. The primary and secondary database servers do not share any of the database files or disk. They can even be servers located in completely different data centers, which offers ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
