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 Cirencester

Cirencester is the most prominent town in the Cotswold region situated 93 miles west-northwest of London. It is located on the tributary of the Thames River which is known as River Churn. It is also known as a market town in east Gloucestershire with a population of around 19000 according to 2011 census. The town is situated on the lower dip slopes of the outcrop of oolitic limestone, commonly known as Cotswold Hills. The town is divided into five major areas such as the suburbs of Chesterton, Watermoor, the town centre, Stratton and the Beeches.  

The Corinium Museum of the town is highly recognised for its important Roman collection. In 1840, the oldest agricultural college ‘Royal Agricultural University’ of the English speaking world is built in the city.  The Itzehoe town of the Germany is considered as a twin town of Cirencester. The twin town concept was introduced in 1947 after the Second World War to foster peace and reconciliation and promote trade and tourism. The early citation of the town was made by the Greco-Roman astrologer, mathematician and geographer Ptolemy in AD 150. The earlier name of the town was Corinium in the Roman times depicting its association with the ancient British tribe of the Dobunni. It has been suggested that the Dobunni has the same root word as the Churn River.

History

The early settlement of the town was formed in the early Roman area along with Colchester and St Albans. The fort was built by the Romans in AD 49 to accommodate two military allies supported to shield the provincial frontier. The fort was built at the place where the Roman road Fosse Way crossed the Churn and native Iron Age tribes ‘Dobunni’ were drawn from Bagendon and formed civil settlement near the fort. The evidence of major area roadwork was also found in the town. After the invasion of Wales, the tribe moved to the north and subsequently, the fort was closed. The public place outdoors ‘Forum’ and Christian church ‘Basilica’ were built over the site of the fort.

The town continued to grow and prospered under the Corinium Dobunnorum name. The robust wool trade and industry played a significant role towards the development of Corinium in the Roman times. The various Roman remains were found in the surrounding area including the large number of Roman villas near the villages of Withington and Chedworth. The town was also considered as the second largest city by area in the Great Britain after the wall constructed around the Roman city and covered 240 acres area.

The ancient market town in the Cotswold Hills of England known as the Roman Amphitheatre lies on the south-west of the town and still exists in the town and partially excavated. After the dissolution of the Monasteries, all the abbey buildings were demolished in 1539 and only Norman Arch and remains of the precinct wall were survived above ground. These further established the perimeter of a public park in the centre of the town. The townsmen of the Cirencester gained wealth and prosperity from the national and international wool sales, woollen broadcloth and sheep rearing businesses.

The town was severally affected by the English Civil War in the 16th century resulted in the death of 300 people and 1200 prisoners were caged in the church. The town became a robust market town and major urban centre with its convenient access to markets for production of wool and grain at the end of the 18th century. The town provides various leisure, retail and sports facilities as well as significant tourist trade for the townsfolk and the surrounding area. The important places to visit in the town are Corinium Museum, Cirencester Park, Cirencester Amphitheatre, Cerney House Gardens and much more exciting locations.