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

Get Oracle® Database 10g Insider Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.