جمعه 15 آذر 1398

مشخصات دوره

  • عنوان دوره : Oracle Workshop II
  • مدت زمان دوره : 60 ساعت
  • زبان دوره : فارسی و انگلیسی

هدف:
این دوره شامل آشنایی با مفاهیم پیشرفته Oracle شامل Architecture ، Database Startup and Shutdown، Creating Tables, Indexes, and Constraints، Advanced Memory Management ، Data Loading ، Backup and Archive log Mode ، Recovery می باشد .

مخاطبین:
کارشناسان و مدیران فنی حوزه نرم افزار و Database

نحوه اجرا:
این دوره هم به صورت آنلاین و هم به صورت حضوری توسط مدرسین دارای مدرک بین المللی برگزار می گردد.

  • Core Concepts and Tools of the Oracle Database
    • The Oracle Database Architecture: Overview
    • Connecting to the Database and the ASM Instance
    • DBA Tools Overview
  • Manage the ASM Instance
    • ASM Storage Concepts
    • Set up initialization parameter files for ASM instance
    • Start up and shut down ASM instances
    • Administer ASM disk groups
    • Configuring for Recoverability
    • Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
    • Using the Recovery Manager (RMAN)
  • Configuring your Database for B&R Operations
    • Configuring Archivelog Mode , Configuring Backup Retention
    • Configuring and Using a Flash Recovery Area (FRA)
  • Configuring Backup Settings
    • Configuring and Managing Persistent Settings for RMAN
    • Configuring Autobackup of Control File
    • Backup optimization
    • Advanced Configuration Settings: Compressing Backups
    • Configuring Backup and Restore for Very Large Files (Multisection)
  • Creating Backups with RMAN
    • RMAN backup types
    • Creating and Using the following:
    • Backup Sets and Image Copies
    • Whole Database Backup , Fast Incremental Backup
    • Configure Backup Destinations
    • Duplexed Backup Sets
    • Archival Backups
  • Restore and Recovery Task
    • Restoring and Recovering
    • Causes of File Loss , Automatic Tempfile Recovery
    • Recovering from the Loss of a Redo Log Group
    • Recovering from a Lost Index Tablespace
    • Re-creating a Password Authentication File
    • Complete and Incomplete Recovery
    • Other Recovery Operations
  • Using RMAN to Perform Recovery
    • Complete Recovery after Loss of a Critical or Noncritical Data File
    • Recovering Image Copies and Switching Files
    • Restore and Recovery of a Database in NOARCHIVELOG Mode
    • Incomplete Recovery
    • Performing Recovery with a Backup Control File
    • Restoring from Autobackup: Server Parameter File and Control File
    • Restoring and Recovering the Database on a New Host
  • Monitoring and Tuning RMAN
    • Monitoring RMAN Jobs
    • Balance Between Speed of Backup Versus Speed of Recovery
    • RMAN Multiplexing , Synchronous and Asynchronous I/O
    • Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and
    • BACKUP DURATION
  • Managing Memory
    • Oracle Memory Structures
    • Oracle Database Memory Parameters
    • Using Automatic Memory Management
    • Automatic Shared Memory Management
    • Using Memory Advisors , Using Data Dictionary Views
  • Automating Tasks with the Scheduler
    • Simplifying Management Tasks
    • Creating a Job, Program, and Schedule
    • Using Time-Based, Event-Based, and Complex Schedules
    • Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups , Multi-Destination Jobs