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