Oracle 11g Troubleshooting and Maintenance for Support Administrators (OR224)培训课程
培训大纲：
1. Basic Oracle Architecture
Architecture Overview
Database Structures
Process Structures
Memory Structures: SGA and PGA
2. Starting and Stopping the Database
Connecting as a Privileged User
Password File Authentication
Starting a Database
Shutting Down a Database
Reading the Alert Log / Trace Files
Quiescing the Database
SPFILE / Parameter Management
3. Logical Components
Basic Definitions
Blocks / Extents / Segments / Tablespaces
Fragmentation / Deallocation
Managing Undo Segments
Automatic Undo Management
Managing Sort Activity
Managing Data Segments
Managing Index Segments
Monitoring Database Segments
Tablespace Overview
System Tablespace
Types of Tablespaces
Creating Additional Tablespaces
Altering Tablespaces
4. Oracle Database Files
Basic Structures of an Oracle RDBMS
Data Files
Redo Log Files / Archived Redo Logs
Control Files
Oracle-Managed Files (OMF)
5. Users and Security
Managing Database Users
System / Object Privileges
Managing Roles / Profiles
Resource and Password Management
6. Physical NOARCHIVELOG Mode Backups
Oracle Database Backups
Automatic Recovery Architecture
NOARCHIVELOG / ARCHIVELOG Physical Backups
Closed Backups
7. Configuring Archivelog Mode
Physical ARCHIVELOG Mode Backups
Establishing Multiple Archiving Destinations
Open Backups in ARCHIVELOG Mode
Controlfile Backup
8. Complete Recovery
Recovery Structures and Processes
Recovery in NOARCHIVELOG and ARCHIVELOG Mode
9. Incomplete Recovery
What Incomplete Recovery Is
Recovering from Loss of Current Redo Log Files
10. Recovery Manager Configuration
Parameters Affecting RMAN
Use of a Flashback Recovery Area
CONFIGURE Command
Persistent Settings
NOCATALOG / CATALOG Mode
Channel Allocation
Controlfile Autobackup
Retention Policies
11. Recovery Manager Operations
Using the BACKUP command
Compressed Backups
Whole Database Copying
Incremental Backups
Block Change Tracking
RMAN Backup Monitoring
REPORT and LIST commands
12. Non-Critical Loss Recovery
Password and Network Files
Read-Only Tablespaces
Temporary Tablespaces
Index Tablespaces
Redo Log Members / Control Files
13. Database Recovery
Recovering the Control File
Reasons for Incomplete Recovery
Recovery after RESETLOGS
Incomplete Recovery using EM
Incomplete Recovery using RMAN
Incomplete Recovery using SQL
14. Flashback Database
When to Use
Configuration and Use
Monitoring Flashback Database
Using EM for Flashback Database
Flash Recovery Area Maintenance
Flash Recovery Area Monitoring
15. User Error Recovery
The New Recycle Bin
Flashback a Dropped Table
Querying Dropped Tables
Flashback Versions Query
Flashback Transaction Query
16. Block Corruption Management
DBVERIFY and ANALYZE
DBMS_REPAIR
Block Media Recovery
DBMS_BLOCK_CHECKING
Using RMAN for Block Corruption
17. Diagnostic Sources
Alert Logs and Trace Files
Enterprise Manager and Alerts
Controlling Trace File Size
Alert Notification
18. Performance Tuning
Application Identification
Enterprise Manager Tools
SQL Tuning Advisor
SQL Access Advisor
DBMS_SQLTUNE
DBMS_ADVISIOR
Quick Tune
如果您想学习本课程，请
预约报名
如果没找到合适的课程或有特殊培训需求，请
订制培训
除培训外，同时提供相关技术咨询与技术支持服务，有需求请发需求表到邮箱soft@info-soft.cn,或致电4007991916
技术服务需求表点击在线申请
服务特点：
海量专家资源，精准匹配相关行业，相关项目专家，针对实际需求，顾问式咨询，互动式授课，案例教学，小班授课，实际项目演示，快捷高效，省时省力省钱。
专家力量：
中国科学院软件研究所，计算研究所高级研究人员
oracle,微软，vmware，MSC,Ansys，candence,Altium,达索等大型公司高级工程师，项目经理，技术支持专家
中科信软培训中心，资深专家或讲师
大多名牌大学，硕士以上学历，相关技术专业，理论素养丰富
多年实际项目经历，大型项目实战案例，热情，乐于技术分享
针对客户实际需求，案例教学，互动式沟通，学有所获
