Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Oracle Database 10g DBA - Part II

Summary
Length:
5 days
Price:
1,795 GBP excl. VAT
Training Provider:
StayAhead Training plusStayAhead Training
Location:
Training Method:
Startdate:  
London: 27/02/2012, 28/05/2012, 20/08/2012, 05/11/2012

About Oracle Database 10g DBA - Part II

Oracle Database 10g DBA - Part II Course Overview
The Oracle Database 10g DBA - Part II course introduces the delegate to advanced
administration tools.  Participants will learn how to plan and implement a
backup and recovery strategy using operating system backups and 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.

Skills Gained
The delegate will practise:
  • Planning a backup strategy and a disaster recovery strategy
  • Altering a database to ARCHIVELOG and NOARCHIVELOG modes
  • Performing online and offline backups
  • Performing complete and incomplete database recovery
  • Recovering a database from non-critical losses
  • Using troubleshooting utilities
  • Using Recovery Manager to perform backups and restorations
  • Using Flashback technology to recover 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
  • Using ASM to store data
  • Using tools to improve the performance of SQL

Who will the Course Benefit?
The Oracle Database 10g DBA - Part II course will benefit anyone who needs to administer, monitor and support an Oracle 10g database.

Course Objectives
This Oracle Database 10g 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 10g databases. Administrators will also learn about
the tools available to monitor database performance and the steps that can be taken
to improve database performance.

Examinations
This Oracle Database 10g DBA - Part II course covers the main examination topics of the Oracle exam #1Z1-043 Oracle Database 10g: 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.

Requirements
Delegates 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 10g DBA - Part I pre-requisite courses.  Knowledge of PL/SQL would be beneficial.  Good operating system knowledge is also essential.

Pre-Requisite Courses
  • Oracle SQL


  • Oracle Database 10g DBA - Part I




Follow-On Courses
  • Oracle 10g SQL Performance Tuning


  • Oracle Database 10g Release 2 Data Guard


  • Oracle 10g Application Server Administration




NOTE: Course technical content is subject to change without notice.

Oracle Database 10g DBA - Part II Training Course
Course Contents - DAY 1
Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: BACKUP AND RECOVERY CONSIDERATIONS
  • 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

Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES
  • Architectural Components of Backup and Restore
  • Redo Logs, Checkpoints and Archives
  • Multiplexing Control Files and Redo Logs
  • Types of Database Failure

Session 3: USING ARCHIVELOG AND NOARCHIVELOG MODES
  • Configuring a database in Archivelog mode
  • Configuring a database in Noarchivelog mode
  • Configuring multiple redo log archive processes
  • Configuring multiple archival destinations

Session 4: PHYSICAL BACKUP WITHOUT RMAN
  • Closed and Open Backups
  • Using operating system commands for database backup
  • Performing Offline Backups
  • Performing Online Backups
  • Backup in Logging and Nologging Modes
  • Control File Backups
  • Data Dictionary Views for Backup Operations

Session 5: COMPLETE DATABASE RECOVERY WITHOUT RMAN
  • Recovery in NOARCHIVELOG Mode
  • Recovery in ARCHIVELOG Mode

Oracle Database 10g DBA - Part II Training Course
Course Contents - DAY 2
Session 6: INCOMPLETE RECOVERY WITH ARCHIVING
  • When to use Incomplete Recovery
  • Performing an incomplete Recovery
  • Recover from Losing Current and Inactive Noarchived Redo Log Files

Session 7: ADDITIONAL RECOVERY ISSUES
  • Minimizing downtime
  • Rapid crash recovery
  • Checkpointing and cache recovery
  • Parallel recovery
  • Trial recovery
  • Recover a database with missing data files
  • Rebuilding lost or damaged control files
  • Recovering read-only tablespaces

Session 8: GLOBALIZATION
  • Overview of globalization
  • Language encoding schemes
  • NLS character sets
  • NLS language and territory definitions
  • NLS data dictionary views
  • Multi language linguistic sorts
  • Date times with timezones
  • Display formats
  • Date functions
  • Case and accent insensitive sorts

Session 9: TROUBLESHOOTING UTILITIES
  • Using Log and Trace Files to Diagnose Problems
  • Detecting Block Corruption
  • The ANALYZE Command
  • The DBMS_REPAIR Package
  • Use DBVERIFY to Validate the Database File Structure
  • Block Media Recovery

Oracle Database 10g DBA - Part II Training Course
Course Contents - DAY 3
Session 10: RECOVERY MANAGER OVERVIEW
  • RMAN Features and Components
  • Connecting to RMAN without a Recovery Catalog
  • Start Up and Shut Down a Target Database Using RMAN

