Oracle Data Guard 11gR2 Administration Beginner's Guide Learn How to Build and Maintain Data Guard Configurations with Real-Life, Practical Examples
Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flex...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
Birmingham
Packt Pub.
2013
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started; What is Data Guard?; Standby database; Physical standby database; Logical standby database; Snapshot standby database; Oracle Data Guard evolution; Version 7.3
- stone age; Version 8i
- first age; Version 9i
- middle age; Version 10g
- new age; Version 11g
- modern age; Oracle Data Guard architecture; Data Guard services; Redo transport services; Apply services; Time for action
- monitoring Redo Apply; SQL Apply (logical standby databases)
- Role transitionsSwitchover; Failover; User interfaces for administering Data Guard; SQL*Plus; DGMGRL; Enterprise Manager; Time for action
- using interfaces to monitor Data Guard; Data Guard background processes; Other replication solutions and Data Guard; Storage-based replication solutions; GoldenGate and Streams; Summary; Chapter 2: Configuring the Oracle Data Guard Physical Standby Database; Preconfiguration for Data Guard; Data loss consideration; Network bandwidth consideration; Preparing the primary database; Archive log mode; Time for action
- enabling the archive log mode
- Force loggingTime for action
- enabling force logging; Standby redo logs; Time for action
- configuring standby redo logs on primary; Fast recovery area (FRA); Time for action
- enabling FRA; Understanding initialization parameters; DB_NAME; DB_UNIQUE_NAME; LOG_ARCHIVE_CONFIG; LOG_ARCHIVE_MAX_PROCESSES; LOG_ARCHIVE_DEST_n; LOCATION and SERVICE; VALID_FOR; SYNC and ASYNC; AFFIRM and NOAFFIRM; COMPRESSION; MAX_CONNECTIONS; MAX_FAILURE; REOPEN; NET_TIMEOUT; DELAY; LOG_ARCHIVE_DEST_STATE_n; Creating the physical standby database; Standby database-related initialization parameters; FAL_SERVER.
- Time for action
- verifying synchronization between the primary and standby databasesTime for action
- testing real-time apply; Summary; Chapter 3: Configuring Oracle Data Guard Logical Standby Database; Logical standby database characteristics; Not everything must be duplicated; Use for reporting at all times; Independent standby database objects; Protecting writes on replicated standby tables; Limitation for specific data types and objects; High availability and disaster recovery considerations; Preparation for the configuration; Time for action
- checking for the unsupported data types
- STANDBY_FILE_MANAGEMENTDB_FILE_NAME_CONVERT; LOG_FILE_NAME_CONVERT; The physical standby database instance; Time for action
- starting the physical standby instance and making it ready for the RMAN duplicate; Using RMAN duplicate to create physical standby databases; Time for action
- running an RMAN duplicate; Post-installation steps; Verifying the standby database configuration; Time for action
- verifying the standby database configuration; Managing redo apply; Time for action
- starting, stopping, and monitoring MRP; Verifying synchronization between the primary and standby databases
- Time for action
- searching for and fixing any table row uniqueness problem