Oracle Certified Profession

Course Duration: 72 Hours

Course Fee: 20,000 tk

Registration

Course Overview

ORACLE ADMINISTRATION TRAINING OVERVIEW

  • Explore automatic database management, monitoring and tuning facilitiesC
  • Use Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability
  • Control resource utilization on database servers whose resource demand exceeds its capacity
  • Automate launching routine maintenance tasks and even application functions using the database Scheduler
  • Handle database corruption
  • Utilize diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data
  • Automate resumption of database operations even in the face of failures and errors
  • Set up user-managed and automatically managed backup strategies and database recovery operations
  • Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, and others
  • Explore Automatic Storage Management (ASM) of some or all database files, providing a database-centric and optimized storage subsystem and volume manager

Course Curriculum

ORACLE ADMINISTRATION

   Managing Memory
  •     About Manual Memory Management
  •     Automatic Memory Management
  •     Memory_Target
  •     Memory_Max_Target
  •     Sga_Target
  •     Sga_Max_Size
  •     Workarea_Size_Policy & Pga_Aggregate_Target
  •     Using EM & The Memory Advisors
  •     Monitor In Memory Access Mode
   Managing Storage & The Segment Adviso
  •    Monitor Tablespaces
  •    About Resumable Space Allocation
  •    Table Storage Management
  •    Pctfree Illustrated
  •    Use The Segment Advisor
  •    Cascade To Dependent Objects
  •    Optionally Call Delete_Task()
   Managing Resources
  •    Database Resource Manager Architecture
  •    Consumer Groups
  •    Resource Plans
  •    Automatic & Adaptive Consumer Group Mapping
  •    Activating Plans
  •    Monitoring Resource Allocation
  •    Explicit Consumer Group Switching
   Automating Tasks With The Scheduler (Basic)
  •    Database Resource Manager Architecture
  •    Scheduler Architecture
  •    Rac Environment
  •    Manage Programs
  •    Manage Schedules
  •    Manage Jobs
   Automating Tasks With The Scheduler (Advanced)
  •    Manage Job Classes
  •    Manage Windows & Window Groups
  •    Manage Chains
  •    About Events & The Scheduler
   Globalization
  •    Globalization Settings
  •    Nls_Lang
  •    Nls_Language & Nls_Territory
  •    Date & Time Localization
  •    Linguistic Indexes
  •    About Locale Builder
   Diagnosing Database Problems
  •    About The Fault Diagnosability Infrastructure
  •    ADR Highlights From EM
  •    Using The Alert Log
  •    About The Trace Files
  •    Database Instance Health Snapshot
  •    Using The Support Workbench
  •    Enable Oracle Configuration Manager
   Automatic Storage Management
  •    ASM & The Broader Database Architecture
  •    Creating The ASM Instance
  •    Administering The ASM Instance
  •    Sysasm Super Administrator
  •    ASM Storage Parameters
  •    Using DBCA
  •    Using ASMcmd
  •    Configuring Databases For ASM Storage
  •    DBCA
  •    DBUA
  •    ASM Migration Using EM
   Recovery Concepts
  •    About The Backup & Recovery Structures
  •    Managing Redo Data
  •    Is Log_Buffer Large Enough?
  •    What V$Log Reveals
  •    What V$Log_History Reveals
  •    What V$Logfile Reveals
  •    What V$Archived_Log Reveals
  •    Managing Archived Redo Data
  •    Archivelog Status
  •    Creating A Foundation For Sound Recovery
   Oracle Flashback Technology
  •    About Flashback Technology
  •    Flashback Query
  •    Select…As Of Timestamp
  •    Select…As Of SCN
  •    Using Dbms_Flashback()
  •    Configuring Undo Management For Flashback
  •    Undo_Retention
  •    Flashback Table
  •    Flashback Drop
  •    Flashback Versions Query
  •    Flashback Transaction Query
  •    Flashback Transaction Backout
   Flashback Database
  •    About Flashback Database
  •    Configuring The Flash Recovery Area
  •    More About Db_Recovery_File_Dest
  •    Performing Database Flashback
  •    Monitoring Flashback Performance
  •    Flashback Database Considerations
  •    Configure Flashback Data Archive
   Instance Recovery
  •    About Instance Recovery
  •    Smon Process & Instance Recovery
  •    Pmon Process & Process Recovery
  •    Instance Recovery Parallelism
  •    Changing Recovery_Parallelism
  •    Mttr Advisor & Tuning Checkpoints
  •    Log_Checkpoints_To_Alert
  •    Redo Logfile Size Advisor
  •    Fast-Start On-Demand Parallelism
   Configuring RMAN
  •    RMAN Architecture
  •    RMAN Sample Backup Session
  •    Launch & Use RMAN
  •    Configure RMAN Settings
  •    Allocate RMAN Channels
   Backup With RMAN
  •    About Backup File Types
  •    Performing Full Backups
  •    Performing Incremental Backups
  •    Establishing A Backup Retention Policy
  •    Generate Reports
  •    Report Unrecoverable
  •    Report Need Backup
  •    List Incarnation
  •    Validate Backup Data Integrity
   RMAN Management With EM
  •    Monitoring The Flash Recovery Area
  •    The EM Interface To RMAN
  •    Scheduling RMAN Backups
  •    Using The Oracle-Suggested Backup Strategy
  •    Manage Current Backups
  •    Backup Reports
  •    Manage Restore Points
   User-Managed Recovery Operations
  •    Recovery Concepts
  •    Recover Temporary Tablespaces
  •    Recover Read-Only Tablespaces
  •    Recover Index Tablespaces
  •    Recover Redo Log Group Member
  •    Recreate The Password File
   Recovery With RMAN
  •    Complete Media Recovery
  •    Incomplete Media Recovery
  •    TSPITR
  •    DBPITR
  •    Recovery Using EM
   Using The RMAN Recovery Catalog
  •    Configuring The Recovery Catalog
  •    Using A Virtual Private Catalog
   Advanced RMAN Capabilities
  •    Backup Set Encryption
  •    RMAN Duplicate Database
Share This Article If You Liked It :)