Oracle Database 10g Release 2 Data Guard
|
Summary
|
|
|||||||||||||
Oracle Database 10g Release 2 Data Guard
This course introduces the delegate to the main architectural concepts of Data Guard. Delegates will learn how to use Oracle Data Guard to protect Oracle Databases against planned and unplanned downtime. They will learn how to create and manage physical, logical and snapshot standby databases. They will also learn how to use standby databases in a standby role for reporting, querying and testing purposes.
The Oracle Database 10g Release 2 Data Guard course is also suitable for users of Oracle Database 11g Data Guard.
The delegate will practise:
- Preparing a Primary Database for a Data Guard Configuration
- Creating a Physical Standby Database
- Creating a Logical Standby Database
- Creating a Snapshot Standby Database
- Monitoring a Standby Database Configuration
- Managing a Data Guard Configuration
- Troubleshooting Standby Database Configurations
- Tuning a Standby Database
- Backing up and Recovering a Data Guard Configuration
- Using Flashback in a Data Guard Configuration
- Using the Data Guard Broker
The Oracle Database 10g Release 2 Data Guard course is designed for database administrators and technical support staff who are required to plan and implement Oracle Data Guard configurations.
The Oracle Database 10g Release 2 Data Guard course aims to provide the skills needed to plan, implement, manage and troubleshoot Oracle Data Guard standby database configurations.
A working knowledge of Oracle Database Administration is required. This can be obtained by attendance on the pre-requisite courses. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended.
- Oracle Database 10g DBA - Part I
- Oracle Database 10g DBA - Part II
- Oracle Database 10g DBA Performance & Tuning
- Oracle 11g Release 2 RAC & Grid Infrastructure Administration
- Oracle 10g Application Server Administration
NOTE: Course technical content is subject to change without notice.
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Overview of Data Guard
- Requirements for Maintaining a Standby Database
- Data Guard Terminology
- Levels of Protection
- Physical, Logical and Snapshot Standby Databases
- Role Transition Management Services
- Data Guard Interfaces
- Standby Database Creation
- Data Guard Installation
- Data Guard Architecture
- Processes Active on the Primary Database
- Processes Active on the Standby Database
- Data Guard Architecture and Initialization Processes
- Prepare the Primary Database for Data Guard
- Initialization Parameters for the Standby Database
- Datafile and Controlfile Duplication
- Create the Standby Instance
- Network Files Configuration
- Activate the Standby Database
- Verify Primary and Standby Databases are Working
- Archive Log Loss
- Open the Standby Database
- Shut Down and Start Up the Data Guard Environment
- Active Data Guard
- Monitor the Primary and Standby Databases
- Overview of Redo Transport Services
- How Data Guard Sends Redo Data
- Control when Redo Data is Sent with the VALID_FOR Option
- Handle Transmission Errors
- Manage Archive Gaps
- Levels of Protection
- Overview of Log Apply Services
- Apply Redo Data Immediately
- Delay Redo Data Application
- Terminate Redo Apply Services
- Create a Snapshot Standby Database
- Role Transition Overview
- Prepare the Primary Database
- Prepare the Standby Database
- Perform a Switchover
- Perform a Failover
- Reinstate the Failed Primary
- Change Management Overview
- Add Datafiles or Tablespaces
- Drop Tablespaces and Delete Datafiles
- Transportable Tablespaces
- Rename Datafiles
- Add or Drop Redo Log Files
- Nologging Operations
- Lost Write Detection
- Overview of Standby Database Creation with RMAN
- Create a Suitable Backup with RMAN
- Standby Path and File Names
- Build the Standby Instance
- Create a Standby Database with RMAN
- Overview of Creating a Logical Standby Database using SQL Commands
- Prepare the Primary Database
- Prepare the Standby Database
- Transition a Physical Standby to a Logical Standby
- Start the Standby Instance
- Real Time Apply
- Delete Archives
- Dictionary Views Containing useful Standby Information
- Monitor the SQL Apply Progress
- Overview of SQL Apply Architecture
- Transaction Size Considerations
- DML and DDL Apply Considerations
- Intercept DDL Statements
- Skip DML and DDL on the Standby Database
- Modify a Logical Standby Database
- Materialized Views on the Primary Database
- Table Instantiation
- Restart SQL Apply
- Customize DBA_LOGSTDBY_EVENTS
- Rolling Upgrades using Logical Standby
- Rolling Upgrades on a Physical Standby
- Job Scheduling on a Logical Standby
- Overview of Tuning a Physical Standby Database
- The Significance of Tables without Primary Keys
- Statistics on the Logical Standby
- Transaction Consistency
- Adjusting the Number of Applier Processes
- Adjusting the Number of Preparer Processes
- Tune the Memory for the LCR Cache
- Set the ReopenSecs and NetTimeout Database Properties
- Compress Redo Data
- Optimize SQL Apply
- Implement a Backup and Recovery Strategy
- Backup and Recovery of a Primary Database with a Physical Standby Database
- Backup and Recovery of a Logical Standby Database
- Use a RMAN Recovery Catalog in a Data Guard Configuration
- Create the Recovery Catalog
- Register a Database in the Catalog
- Configure Daily Incremental Backups
- Recover a Datafile on the Primary Database
- Recover a Datafile on the Standby Database
- Overview of Flashback Database Usage in a Data Guard Configuration
- Configure Flashback Database
- Use Flashback Database Instead of Apply Data
- Use Flashback Database and Real Time Apply
- Flashback through Standby Database Role Transitions
- Use Flashback Database after Failover
- Overview of Oracle Data Guard Broker
- Oracle Enterprise Manager Grid Control
- The DGMGRL Command Line Interface
- Data Guard Monitor
- Install Oracle Data Guard
- Use the Data Guard Broker
- Start up the Data Guard Broker
- Prepare for a Configuration Build
- Configure the Primary Database
- Configure the Standby Database
- Enable and Disable the Configuration
- Display and Edit Database Properties
- Set the Configuration Protection Mode
- Configure Fast Start Failover
- Execute a Switchover
- Execute a Failover
- Alter the state of a Database
- Monitor the Configuration
- Access the Data Guard User Interface
- Execute a Switchover
- Execute a Manual Failover
- Alter the state of a Database
- Configure Fast Start Failover
- Enable and Disable Fast Start Failover
- Monitor the Data Guard Configuration
- Create a Physical Standby Database Using EM Grid Control
If you want to find out more about Oracle Database 10g Release 2 Data Guard, you can make an information request below and the school will contact you with further information.
Expenses
StayAhead Training
StayAhead Training - SQL, Oracle, UNIX and Linux training courses delivered by IT experts
StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.
StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.
Specialist IT training for professionals
StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena.
UNIX training courses not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle training courses also have depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.
In-house Professional IT training for your organisation
In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.
StayAhead's focus on IT training
StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.
Show all courses with
StayAhead Training
Request information - obligation free
Contact information for StayAhead Training
Phone no: +44 (0)20 7600 6116 
To request information from Oracle Database 10g Release 2 Data Guard, please fill out the following details:
