Detailed information
| Duration: | 5 Days |
|---|---|
| Price: | £1,795 (VAT will be added to this price.) |
| Type: | Training |
| Method: | In a classroom |
| Accreditation: | see course outline for exam details. |
| Prepares for: | This Oracle Database 10g DBA - Part II course covers the main examination topics of the Oracle exam #1Z1-043 Oracle Database 10g: Administration II. |
| Geared towards: | 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. |
| Requirements: | 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 |
| Internship: | none |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
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 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
________________________________________
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
________________________________________
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
________________________________________
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
________________________________________
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
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 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
________________________________________
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
________________________________________
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
________________________________________
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
________________________________________
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
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- c/o YSES, The Enterprise Suite, 9th Floor Centre City Tower, 5-7 Hill Street, Birmingham B5 4UA - B5 4UACity and Borough of Birmingham (England)
- c/o ComputerWorld, Apex House, Westerleigh Business Park, Turner Drive, Yate, Bristol, BS37 5YX - BS37 5YCity of Bristol (England)
- 16 St Mary's Street, Edinburgh, EH1 1SU - EH1 1SUCity of Edinburgh (Scotland)
- Halsbury House, Chancellor Court, 21 The Calls, Leeds, LS2 7EH - LS2 7EHCity and Borough of Leeds (England)
- c/o YSES, St James Court, 30 Brown Street, Manchester, M2 1DH - M2 1DHCity and Borough of Manchester (England)
StayAhead Training
StayAhead Training established 1992, centres throughout the UK...... with a team of full time dedicated professional training consultants......
StayAhead Training has been established since 1992 and is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP Web Deveopment, ITIL & Business Analysis training.
Scheduled courses are available in 6 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client.
Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java, ITIL, Business Analysis and HP-UX .
Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price.
Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.
StayAhead Training has been established since 1992 and is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP Web Deveopment, ITIL & Business Analysis training.
Scheduled courses are available in 6 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client.
Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java, ITIL, Business Analysis and HP-UX .
Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price.
Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.
