Oracle Database 11g: Administration Workshop II Release 2

Using Advanced Backing Up and Recovering Techniques with Oracle 11g

ABOUT THE PROGRAM

The Oracle 11g Database Workshop II starts from where the Workshop I finishes. Having introduced the Oracle tools to the delegates in Workshop I, Workshop II introduces the advanced concepts such as the ASM, RMAN, Flashback, Memory Management etc. The Certification is helpful to the organisation as it cuts company costs, increase a professionals level of service and also inculcate skills in them that the current and prospective employers lookout for. This course mainly deals with Backup and Recovery options of the Oracle Database making use of Flashback and RMAN both for full and partial backups or recovery. Oracle 11g Release 2 has a number of new features that are helpful to developers as well as database administrators. They mainly fall into the categories Application Development, Availability, Business Intelligence and Data Warehousing, Clustering, Database Overall, Diagnosability, Performance, Security, Server Manageability, and Unstructured Data Management.

WHAT'S INCLUDED ?

Find out what's included in the training programme.

Includes

Key Learning Points

Clear and concise objectives to guide delegates through the course.

Includes

Courseware

Courseware will also be provided to the delegates so that they can revise the course after the training.

Includes

Tutor Support

A dedicated tutor will be at your disposal throughout the training to guide you through any issues.

PREREQUISITES

The primary requirement of this course is good knowledge of SQL and PL/SQL concepts. The delegate is also expected to be Oracle Database 11g Workshop I Rel 2 certified.

TARGET AUDIENCE

The following candidates should take this course:

  • Database Administrators
  • Support Engineer
  • Technical Consultant
  • Technical Administrator

WHAT WILL YOU LEARN?

During the course, the delegates learn the following concepts:

  • Backing Up and Recovering A Database from the Command Line Using RMAN
  • Backup and Recovery - Using Enterprise Manager
  • Make Use of Flashback technology to View or Recover a Database to a Past
  • Make Use of A Flexible Memory Configuration For The Oracle 11g Database
  • Separate Sessions having poorly managed SQL Statements.
  • Design The Oracle Database For Model Retrieval
  • Appropriately Distribute Resources to the Database
  • Job Scheduling
  • Optimise Database Storage
  • Diagnosing and Repairing Data Failures with Flashback
  • Manage space to streamline database storage so you can respond to growing space requirements
  • Monitor and control major database components, including memory, performance and resources
  • Make the Database Availability Secure Using Good backup and recovery strategies
  • Automate DBA Tasks with the Scheduler

Enquire Program

Fill in the form below & we'd get back to you.

PROGRAM OVERVIEW

The Workshop II goes beyond the Workshop I concepts. New and advanced tools such as Flashback and RMAN are introduced to the delegates during the course. These tools turn out to be a great help when it comes to taking backup or recovering the database from some crash. The delegates also learn techniques for taking backups in different modes i.e. datewise, full or incremental.

The candidates who wish to certify this exam can take this course in two ways – classroom sessions or online. There is no provision for the course to be completed by the candidate through self-study. The candidate also requires scoring a minimum of 66% marks to get through. The candidate has to answer 78 questions in a time duration of 120 minutes or 2 hours.


PROGRAM CONTENT

  • Oracle Database Architecture and The Concept of Automatic Storage Management
    • ASM - An Overview
    • Set up pfile and spfile for Database and ASM
    • Manage ASM disk groups
  • Configuring for Recovery
    • Create Multiple Archive Logs for Better Recovery
    • Define, apply and use a retention policy 
    • Set Up Recovery Area for Flashback 
    • Use Recovery Area Specified for Flashback
  • Using the RMAN Recovery Catalog
    • Identify situations that require RMAN recovery catalogue
    • Create and configure a recovery catalogue 
    • Synchronise the recovery catalogue
    • Set up and use RMAN stored scripts 
    • Back up the recovery catalogue 
    • Virtual private catalogue – Setup and Use
  • Configuring Backup Specifications
    • Configure backup settings
    • Allocate channels to use in backing up  
    • Set backup optimisation 
  • Creating Backups with RMAN
    • Image file backups
    • Full backups  
    • Fast backup in increments
    • Make duplex backup and back up backup sets 
    • Make an archival backup for long-term retention  
    • Have a multisection, compacted and encrypted backup  
    • Report on and maintain backups 
  • Backup and Recovery: User-Managed
    • TEMP file recovery
    • Redo log groups recovery  
    • Password file recovery
    • Recover The Database Completely
    • Perform An Incomplete Database  Recovery
    • Implement user-managed and server managed backups  
    • Identify the need for backup mode 
    • Backing Up A Control File
    • Recovering Control Files
  • Recovery with RMAN
    • Perform complete recovery using RMAN
    • Perform incomplete recovery using RMAN  
    • Use backups updated incrementally  
    • Switch to image copies for fast recovery 
    • Restore a database onto a new host  
    • Use a backup control file for recovery
    • Perform Disaster recovery 
  • Using RMAN to Duplicate a Database
    • Creating a duplicate database
    • Using a duplicate database 
  • Performing Tablespace Point-in-Time Recovery
    • Identify the situations that require TSPITR 
    • Perform automated TSPITR
  • Monitoring and Tuning RMAN
    • Monitoring RMAN sessions and jobs
    • Tuning RMAN 
    • Configure RMAN for Asynchronous I/O
  • Using Flashback Technology
    • Restore dropped tables from the recycle bin
    • Perform Flashback Query 
    • Use Flashback Transaction
  • Additional Flashback Operations
    • Performing Flashback Table operations
    • Learning to Configure and Observe Flashback Database
    • Performing operations on Flashback Database
    • Flashback Data Archive – Setting Up and Using
  • Diagnosing the Database
    • Automatic Diagnostic Repository - Installing
    • Using Support Workbench  
    • Performing Block Media Recovery 
  • Managing Memory
    • Implement Automatic Memory Management
    • Manually configure SGA parameters  
    • Set automatic PGA memory management 
  • Managing Database Performance
    • The SQL Tuning Advisor
    • The SQL Access Advisor 
    • Understand Database Replay 
  • Space Management
    • Achieve reusable space allocation
    • Portable tablespaces and databases  
    • Using Shrink to Reclaim Waste Space 
  • Managing Resources
    • Database resource manager
    • Create and use Database Resource Manager Components
  • Automating Tasks with the Scheduler
    • Create jobs, programs, and schedules
    • Make use of time-based or event-based plans for executing Scheduler jobs 
    • Create lightweight jobs 
    • Use task chains to perform a series of related tasks 
  • Administering the Scheduler
    • Create Windows and Job Classes
    • Use advanced Scheduler concepts to prioritise jobs

