Breaking News:
Nov 27
Training IT - Oracle DBA 10g Admin 2 PDF Print E-mail
Written by Administrator   

Lanjutan dari training oracle DBA 10g admin 1, Sudah terbukti secara teknis,bahwa sistem database yang paling handal adalah Oracle. Peserta pelatihan wajib mempelajari sistem database ini untuk menjadi programmer yang handal.

Daftar Materi Pelatihan

Minggu I

1. Configuring recovery manager : Objectives, Backup and Recovery: Review, Features of Recovery Manager, Recovery Manager Components, Steps for Configuring RMAN, RMAN Repository Data Storage: Comparison of Options, Backup Destinations, Media Management, Using a Flash Recovery Area with RMAN, Monitoring the Flash Recovery Area with EM, Flash Recovery Area Space Usage, V$FLASH_RECOVERY_AREA_USAGE, Backing Up the Flash Recovery Area, Benefits of Using a Flash Recovery Area, Setting Parameters That Affect RMAN, RMAN Usage Considerations, Connection Types with RMAN, Starting RMAN, Additional RMAN Command-Line Arguments, Configuring Persistent Settings for RMAN, Configuring RMAN Settings by Using EM, Control File Autobackups, Retention Policies, Managing Persistent Settings, Channel Allocation, Automatic and Manual Channel Allocation, Channel Control Options, Summary, Practice Overview: Configuring RMAN

2. Using recovery manager : Objectives, Issuing Recovery Manager Commands, Types of RMAN Commands, Job Commands: Example, RMAN Commands: Overview, BACKUPCommand, Backup Constraints Parallelization of Backup Sets, Compressed Backups, Image Copy, Tags for Backups and Image Copies, BACKUPCommand Options, Backing Up Archived Redo Logs, Whole Database Backup, RMAN Backup Types, Differential Versus Cumulative, Block Change Tracking, Enabling Block Change Tracking, Incrementally Updating Backups, LISTCommand, REPORTCommand, REPORT NEED BACKUPCommand, REPORT NEED BACKUP: Examples, REPORT OBSOLETEand DELETE OBSOLETE, Managing Backups with EM, RMAN Dynamic Views, Monitoring RMAN Backups, Summary, Practice Overview: Backing Up Your Database

3. Recovering from non critical losses : Objectives, Causes of File Loss, Critical Versus Noncritical, Losing a TEMPFILE, Recovering from a TEMPFILELoss, Log Group Status: Review, Losing a Redo Log Group Member Re-creating Redo Log Files, Re-creating Indexes, Authentication Methods for Database Administrators, Re-creating a Password Authentication File, Summary, Practice Overview: Recovering from Lost TEMPFILEand Redo Log File

4. Database recoveryObjectives, Recovery Methods, User-Managed Recovery: RECOVERCommand, RMAN Recovery: RESTOREand RECOVERCommands, Recovery Using Enterprise Manager, Complete Versus Incomplete Recovery, Complete Recovery Process, Incomplete Recovery Process, Situations Requiring Incomplete Recovery, Types of Incomplete Recovery, Performing User-Managed Incomplete Recovery, User-Managed Time-Based Recovery: Example, User-Managed Cancel-Based Recovery: Example, Performing Incomplete Recovery by Using RMAN, Time-Based Recovery Using RMAN: Example, Log Sequence Recovery Using RMAN: Example, Incomplete Recovery Using Enterprise Manager, Incomplete Recovery and the Alert Log, Restore Points, Incomplete Recovery: Best Practices, Recovering a Control File Autobackup, Creating a New ControlFile, Recovering Read-Only Tablespaces, Read-Only Tablespace Recovery Issues, Summary, Practice Overview: Performing Incomplete Recovery

Minggu II :

1. Flashback ; Objectives, Flashback Technology: Review, Flashback Drop and the Recycle Bin, Recycle Bin, Restoring Tables from the Recycle Bin, Recycle Bin: Automatic Space Reclamation, Recycle Bin: Manual Space Reclamation, Bypassing the Recycle Bin, Querying the Recycle Bin, Querying Data from Dropped Tables, Flashback Database: Review, Flashback Database Architecture, Configuring Flashback Database, Configuring Flashback Database Using EM, Flashback Database: Examples, Performing Flashback Database Using EM, Flashback Database Considerations, Monitoring Flashback Database, Monitoring Flashback Database with EM, Guaranteed Restore Points, Summary, Practice Overview: Performing Flashback Database

2. Dealing with database corruption ; Objectives, What Is Block Corruption?, Block Corruption Symptoms: ORA-01578, How to Handle Corruption, Corruption-Related Features, DBVERIFY Utility, Interpreting DBVERIFY Output, ANALYZECommand, Verifying Block Integrityin Real Time: DB_BLOCK_CHECKING, Verifying Block Integrityin Real Time: DB_BLOCK_CHECKSUM, Using EXPto Detect Corruption, Using Flashback for Logical Corruption, DBMS_REPAIRPackage, Using DBMS_REPAIR, Block Media Recovery (BMR), BLOCKRECOVERCommand, Examples of Using BLOCKRECOVER, The RMAN BMR Interface, Alternative Actions to Take, Summary, Practice Overview: Perform Block Media Recovery

3. Monitoring and managing memori ; Objectives, Memory Management: Overview, Oracle Memory Structures, Buffer Cache, Using Multiple Buffer Pools, Shared Pool, Large Pool, Java Pool, Redo Log Buffer, Automatic Shared Memory Management: Overview, Benefits of Automatic Shared Memory Management, How ASMM Works, Configuring ASMM byUsing Database Control, Manually Configuring ASMM, Behavior of Autotuned SGA Parameters, Behavior of Manually Tuned SGA Parameters, Using the V$PARAMETERView, Modifying the SGA_TARGETParameter, Disabling ASMM, Manually Resizing Dynamic SGA Parameters, Program Global Area (PGA), Automatic PGA Memory Management, PGA Management Resources, Using the Memory Advisor to Size the SGA, Using the Memory Advisor to Size the PGA, Efficient Memory Usage: Guidelines, Memory Tuning Guidelines for the Library Cache, Summary, Practice Overview: Using ASMM to Correct a Memory Allocation Problem

Minggu III :

1. Automatic performance manager ; Objectives, Tuning Activities, Performance Planning, Instance Tuning, Performance Tuning Methodology, Statistics Collection, Oracle Wait Events, System Statistics, Displaying Session-Related Statistics, Displaying Service-Related Statistics, Troubleshooting and Tuning Views, Dictionary Views, Diagnosis ofHung or Extremely Slow Databases, Using Memory Access Mode, Using the Hang Analysis Page, Automatic Workload Repository, AWR Snapshot Baselines, Advisory Framework: Overview, Database Control and Advisors, Typical Advisor Tuning Session, Manually Invoking ADDM, Using the SQL Tuning Advisor: Review, SQL Access Advisor: Overview, Typical SQL Access Advisor Session, Workload Source, Recommendation Options, Reviewing Recommendations, Asynchronous COMMIT, Using Asynchronous COMMIT9, Summary, Practice Overview: Using ADDM to Diagnose Performance Problems

2. Managing schema object ; Objectives, Table Types, What Is a Partition and Why Use It?, Partitions, Creating a Partition, Partitioning Methods, Partition Maintenance, Index-Organized Tables, Index-Organized Tables and Heap Tables, Creating Index-Organized Tables, Clusters, Cluster Types, Situations Where Clusters Are Useful, Sorted Hash Cluster: Overview, Sorted Hash Cluster: Example, Sorted Hash Cluster: Basic Architecture, Schema Management Tasks, Estimating Resource Usage, Analyzing Growth Trends, Managing Optimizer Statistics, ReorganizingSchema Objects Online, ReorganizingObjects: Impact Report, ReorganizingObjects: Review, Basic Steps for Manual Online Reorganization, Summary, Practice Overview: Managing Schema Objects

3. Managing Storage ; Objectives, Space Management: Overview, Free Space Management, Types of Segments, Allocating Extents, Block SpaceManagement, Row Chaining and Migration, Proactive Tablespace Monitoring, Thresholds and Resolving Space Problems, Monitoring Tablespace Space Usage, Shrinking Segments, Results of Shrink Operation, Space Reclamation with ASSM, Segment Advisor: Overview, Segment Advisor, Implementing Recommendations, Database Control and Segment Shrink, Shrinking Segments by Using SQL, Managing Resumable Space Allocation, Using Resumable Space Allocation, Resuming Suspended Statements, TransportingTablespaces, Concept: Minimum Compatibility Level, Transportable Tablespace Procedure, Determining the Endian Format of a Platform, TransportingDatabasesDatabase TransportationProcedure: Source System Conversion, Database TransportationProcedure: Target System Conversion, Database Transportation: Considerations, Summary, Practice Overview: Managing Storage

Minggu IV :

