O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

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

Logical Standby Improvements

10g introduces many new enhancements to logical standby databases. New features discussed in this chapter include the following:

  • Zero downtime for instantiation

  • Support for redo log files

  • The PREPARE TO SWITCHOVER command

  • Support for SQL Apply services

  • Rolling database upgrades using SQL Apply

  • Enhanced commands and views that support logical standby database management

Zero Outage for Instantiation

In 10g Release 1 RMAN does not support the new logical standby control file.

Prior to Oracle 10g, the major limitation with logical standby was that DBAs had to accept some type of outage in order to complete the build. The creation of the logical standby required the primary database to be shut down completely or required ...

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