Oracle Database: Administration Workshop II

• • Recognize the Oracle Database architecture with ASM, and the configuration and management DBA Tools
  • Identify how to configure backup and recovery functionality in Oracle Database 11g Release 2
  • Recognize the  benefits and  uses of an RMAN recovery catalog and identify the steps for creating and configuring one
  • Identify how to prepare a database for backup and then for perform and monitor various types of RMAN backups
  • Recognize the causes of file loss and how to recover files
  • Recognize the steps for manually backing up, recovering and restoring a database
  • Identify ways to monitor and tune RMAN to reduce bottlenecks and balance backup and recovery operations

هیچ پیش نیاز ضروری برای این دوره ی آموزشی وجود ندارد

• مدیران و کارشناسان داده
• برنامه نویسان
• معماران و توسعه دهندگان بانک اطلاعاتی
• مدیران فناوری اطلاعات
• راهبران بانک اطلاعاتی

Core Concepts and tools of the Oracle DATABASE

Configuring for Recoverability

Using the RMAN Recovery catalog

Creating Backups with RMAN

Configuring Backup Setting

Managing The Database Instance
• The Database Management Tools
• EM Database Express
• EM Cloud Control
• SQL Developer
• Database Administration Duties
Database Architecture Review
• Database Instance Configurations
• Memory Structures
• Process Structures
• Storage Architecture
Starting & Stopping Database Services
• Start & Stop The Database Listener
• About Database Startup/Shutdown
• SYSOPER
• SYSDBA
• Database State & Stages
• Startup With EM Cloud Control
• Startup With SQL*PLUS
• Shutdown With EM Cloud Control
• Shutdown With SQL*PLUS
• Using MS Windows Services
Oracle Network Environment
• Oracle NET Services Architecture
• Oracle NET Configuration Assistant
• Oracle NET Manager
• Using EM Cloud Control
• Advanced Network Compression
• Troubleshooting Network Problems
Diagnostics & Oracle Support
• About Database Diagnostics
• Fault Diagnosability Infrastructure
• Database Instance Health Snapshot
• The Support Workbench
• Proactive Database Health Checks
• Package Diagnostic Data
• Working With The Knowledge Base
Storage: Tablespace Management
• Starter Tablespaces
• Create Tablespace With EM CC
• Create Tablespace With SQL
• Manage Tablespaces With EM CC
• Manage Tablespaces With EM DE
• Manage Tablespaces With SQL
• DROP Tablespace
• ALTER Tablespace
Storage: Advanced Tablespace Management
• Managing Temporary Tablespaces
• Temp Tablespace Groups With EM
• Temp Tablespace Groups With SQL
• Default Permanent Tablespaces
• Bigfile Tablespaces
• Managing The SYSAUX Tablespace
Storage: Data Files & Temp Files Management
• Manage Data Files With EM
• Access Metadata With SQL
• Manage Data Files With SQL
• Manage Temp Files
• Oracle-Managed Files (OMF)
Storage: Undo Data & Undo Tablespaces
• About Undo Space Management
• Configure Undo Management
• Guarantee Undo Retention
• Monitor Undo Space With SQL
• Use The EM Undo Advisor
Security & Schemas: Security Overview & Database Privileges
• Database Security Principles
• Database System Privileges
• Database Object Privileges
• Super Administrator Roles
• Privilege Analysis
Security & Schemas: User Security
• Create & Manage User Accounts
• Manage Users With EM
• Manage Users With SQL
• CREATE User
• ALTER User
• DROP User
• Grant & Revoke Privileges
• Resource Limits Via Profiles
• ALTER Profile
• DROP Profile
• Password Management Via Profiles
• Role-Based Security Management
• Alter User…Default Role
• Set Role
• Delegating Privilege Authorization
• With Admin Option & System Privileges
• With Grant Option & Object Privileges
• Principle Of Least Privilege Checklist
Security & Schemas: Database Auditing
• Auditing Database Activity
• Traditional Auditing
• Unified Auditing
• Create Audit Policy
Security & Schemas: SQL Loader
• Loader Concepts
• Loader From The Command Line
• Control File Options
• Load Methods
• Loader Express Mode
• Loader From EM
Security & Schemas: Export & Import
• Manage Directory Objects
• The Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Dictionary Views
• Using The EM Cc Interface
Performance & Availability: Managing Performance & SQL Tuning
• Management Advisory Framework
• Performance Monitoring & AWR
• The SQL Tuning Advisor
• Monitoring Exceptions With Metrics
Performance & Availability: Data Concurrency
• About System & User Locks
• Monitor & Manage User Locks
• Monitor Locks With Data Dictionary
• Manage Locks With EM
Performance & Availability: Backup & Recovery Concepts
• Backup & Recovery Structures
• Managing Redo Data
• Configuring For Recoverability
• Instance Recovery
• Recoverability Checklist

به شرکت کنندگان در این دوره ی آموزشی گواهی حضور از سوی شرکت IT HOUSE اعطا خواهد شد.

تماس بگیرید

ندارد.