1. Automatic storage management ; Objectives, Automatic Storage Management: Review, ASM General Architecture, ASM Instance Tasks, Creating an ASM Instance, ASM Instance Initialization Parameters, Database Instance Parameter Changes, Starting Up an ASM Instance, AccessinganASMInstance, ASM Home Page, ASM Performance Page, ASM Configuration Page, Shutting Down an ASM Instance, DBCA and Storage Options, ASM Storage: Concepts, ASM Disk Groups, Failure Group, Disk Group Mirroring, Disk Group Dynamic Rebalancing, Managing Disk Groups, ASM Administration Page, Create Disk Group Page, Creating and Dropping Disk Groups, Adding Disks to Disk Groups, Miscellaneous ALTERCommands, ASM Files, ASMCMDUtility, Migrating Your Database to ASM Storage, Summary, Practice Overview: Using Automatic Storage Management

2. Managing resource ; Objectives, Database Resource Manager: Overview, Database Resource Manager Concepts, Why Use Resource Manager, AccessingResource Plans, Example: SYSTEM_PLAN, Creating a New Resource Plan, Creating Consumer Groups, Assigning Users to Consumer Groups, Specifying Resource Plan Directives, Resource Allocation Methods for Resource Plans, Comparison of EMPHASISand RATIO, Active Session Pool Mechanism, Setting the Active Session Pool, Maximum Estimated Execution Time, Consumer Group Switching, Switching Back to the Initial Consumer Group at the End of Call, Setting Idle Timeouts, Resource Consumer Group Mapping, Activating a Resource Plan for an Instance, Database Resource Manager Information, Monitoring the Resource Manager, Summary Practice Overview: Using the Resource Manager

3. Automating task with the scheduler ; Objectives, Simplifying Management Tasks, A Simple Job, Key Components and Steps (Creating a Program,Creating and Using Schedules,Creating and Running a Job), Monitoring a Job, Using a Time-Based or Event-BasedSchedule, Creating a Time-Based Job, Creating an Event-BasedSchedule, Creating Event-Based Schedules withEnterpriseManager, Creating an Event-BasedJob, Event-BasedScheduling, Creating Complex Schedules, Creating Job Chains, Example of a Chain (Creating a Chain Object, Defining Chain Steps, Defining Chain Rules, Starting the Chain), Monitoring Job Chains, Advanced Scheduler Concepts, Creating a Job Class, Creating a Window, Prioritizing Jobs Within aWindow, Summary, Practice Overview: Automating Tasks with the Scheduler

Minggu V :

1. Database security ; Objectives, Oracle Transparent Data Encryption (TDE): Overview, TDE Process, Implementing Transparent Data Encryption, Existing Tables and TDE, TransparentData Encryption: Considerations, Wallet Support for Usernames and Passwords, Data Pump and Transparent Data Encryption, RMAN Encrypted Backups: Overview, TransparentMode Setup, Password Mode Setup, Dual Mode Setup, RMAN-Encrypted Backups: Considerations, Need for Data Privacy, Definition and Usage of Terms, Virtual Private Database: Overview, Virtual Private Database: Features, Column-Level VPD: Example, Creating a Column-Level Policy, Summary, Practice Overview: Using Oracle Database Security

2. Using globalization support : Objectives, What Every DBA Needs to Know, What Is a Character Set?, Understanding Unicode, How Are Character Sets Used?, Problems to Avoid, Another Sample Problem, Choosing Your Character Set, Database Character Sets and National Character Sets, Obtaining Character Set Information, Specifying Language-Dependent Behavior, Specifying Language-Dependent Behavior for the Session, Language- and Territory-Dependent Parameters, Specifying Language-Dependent Behavior, Linguistic Searching and Sorting, Using Linguistic Searching and Sorting, Case- and Accent-Insensitive Search and Sort, Support in SQL and Functions, Linguistic Index Support, Customizing Linguistic Searching and Sorting, Implicit Conversion Between CLOBand NCLOB, NLS Data Conversion with Oracle Utilities, NLS Data Conversion with Data Pump, Globalization Support Features, Summary, Practice Overview: Using Globalization Support Features

Trainer : Bpk. Sumadi Eko Putra, S.Kom

Praktisi Berpengalaman dan Dosen ilmu Komputer. Aktifitas utama Sebagai NOC Performance Data Support di PT. Bakrie Telekom.

Durasi Training : 30 Jam (5x pertemuan @6 jam)

Waktu Training : 1. Sabtu / Minggu (09.00 – 16.00)

Fasilitas Training :

3.Makan Siang dan Coffee break ( Untuk Kelas Sabtu dan Minggu )
4.Snack ( Untuk Kelas Malam )
5.Akses Internet

Biaya Training :  Rp. 3.400.000,-

Biaya Pendaftaran : Rp. 100.000,-


Jl. Raya Pasar Minggu No. 15D Kel. Pejaten Timur
KM 19     Jakarta Selatan

(Depan Kantor PMD – DEPDAGRI Jak-Sel)
Telp. +62-21-70734001, Fax. +62-21-7900022

Email :