Oracle Workshop II

Oracle Workshop II
این دوره شامل آشنایی با مفاهیم پیشرفته Oracle شامل Architecture ، Database Startup and Shutdown، Creating Tables, Indexes, and Constraints، Advanced Memory Management ، Data Loading ، Backup and Archive log Mode ، Recovery می باشد .
کارشناسان و مدیران فنی حوزه نرم افزار و Data Base
Oracle Workshop I
  • The Oracle Database Architecture: Overview
  • Connecting to the Database and the ASM Instance
  • DBA Tools Overview
  • ASM Storage Concepts
  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups
  • 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 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)
  • 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
  • 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
  • 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 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
  • Oracle Memory Structures
  • Oracle Database Memory Parameters
  • Using Automatic Memory Management
  • Automatic Shared Memory Management
  • Using Memory Advisors , Using Data Dictionary Views
  • 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

نوشتن دیدگاه

نشانی ایمیل شما منتشر نخواهد شد.