Получить консультацию
Training Center MUKКурсыOracleDatabaseOracle Database 11g: Administration Workshop II Release 2

Oracle Database 11g: Administration Workshop II Release 2

Код курса
DBA11g-AW II
Продолжительность
5 Дней, 40 Ак. Часов
Описание курса
Цели
Требования
Программа курса
Описание курса

Course overview

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

  • Diagnose and repair data failures with Flashback technology.
  • Manage space to optimize database storage so you can respond to growing space requirements.
  • Monitor and manage major database components, including memory, performance and resources.
  • Secure the availability of your database through appropriate backup and recovery strategies.
  • Automate DBA tasks with the Scheduler.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Цели

Course Objectives

  • Configure the Oracle Database for optimal recovery
  • Configure the database instance such that resources are appropriately allocated among sessions and tasks
  • Schedule jobs to run inside or outside of the database
  • Use compression to optimize database storage and duplicate a database
  • Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
  • Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
  • Use an appropriate and flexible memory configuration for your database
  • Identify burdensome database sessions and poorly performing SQL
Требования

Suggested Prerequisite

  • Working knowledge of SQL and how to use PL/SQL packages

Required Prerequisite

  • Oracle Database 11g: Administration Workshop I Ed 2
  • Oracle Database 11g Database Administration

Audience

  • Administrator
  • Database Administrator
  • Implementer
Программа курса

Course Topics

  • Oracle Database 11g Release 2: Database Architecture and Recovery Operations
  • Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups
  • Oracle Database 11g Release 2: Performing Restore and Recovery Tasks
  • Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN
  • Oracle Database 11g Release 2: Database Diagnostics and Flashback Technologies
  • Oracle Database 11g Release 2: Managing Database Memory and Performance
  • Oracle Database 11g Release 2: Managing Database Resources and the Scheduler
  • Oracle Database 11g Release 2: Managing Database Space and Duplication
Регистрация на ближайший курс
Oracle Database 11g: Administration Workshop II Release 2
Код курса:
DBA11g-AW II
Продолжительность:
5 Дней, 40 Ак. Часов
Зарегистрироваться
Получить консультацию
Свяжитесь со мной
Получить консультацию
Отправить заявку
Регистрация на вебинар
Отправить заявку
Ваша заявка получена!
Мы свяжемся с вами в ближайшее время.