O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required