When you need to perform DDL operations (such as the creation of new
indexes to improve query performance), you will follow the same basic steps:
Chapter 13: Oracle Data Guard 493
1. Stop the application of redo on the logical standby database.
2. Disable Data Guard.
3. Execute the DDL commands.
4. Enable Data Guard.
5. Restart the redo apply process.
For example, to create a new index, start by turning off the Data Guard features:
alter database stop logical standby apply;
alter session disable guard;
At this point, you can perform your DDL operations. When you are done, reenable the Data
Guard features:
alter session enable guard;
alter database start logical standby apply;
The logical standby database will then restart its redo apply process, while the index will be
available to its query users.
This page intentionally left blank
CHAPTER
14
Miscellaneous High
Availability Features
495
496 Oracle Database 11g DBA Handbook
n this chapter, you will see the implementation details for features that can
significantly enhance the availability of your database applications. Some of these
features, such as the LogMiner options, are enhancements of features available
in earlier versions of Oracle. Others, such as the use of the recycle bin and the
flashback database command, have been introduced in Oracle Database 10g and
enhanced in Oracle Database 11g. Other flashback options, such as Flashback Table and Flashback
Query, which rely solely on undo data, were thoroughly covered in Chapter 7.
Pages:
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750