Session 11: CREATING AND MAINTAINING A RECOVERY CATALOG
  • Creating a Recovery Catalog
  • Use a Flashback Recovery Area
  • Register a Database
  • Connecting to RMAN
  • Control File Information
  • RESYNC CATALOG command
  • Configure Persistent RMAN Settings
  • Retention Policies
  • Control File Autobackups

Session 12: BACKING UP WITH RMAN
  • Channel allocation
  • Types of RMAN Backup
  • Backup Commands
  • Backup sets parallelization
  • Compressed backups
  • Performing backups
  • Full closed and open backups
  • Incremental and cumulative backups
  • The copy command
  • Block change tracking
  • Troubleshooting

Session 13: MAINTAINING A RECOVERY CATALOG
  • Reset Database command
  • Change the Availability Status of Backups and Copies
  • Catalog Backups Made with Operating System Commands
  • Cross Check Backups and Copies
  • Delete backups
  • Use data dictionary tables
  • Update the repository after backup deletion
  • Drop database

Oracle Database 10g DBA - Part II Training Course
Course Contents - DAY 4
Session 14: RESTORING AND RECOVERING WITH RMAN
  • Perform recovery in noarchivelog mode
  • Perform complete recovery in archivelog mode
  • Incomplete recovery using UNTIL TIME and UNTIL SEQUENCE
  • Restore and recover a tablespace
  • Restore and recover datafiles
  • Recover a datafile not backed up
  • Apply incremental backups to restore datafile image copies
  • The SWITCH command

Session 15: FLASHBACK
  • 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

Session 16: MANAGING RESOURCES WITH RESOURCE MANAGER
  • Overview of the Database Resource Manager
  • Create resource plans and consumer groups
  • Create resource plan directives
  • Control resource by user groups
  • Specify an instance plan
  • Fixed CPU Quotas
  • Integrate Resource Manager and Profiles
  • Automatic session assignment
  • Monitor the Resource Manager

Session 17: AUTOMATIC STORAGE MANAGEMENT
  • Overview of ASM
  • ASM initialization parameter files
  • ASM instance creation
  • Administer ASM disk groups
  • Execute SQL commands with ASM file names
  • ASM instance startup and shutdown
  • Migrate a database to ASM

Oracle Database 10g DBA - Part II Training Course
Course Contents - DAY 5
Session 18: AUTOMATING TASKS WITH THE SCHEDULER
  • Introduction to the Scheduler
  • Scheduler Architecture
  • Managing jobs and programs
  • Prioritize jobs
  • View job execution details
  • Run external jobs

Session 19: AUTOMATIC DATABASE MANAGEMENT
  • Monitoring the Oracle database
  • Monitoring and managing storage
  • Monitoring and managing memory
  • Automatic PGA Memory Management
  • Automatic Shared Memory Management
  • Self monitoring architecture
  • Automatic Workload repository
  • Metrics, thresholds and alerts
  • Automatic Database Diagnostics Monitor (ADDM)
  • Monitoring and Tuning usage model
  • Setting up Notification rules
  • Using the Advisors

Session 20: MEMORY MANAGEMENT, ALERTS AND WAITS
  • Memory Management
  • Automatic memory management
  • Memory advisors
  • System generated alerts
  • Threshold and event based alerts
  • Wait Interface

Session 21: SQL PERFORMANCE TUNING

  • Automated statistics collection
  • Application statistics collection
  • SQL Tuning advisor
  • SQL Access advisor
  • Segment advisor
  • 10g Hints

Session 22: SECURING THE ORACLE LISTENER
  • Listener Password Authentication
  • Controlling Database Access
  • Securing the EXTPROC Service Entry

Continuing studies

Follow on courses: Oracle 10g SQL Performance Tuning, Oracle Database 10g Release 2 Data Guard, Oracle 10g Application Server Administration

Expenses

£1,795.00

About StayAhead Training

technical it training

SQL, Oracle, UNIX and Linux 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.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

unix, linux, oracle, sql, javaSpecialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has 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.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

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. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

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.

specialist it training


plus Show all courses with StayAhead Training

Request information - obligation free

Get more information from StayAhead Training by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from StayAhead Training, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116
www.stayahead.com

More Information
Request Information
To request information from Oracle Database 10g DBA - Part II, please fill out the following details:

What happens now?
Write a course review
Have you studied » Oracle Database 10g DBA - Part II at » StayAhead Training? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk