Advanced Administration

• Flash recovery area
• Oracle flashback database
• Guarantee Restore point
• Plug-able database management
• LAB - Configure FRA
• LAB - Create restore points
• LAB - Flash back database to restore point
• LAB - Create plug-able database using DBCA
• LAB - Start, stop, connect to plug-able and container database
• LAB - Drop pluggable Database

ASM Concepts

ASM Administration

• LAB - Create and delete Automatic Storage Management (ASM) disk groups
• LAB - Set the attributes of an existing ASM disk group
• LAB - Perform ongoing maintenance tasks on ASM disk groups
• LAB - Monitor ASM using the V$ASM dynamic performance views
• LAB - Migrate Non ASM to ASM Database

Enterprise Manager Cloud control Concept

EM Administration

• LAB - Install oracle RDBMS
• LAB - Install repository
• LAB - Install Cloud control
• LAB - Integrate existing database with cloud control
• LAB - Start/Stop Cloud control

Transparent Data Encryption Concept

Database Vault Concept

• LAB - Configure TDE on table level
• LAB - Configure TDE on column level
• LAB - Enable database vault
• LAB - Disable database vault
• LAB - Access Database Vault through EM

Data guard Configuration

• Data guard Concepts
• Data guard Administration
• Data guard Benefits
• LAB -Configure Data guard
• LAB - Configure data guard broker and use fast-start fail over
• LAB - Create and manage a physical / logical and snapshot standby
• LAB - Active Data Guard
• LAB - Real time apply
• LAB - Switch over / Fail over

RMAN

• RMAN Concepts
• Archive log Concepts
• Retention policy
• Backup types
• Restoration
• LAB - RMAN Concepts
• LAB – Archive log Concepts
• LAB - Retention policy
• LAB - Backup types
• LAB - Restoration
• LAB - RMAN Hot Backup
• LAB - Recovery
• LAB - Incremental & Cumulative backups
• LAB - Backup retention policies
• LAB - Restoration & Recovery scenarios

Real Application Cluster

• Oracle Grid Infrastructure Concepts
• Oracle Clusterware Architecture
• Oracle Clusterware Software and Storage
• Describe ASM Architecture
• LAB - Implement Pre-requisites for RAC Installation
• LAB - Configure storage RAC Installation
• LAB - Install Grid Infrastructure
• LAB - Install Oracle RDBMS
• LAB - Database creation
• LAB - RAC Testing
• LAB - RAC Troubleshooting

Performance & Tuning

• A review of the Oracle architecture
• Overview of SQL tuning
• Oracle RAM usage and bottlenecks
• Oracle CPU usage and bottlenecks
• Oracle disk I/O overview
• Overview of AWR/ADDM Reports
• LAB - Memory tuning
• LAB - Trace sql statements
• LAB - Generate explain plan
• LAB - Monitor CPU/IO/Memory
• LAB - Generate AWR/ADDM Reports
• Oracle Indexing
• Oracle parsing
• Optimizer modes
• Oracle Partitioning
• LAB - Creating indexes
• LAB - Rebuild indexes
• LAB - Gather statistics
• LAB - Create table partitions

Goldengate Configuration

• Technology Overview
• Oracle Golden gate architecture
• LAB - Install Golden gate
• LAB - Configure Golden gate
• LAB - Configure Golden gate replication
• LAB - Monitor Replication
• LAB - Start/Stop Replication