Oracle Database 11g Release 2 DBA - Part II
|
Summary
|
|
||||||||||||||||||||
Oracle Database 11g Release 2 DBA - Part II
This Oracle Database 11g Release 2 DBA - Part II course introduces the delegate to advanced administration tasks. Participants will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will also learn how to control database resources using the Resource Manager; how to automate administration tasks with the Scheduler and how to carry out performance monitoring and tuning.
This Oracle Database 11g Release 2 DBA - Part II course is suitable for both users of Release 1 and Release 2.
The delegate will practise:
- Planning a backup strategy and a disaster recovery strategy
- Altering a database to archivelog and noarchivelog modes
- Managing memory
- Using Recovery Manager to perform backups and restorations
- Using Flashback technology to diagnose and repair a database
- Reviewing database logs for diagnostic purposes
- Using Database advisors and views to monitor and improve database performance
- Controlling database resources using Resource Manager
- Automating management tasks with the Scheduler
This Oracle Database 11g Release 2 DBA - Part II course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g Release 1 or Release 2 databases. Administrators will also learn about the tools available to monitor database performance and the steps that can be taken to improve database performance.
The Oracle Database 11g Release 2 DBA - Part II course introduces delegates to the main concepts of Oracle backup and recovery. They will learn how to plan and implement a backup and recovery strategy using RMAN. Delegates will also learn to manage memory effectively, carry out some evaluation and tuning exercises, control database resources using Resource Manager and automate tasks with the Scheduler.
The course covers the major topics required for the Oracle examination 1Z0-053 Oracle Database 11g: Administration II.
Exams are not included as part of the course.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Delegates who wish to attend this Oracle Database 11g Release 2 DBA - Part II course should have a working knowledge of Oracle SQL and Oracle Database Administration, good operating system knowledge is also essential. This can be obtained by attendance on the Oracle SQL and Oracle Database 11g DBA - Part I courses. Knowledge of PL/SQL would be beneficial.
- Oracle SQL
- Oracle Database 11g Release 2 DBA - Part I
- Oracle 11g SQL Performance Tuning
- Oracle Database 11g Release 2 Data Guard
- 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
- Oracle Suggested Backup Strategy
- Plan and Implement a Backup and Recovery Strategy
- Define a Backup Strategy
- Define a Disaster Recovery Plan
- The Advantages and Disadvantages of Different Backup Methods
- Test a Backup and Recovery Plan
- Backup Strategy
- Recovery Strategy
- Validate the Recovery Strategy
- Architectural Components of Backup and Restore
- Redo Logs, Checkpoints and Archives
- Multiplexing Control Files and Redo Logs
- Types of Database Failure
- Automatic Shared Memory Management
- PGA Memory Management
- Automatic Memory Management
- The Memory Advisor
- Memory Allocation Advisors
- Memory Management Data Dictionary Views
- The Archive Modes of a Database
- Altering the Archive Mode of a Database
- Configuring Multiple Archival Destinations
- Configuring Multiple ARCH Processes
- Data Dictionary Tables for Archiving
- Database Synchronization
- Automatic Block Corruption reporting
- Automatic Quarantine of Corrupt Redo Segments
- Protection from Data Corruptions
- Analyze Validate Structure
- Automatic Diagnostic Repository (ADR)
- The ADR Command Line Tool (ADRCI)
- Proactive Monitoring with the Health Monitor
- Overview of Recovery Manager
- RMAN Features and Components
- Connect to RMAN
- Start Up and Shut Down a Target Database Using RMAN
- Recovery Catalog Overview
- Create a Recovery Catalog
- Use a Flashback Recovery Area
- Register and Unregister a Database
- Control File Information
- RESYNC CATALOG command
- Virtual Private Catalogs
- Merge Catalogs
- Backup a Recovery Catalog
- Channel Allocation
- The Configure Channel Command
- Types of RMAN Backup
- Recovery Manager Commands
- Performing Backups with RMAN
- The Backup Command
- The Copy Command
- Backup File Image Copies
- Perform Full, Incremental and Cumulative Backups
- Use Data Dictionary Tables
- Reset Database Command
- Change the Availability Status of Backups and Copies
- Catalog Backups Made with Operating System Commands
- Generate Reports and Lists
- Configuration Values
- Cross Check Backups and Copies
- Delete Backups
- Drop Database and Archival Backups
- Overview of Restore
- The Restore Command
- Restore a Database in Noarchivelog Mode
- Restore and Recover a Database in Archivelog Mode
- Incomplete Recovery using Until Time and Until Sequence
- Restore and Recover a Tablespace
- Automatic tempfile Recovery
- Restore and Recover a Datafile
- Recover a Datafile Not Backed Up
- Recover Individual Data Blocks
- Recover a Lost Redo Log Group
- Re-create a Password Authentication File
- Apply Incremental Backups to Restore Datafile Image Copies
- The Switch command
- The Data Recovery Advisor (DRA)
- Restore and Recover the Database on a New Host
- Overview of Database Duplication
- Database Duplication
- Duplication Options
- Create Files for the Duplicate Database
- Prepare an Auxiliary Instance for Duplication
- Create a Duplicate Database
- Clone a Running Database without a Backup
- Targetless duplication of a database
- Transport Tablespaces
- Transport Databases
- Recovery Manager Tuning Overview
- Tuning RMAN Backup Performance
- Synchronous and Asynchronous I/O
- Instance Recovery Performance Tuning
- RMAN Messages
- Troubleshoot RMAN
- RMAN Detected Block Corruptions
- Performance impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION
- Configure and Use Flashback Database
- Monitor Flashback Database
- Flash Recovery Area Space Usage
- Flashback Query
- Retrieve Row History with Flashback Versions Query
- Audit or Recover from Transactions with Flashback Transactions Query
- Flashback Table
- Recover Dropped Tables with Flashback Drop
- The Recycle Bin
- Recover Tables to a Point in Time with Flashback Table
- Flashback Database
- Flashback Restore Points
- Flashback Transaction Backout
- Overview of Oracle Total Recall
- Manage Flashback Archives
- Flashback Data Archive and Auditing
- Flashback Data Archive Uses
- Introduction to the Scheduler
- Scheduler Related Parameters
- Access Rights
- Create and enable a Program
- Drop a Program
- Create a Schedule
- Create a Job
- Job Classes
- Windows
- Window Group
- Monitoring and Logging
- Use Time Based, Event Based and Complex Schedules
- Multi Destination Jobs
- Tablespace Monitoring
- Segment Management Enhancements
- Segment Advisor
- Segment Space Estimation
- Online Segment Shrink
- Proactive Tablespace Management
- Free Space Management
- Monitor Space
- Compress Data
- Tuning Activities
- Use Statistic Preferences
- Optimizer Statistics Collection
- Monitor The Performance of Sessions And Services
- Automatic Workload Repository (AWR)
- The Benefits of Automatic Database Replay
- Application and SQL Tuning
- SQL Tuning Advisor
- SQL Access Adviso
- SQL Performance Analyzer
- Overview of ASM
- ASM Instance Creation
- SYSASM Role
- Administer ASM Disk Groups
- ASM Files
- ASM Startup and Shutdown
- Asm Disk Failure
- ASM Data Dictionary Views
- Migrate a Database to ASM Using RMAN
- The ASM Command Line Tool
- Overview of the Database Resource Manager
- Create Resource Plans
- Create Resource Consumer Groups
- Create Resource Plan Directives
- Limit CPU Utilization at the Database Level
- Instance Caging
- Control Resources by User Groups
- Specify an Instance Plan
- Monitor the Resource Manager
- Data Dictionary Views
If you want to find out more about Oracle Database 11g Release 2 DBA - Part II, 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 11g Release 2 DBA - Part II, please fill out the following details:
