Oracle Database 11g: Administration II

Save your time wisely

Oracle Database 11g: Administration II

Category:
Oracle/
$3,273.00
Oracle logo

$3,273.00

5 in stock

5 Students
Duration: 30 days
Lectures: 10
Video: 12 hours
Oracle Certification

Oracle Database 11g: Administration II

Database Architecture and ASM

  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Administer ASM disk groups

Configuring for Recoverability 

  • Configure multiple archive log file destinations to increase availability
  • Define, apply and use a retention policy
  • Configure the Flash Recovery Area
  • Use Flash Recovery Area

Using the RMAN Recovery Catalog

  • Identify situations that require RMAN recovery catalog
  • Create and configure a recovery catalog
  • Synchronize the recovery catalog
  • Create and Use RMAN stored scripts
  • Back up the recovery catalog
  • Create and use a virtual private catalog

Configuring Backup Specifications

  • Configure backup settings
  • Allocate channels to use in backing up
  • Configure backup optimization

Using RMAN to Create Backups

  • Create image file backups
  • Create a whole database backup
  • Enable fast incremental backup
  • Create duplex backup and back up backup sets
  • Create an archival backup for long-term retention
  • Create a multisection, compressed and encrypted backup
  • Report on and maintain backups

Performing User-Managed Backup and Recovery

  • Recover from a lost TEMP file
  • Recover from a lost redo log group
  • Recover from the loss of password file
  • Perform user-managed complete database recovery
  • Perform user-managed incomplete database recovery
  • Perform user-managed and server managed backups
  • Identify the need of backup mode
  • Back up and recover a control file

Using RMAN to Perform Recovery

  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Perform incomplete recovery using RMAN
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Restore a database onto a new host
  • Recover using a backup control file
  • 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

  • Perform Flashback Table operations
  • Configure, Monitor Flashback Database and Perform Flashback Database operations
  • Set up and use a Flashback Data Archive

Diagnosing the Database

  • Set up Automatic Diagnostic Repository
  • Using Support Workbench
  • Perform Block Media Recovery

Managing Memory

  • Implement Automatic Memory Management
  • Manually configure SGA parameters
  • Configure automatic PGA memory management

Managing Database Performance

  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload
  • Understand Database Replay

Space Management

  • Manage resumable space allocation
  • Describe the concepts of transportable tablespaces and databases
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Resources

  • Understand the database resource manager
  • Create and use Database Resource Manager Components

Automating Tasks with the Scheduler

  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs
  • Create lightweight jobs
  • Use job chains to perform a series of related tasks

Administering the Scheduler

  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs

 

 

Requirements

  • Oracle Certified Associate Certification
  • Oracle Certified Associate Certification

What is the target audience?

CURRICULUM

Section 1: Introduction to Handstands

The content of this lesson is locked. To unlock it, you need to Buy this Course.
Welcome to your second lesson review.

Here we will talk about your purposes on course and goal you want to reach

Download PDF

Section 2: Reference Material, Moodboards and Mind Mapping

Wrist Strengthening

While your wrists will certain get stronger from practice and grow accustomed to the stress of the skill, a basic amount of wrist strengthening exercises for several weeks can only help things. I’d recommend working wrist curls and reverse wrist curls for around 6-10 reps for 3 sets. I also strongly recommend trying some sledgehammer levering. Work in 2-3 sets of 3-5 reps. In particular, exercises 1 and 3 are fantastic for building wrist strength and they are much harder than they look! Start with them to get the hang of sledgehammer work before you progress to the other two exercises. I don’t want somebody putting a hole through their floor or their face because they rushed things!

The content of this lesson is locked. To unlock it, you need to Buy this Course.
This test will reveal how well you are acquiring the new material based on a short test of twenty questions and a brief written assignment.

Section 3: Sketching out Ideas

  • The main objective to the sketching process is to generate super rough thumbnail sketches of what we feel best visually communicates the highlighted words from our mind maps.
  • Take as much time as you need for this step — this might be 10 minutes or it might be 10 days.
  • Personally, I like to work quickly and try not to analyze or elaborate too much.
  • Now, that doesn’t mean you should only create a handful of sketches.
  • Even though this step only took a couple of hours, I was still able to put over 100 thumbnails on paper.
  • The whole point of this process is to flush out the bad ideas and narrow down the good ones until we find that one layout that really speaks to us.
  • Also, keep in mind the project brief and have your list in front of you as a reference to avoid getting sidetracked.
  • Remember—detail is not needed. Simply flush out the bad ideas and find a great direction.
  • Once I feel I have a good direction with the sketches, I’m now ready to take a quick photo with my phone and import it into Illustrator.

This test will reveal how well you are acquiring the new material based on a short quiz of ten questions and a short writing assignment.

Section 4: Conclusions and Evaluation

This final lecture will evaluate expectations and real gained knowledge and experience. Lecturer will share some self-development sources for further independent training of course participants.
Every course participant will be given a personalised practical task for creating branding logo design for real companies.
Every course participant will have to present his final assessment task result in his chosen individual manner to the audience.

About Instructors

There are no reviews yet.

Be the first to review “Oracle Database 11g: Administration II”