Oracle Data Guard 11gR2 administration beginner's guide : learn how to build and maintain Data Guard configurations with real-life, practical examples / Emre Baransel, Nassyam Basha.

Format:

Book

Author/Creator:

Baransel, Emre.

Contributor:

Basha, Nassyam.

Language:

English

Subjects (All):

Oracle (Computer file).

Data recovery (Computer science).

Data protection.

Physical Description:

1 online resource (404 p.)

Edition:

1st edition

Place of Publication:

Birmingham : Packt Pub., 2013.

Language Note:

English

System Details:

text file

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

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

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

Notes:

"Learn by doing: less theory, more results"--Cover.

Includes index.

ISBN:

9781849687911

1849687919

OCLC:

852756682