Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Oracle Data Guard 11gR2 Administration : Beginner's Guide

You're reading from  Oracle Data Guard 11gR2 Administration : Beginner's Guide

Product type Book
Published in Jun 2013
Publisher Packt
ISBN-13 9781849687904
Pages 404 pages
Edition 1st Edition
Languages

Table of Contents (19) Chapters

Oracle Data Guard 11gR2 Administration Beginner's Guide
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Pop Quiz Answers
1. Getting Started 2. Configuring the Oracle Data Guard Physical Standby Database 3. Configuring Oracle Data Guard Logical Standby Database 4. Oracle Data Guard Broker 5. Data Guard Protection Modes 6. Data Guard Role Transitions 7. Active Data Guard, Snapshot Standby, and Advanced Techniques 8. Integrating Data Guard with the Complete Oracle Environment 9. Data Guard Configuration Patching 10. Common Data Guard Issues 11. Data Guard Best Practices Index

Customization and management in a logical standby database


After the initial configuration of a logical standby database, we should make customizations to benefit from the standby at the highest level. Let's see what kind of customizations we are able to do and how we manage a logical standby database environment.

Selective replication in a logical standby database

In principle, we cannot directly specify what to replicate to a logical standby database, but we can specify tables for SQL Apply to skip. When this feature is used, the redo data about the tables specified in the skip rules is still transferred to the standby database, but at the mining stage SQL Apply will omit the relevant redo on the logical standby. We use DBMS_LOGSTDBY.SKIP for this purpose.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}