Oracle Database 11g: Administration Workshop II Release 2 Enquiry

 

Enquire Now


----- OR -------

Reach us at 0121 368 7851 or info@msptraining.com for more information.

ABOUT Eastleigh

Eastleigh is located in Hampshire, UK. It is one of the main cities in the area of Eastleigh. The town is the part of South Hampshire and lies between Winchester and Southampton. The foremost considerable development was a railway town. The city located on River Itchen is one of the Uk’s premier chalk streams.

 

History:

Eastleigh is situated on the ancient Roman road that was constructed in 79 A.D. between Bitterne and Winchester. During the Roman era, the Eastleigh area was dominated by Roman people as it was confirmed after the excavation of coffins, their remains and others weapons. A record shows the existence of village named Saxon village since 932 A.D.

One more additional evidence of the presence of the Romans was declared in a survey conducted by TIME. King Ethelstan granted some portion of land in North Stoneham during military aid. There is one museum called Eastleigh Museum in the town. It is located in the High Street, and it holds the information regarding the city and the nearby villages.

 

Education:

There are two colleges for further education in Eastleigh including Eastleigh College and Barton Peveril Sixth Form College. Norwood Primary School, the Crescent Primary School, Cherbourg Primary School are famous primary schools that are giving services to the northern city. Crestwood College is the only secondary school in the town.

 

Religion

In the early 1930s, the church was founded called Emmanuel Baptist Church. It is located in the former Desborough Mission Hall.

 

Sport:

Eastleigh F.C.

It is the only senior football team that is playing from 2014-2015 in the Conference Premier.

 

Solent Kestrels

The game of basketball is very prominent in the region, and Solent kestrels are the most followed basketball club here. The region's club represented in the second highest level sports event, i.e. the English basketball league division. It was promoted from 2nd division to first when it became champions in a 2015-2016 season. The team usually play under the supervision of coach Matt Guymon and mostly play its game at Fleming Park Leisure centre.

 

Eastleigh Ladies Hockey Club

Situated in South Hampshire, Eastleigh Ladies Hockey Club fields two teams in Hampshire Women’s League along with playing floodlit and indoor league games.

 

Eastleigh Rugby Football Club

“The Hub” is the source through which the Eastleigh Rugby Football Club plays. Presently, there are four senior sides, colts and young player improvement.

 

Eastleigh Running Club

Eastleigh has a broadly based running club for those who are interested in running.

 

Politics

MP Mims Davies represents the House of Commands in Eastleigh. In general election of 2015, she was designated for the constituency with a majority vote of 9,147. She won against the Mike Thornton of Liberal Democrats who was elected at the elections of 2013 with the majority of 1,771 votes. Prior to 2005, the Eastleigh constituency MP was David Chidgey and later on, this seat was won by Huhne.

 

Transport:

Rail

Eastleigh has a famous railway station named as Eastleigh railway station. It is the foremost railway station that is located on the South Western Main Line. It provides fast and regular services to Winchester to Southampton, Poole and Bournemouth. It is connecting station for other two routes namely Eastleigh-Romsey Line and Eastleigh-Fareham.

 

Air

Eastleigh has 20th largest airport in England namely Southampton Airport. It is served by a dedicated machine railway station that is nest station stop from Eastleigh railway station.

 

Bus

The bus services are provided by Bluestar, Briijan Tours, Stagecoach, First Group Hampshire, Xelabus and Wilts and Dorset.

 

Road

The M3 and M27 motorway are also giving access to travellers owing to its location near to the junction point of Eastleigh town.