Website Search
Find information on spaces, staff, and services.
Catalog Search
Books
Oracle Data Guard 11gR2 administration beginner's guide : learn how to build and maintain Data Guard configurations with real-life, practical examples
- Author / Creator
- Available as
- Online
- Summary
-
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 everyt...
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 flexibility, compatibility, and effectiveness.If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then ""Oracle Data Guard 11gR2 Administration Beginner's Guide"" is for you. With a basic understanding of Oracle database administration, you'll be able
Details
- Creator
- Emre Baransel, Nassyam Basha
- Format
- Books
- Language
- English
- Contributors
- Publication
-
- 1st edition
- Birmingham : Packt Pub., 2013
- Physical Details
-
- 1 online resource (404 p.)
- text file
- ISBNs
- 9781849687911, 1849687919, 1849687900
- OCLC
- ocn852756682, ocn854569174, ocn857920529
- "Learn by doing: less theory, more results"--Cover.
- Includes index.
- English
- 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
- 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 - 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
- Time for action - searching for and fixing any table row uniqueness problem