舉報

會員
Oracle Data Guard 11gR2 Administration Beginner's Guide
最新章節:
Index
Usingreal-worldexamplesandhands-ontasks,OracleDataGuard11gR2AdministrationBeginner'sGuidewillgiveyouasolidfoundationinOracleDataGuard.IthasbeendesignedtoteachyoueverythingyouneedtoknowtosuccessfullycreateandoperateDataGuardenvironmentswithmaximumflexibility,compatibility,andeffectiveness.IfyouareanOracledatabaseadministratorwhowantstoconfigureandadministerDataGuardconfigurations,thenOracleDataGuard11gR2AdministrationBeginner'sGuideisforyou.WithabasicunderstandingofOracledatabaseadministration,you’llbeabletoeasilyfollowthebook.
目錄(160章)
倒序
- 封面
- 版權信息
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- Chapter 1. Getting Started
- What is Data Guard?
- Standby database
- Oracle Data Guard evolution
- Oracle Data Guard architecture
- Time for action – monitoring Redo Apply
- Time for action – using interfaces to monitor Data Guard
- Other replication solutions and Data Guard
- Summary
- Chapter 2. Configuring the Oracle Data Guard Physical Standby Database
- Preconfiguration for Data Guard
- Time for action – enabling the archive log mode
- Time for action – enabling force logging
- Time for action – configuring standby redo logs on primary
- Time for action – enabling FRA
- Creating the physical standby database
- Time for action – starting the physical standby instance and making it ready for the RMAN duplicate
- Time for action – running an RMAN duplicate
- Post-installation steps
- Time for action – verifying the standby database configuration
- Time for action – starting stopping and monitoring MRP
- Time for action – verifying synchronization between the primary and standby databases
- Time for action – testing real-time apply
- Summary
- Chapter 3. Configuring Oracle Data Guard Logical Standby Database
- Logical standby database characteristics
- 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
- Creating a logical standby database
- Time for action – making a physical standby database environment ready for conversion
- Time for action – converting a physical standby database into a logical standby database
- Verifying the logical standby database
- Time for action – checking the redo transport service status
- Time for action – checking the SQL Apply service status
- Customization and management in a logical standby database
- Time for action – working with skip rules on a logical standby database
- Time for action – changing the Database Guard setting
- Time for action – creating objects on the logical standby database
- Summary
- Chapter 4. Oracle Data Guard Broker
- Introduction to Data Guard broker
- Data Guard broker features and benefits
- Data Guard broker components
- Implementation of Oracle Data Guard broker
- Time for action – initial setup of Data Guard broker
- Time for action – connecting to Data Guard broker
- Time for action – basic monitoring with Data Guard broker
- Management with Data Guard broker
- Time for action – disabling broker configuration
- Time for action – disabling and enabling database
- Time for action – changing the database name
- Most Common Data Guard broker issues
- Oracle Data Guard fast-start failover
- Time for action – configuring fast-start failover
- Summary
- Chapter 5. Data Guard Protection Modes
- The Maximum Protection mode
- The Maximum Performance mode
- The Maximum Availability mode
- Choosing the correct mode for your requirements
- Changing Data Guard protection mode
- Time for action – changing the protection mode with SQL*Plus
- Time for action – changing the protection mode with Data Guard broker
- Time for action – changing the protection mode with Enterprise Manager Cloud Control
- Summary
- Chapter 6. Data Guard Role Transitions
- Role transition considerations
- Switchover
- Time for action – preliminary tests before performing switchover
- Time for action – switchover with a physical standby using SQL*Plus
- Time for action – switchover with a physical standby using broker
- Time for action – switchover with a physical standby using EM Cloud Control
- Time for action – switchover with a logical standby database using SQL*Plus
- Time for action – switchover with a logical standby using broker
- Failover
- Time for action – failover with a physical standby database using SQL*Plus
- Time for action – failover with a logical standby using broker
- Summary
- Chapter 7. Active Data Guard Snapshot Standby and Advanced Techniques
- Oracle Active Data Guard
- Time for action – enabling Active Data Guard if Redo Apply is running using SQL *PLUS
- Time for action – enabling Active Data Guard if the standby database is shut down
- Time for action – enabling Active Data Guard using broker
- Time for action – Active Data Guard with PeopleSoft
- Time for action – exporting a database backup from Active Data Guard
- Time for action – using the ASH report from the standby database
- Using a snapshot standby database
- Time for action – converting to a snapshot standby database
- Time for action – converting to a physical standby database
- Cascade standby databases
- Time for action – cascade standby database
- Advanced compression in Data Guard
- Time for action – enabling advanced compression
- Preparation of standby on a cross-platform Data Guard
- Time for action – creating a cross-platform Data Guard setup
- Data Guard tuning and wait events
- Summary
- Chapter 8. Integrating Data Guard with the Complete Oracle Environment
- The Oracle Enterprise Manager Cloud Control integration
- Time for action – adding the Data Guard configuration into Cloud Control
- Time for action – enabling/disabling fast-start failover
- Time for action – setting the threshold and creating an incident for estimated failover time metric
- RMAN integration
- Time for action – recovering a primary database using a standby database disk backup
- RAC integration
- Summary
- Chapter 9. Data Guard Configuration Patching
- What is patch and what are patch types?
- Best practices of patching
- Upgrading OPatch
- Performing prerequisite checks of patch
- How to clean up patch history?
- Patching on Data Guard configuration
- Time for action – applying a patch on logical standby
- Time for action – applying PSU on a physical standby database
- Time for action – patch set upgrade of physical standby
- Summary
- Chapter 10. Common Data Guard Issues
- Recreating the standby control file
- Time for action – recreating the standby control file
- Dealing with redo transport authentication problems
- Time for action – changing the SYS password in a Data Guard environment
- Time for action – changing the redo transport user
- Dealing with UNNAMED datafiles
- Time for action – resolving UNNAMED datafile errors
- Closing a gap with an RMAN incremental backup
- Time for action – closing a gap with an RMAN incremental backup
- Fixing NOLOGGING changes on the standby database
- Time for action – fixing NOLOGGING changes on a standby database with incremental datafile backups
- Time for action – fixing NOLOGGING changes in the standby database with incremental database backups
- Turning on Data Guard tracing
- Gathering diagnostic data
- Time for action – monitoring the database alert log using ADRCI
- Summary
- Chapter 11. Data Guard Best Practices
- Configuring a connection failover
- Time for action – configuring FCF for JDBC connections
- The archived log deletion policy on the standby database
- Time for action – the recommended configuration for archived log maintenance on a standby database
- Using flashback on a standby database
- Time for action – using flashback on a standby database
- Database rolling upgrade using the transient logical standby database
- Time for action – performing a rolling upgrade using the transient logical standby database
- Corruption detection prevention and automatic repair with Oracle Data Guard
- Summary
- Pop Quiz Answers
- Chapter 1 Getting Started
- Chapter 5 Data Guard Protection Modes
- Chapter 6 Data Guard Role Transitions
- Chapter 9 Data Guard Configuration Patching
- Chapter 10 Common Data Guard Issues
- Index 更新時間:2021-08-13 17:12:54
推薦閱讀
- Web程序設計及應用
- 深入淺出Java虛擬機:JVM原理與實戰
- 劍指JVM:虛擬機實踐與性能調優
- 體驗設計原理:行為、情感和細節
- 跟小海龜學Python
- Git高手之路
- Kotlin Standard Library Cookbook
- 自制編程語言
- Vue.js應用測試
- uni-app跨平臺開發與應用從入門到實踐
- 并行編程方法與優化實踐
- C#程序設計基礎入門教程
- Java高手是怎樣煉成的:原理、方法與實踐
- Java EE項目應用開發
- 軟件設計模式(Java版)
- JavaScript Unit Testing
- Unity 3D UI Essentials
- 流程讓管理更高效:流程管理全套方案制作、設計與優化
- Learning Yeoman
- Python for Secret Agents
- 數據庫技術及應用(Access)(第2版)
- 一個APP的誕生:從零開始設計你的手機應用
- C/C++程序設計(第3版)
- 互聯網輕量級SSM框架解密:Spring、Spring MVC、MyBatis源碼深度剖析
- Swift iOS應用開發實戰
- Large Scale Machine Learning with Spark
- React+Redux前端開發實戰
- Oracle 12c數據庫入門與應用
- 計算機技術及創新案例
- Implementing Samba 4