oracle
core dba online training
Ø ORACLE CORE DBA
This oracle dba training course is designed to provide oracle
professionals with an in-depth understanding of the dba features of oracle,
specific oracle concepts and knowledge required for the ocp exam, and tips and
techniques for passing the oracle ocp exam on your first attempt.
Ø
Course Contents
Ø
Introduction.
§
Types of Databases.
§
Duties of a DBA,
Classifications of DBA.
§
Oracle Versioning and
versions history.
§
Grid ? Advantages of Grid
Computing.
§
What is Instance? What is
Database? What is Database Server?
§
Users the DBA interacts
with.
§
Supported OS.
§
Introduction to Linux OS.
§ Linux File Layout structure.
Ø
Installation of Linux OS.
§
OS Users.
§
Installation process.
§
Disk layout.
§
Different mount points used
by oracle.
§
Swap Area.
§
Creation of User groups.
§ Oracle needed file layout.
Ø
Installation of Oracle Software
§
Fulfilling prerequisites
for installation.
§
Setting up environment.
§
Installation.
§
Post Installation scripts.
§
Changes done to the OS
files after installation is complete.
§
/etc directory,
/home/oracle directory, global inventory, oracle home.
Ø
Database Creation
§
Database files
introduction.
§
Table spaces and Schemas.
§
Control files introduction.
§
PFile Introduction,
Creation and default parameters(10g/11g).
§
Instance States.
§
Database Creation Manually
and Using DBCA.
Ø
Background processes and Different stages of Database.
§
Instance Start, Mount and
Open states.
§
Dynamic views related to
database.
§
Oracle memory layout.
§
Background processes.
§
Instance states more
detailed.
§ How to look for background processes.
Ø Database objects and Tablespaces.
§
Introducing putty and VNC
server(How it works in realtime environment).
§
Sys owned objects.
§
Data Dictionary.
§
User Created objects.
§
Sys Tablespaces.
§
User Tablespaces.
§
Dictionary Managed
Tablespace, Locally managed tablespace.
§
Bigfile tablespace.
§
Managing tablespaces.
§
Managing datafiles.
§
Datafiles layout, Internal
organization.
§
Tables and Fragmentation.
Ø
Threads and Redo log groups
§
Archive log, No Archive
log.
§
Threads and Groups
concepts.
§
Multiplexing Redo logs.
§
Log switching.
§
Different stages of Log
files.
§
Processes related to online
Redo logs.
§
Adding Threads, Groups.
§
Dropping Threads, Groups.
Ø
Oracle Memory architectureDifferent components of memory(10g/11g).
§
Dedicated Server and Shared
Server.
§
SGA and PGA, Differences
between them.
§
Different Stages of a
query.
§
Parsing: Hard parsing and
Soft parsing.
§
Different stages during an
update statement.
§ Checkpointing
§
Indexes
§
Different types of Indexes.
§
B-Trees.
§
Creation.
§
Views related to indexes.
§
Index reorganization.
§
Statistics collection on
indexes.
Ø
Networking and Remote ConnectionsTNS.
§
Listeners.
§
Listener.ora file.
§
Tnsnames.ora file.
Ø
Views and Materialized views
§
Types of views.
§
Creation.
§
Database links.
§
Materialized views.
§
Refreshing materialized
views.
§
Processes related to
materialized views.
§
Problems with materialized
views refresh.
Ø
Users, Privileges, Roles and Responsibilities
§
Security and
Passwords(10g/11g).
§
User Creation.
§
Creating Roles.
§
Assigning Privileges, Roles
and Responsibilities.
§
Dropping users.
§
Revoking privileges.
§
Password file. Remote sys
connect.
Ø
Pfile and spfile
§
Types of parameters(static
and dynamic).
§
Managing spfile.
§
Creating pfile from spfile
and vice versa.
§
Changing parameters
dynamically.
Ø
Control files
§
Multiplexing.
§
Details stored in
controlfiles.
§
Creating, Backing up and
Recreating controlfiles.
§
Scenarios when a
controlfile needs to be created.
§
Changing the Instance name
and Database name.
Ø
Backups
§
Types of Failures.
§
Types of backups.
§
Logical Backups using
ImpDP, ExpDP(Data Pump).
§
Transportable tablespaces.
§
Physical backups.
§
Cold Backups and Hot
Backups.
§
Generation of redo during
hot backups. Fuzzy blocks.
Ø
Recovery.
§
Complete recovery using
cold backups.
§
Complete recovery using hot
backups.
§
Partial recovery using cold
backups.
§
Partial recovery using hot
backups.
§
Different scenarios in
performing recoveries.
§
UNNAMED datafiles during
recovery.
Ø
Cloning Databases
§
Cold cloning.
§
Hot cloning.
Ø
RMAN(1)
§
RMAN tool introduction.
§
Catalog mode No-Catalog
mode.
§
Configurations of RMAN.
§
Hot backups using RMAN.
§
Backing up Databases,
Archivelogs and Controlfiles.
§
Channels and Multiple
copies.
§
Tuning RMAN backups
process.
§
Retention policies.
§
Incremental backups,
Cumulative backups.
Ø
RMAN(2).
§
Restoration using RMAN.
§
Recovery using RMAN.
§
Cloning databases using
RMAN.
§
Migrating databases using
RMAN.
§
Restoration from
Incremental Backups and Cumulative Backups.
Ø
Automatic Storage Management(ASM).
§
Striping and Mirroring.
§
RAID concepts.
§
ASM concepts and file
systems.
§
Background processes used
by ASM.
§
CSS daemon.
§
Creating Disk groups and
Redundancy.
§
RMAN backups in ASM.
§
Migrating a NON-ASM
database to ASM.
§
Rebalancing.
§
ASMCMD command-line tool.
§
md_backup and md_restore.
Ø
Patching and Upgrades.
§
Patches and Patch sets.
§
Upgrading within releases.
Ø
Database Migrations between releases.
§
Migration from 10g to 11g.
Ø
Data Guard.
§
Standby databases.
§
Physical Standby databases
and Logical Standby databases.
§
Different modes of
Protection and Availability.
§
Creating Standby databases.
§
Managing Databases in a
Data Guard Environment.
§
Switchover and Failover.
§
Data Guard Broker.
Ø
Performance Tuning.
§
Categories of tuning.
§
Areas of tuning.
§
SQL Tuning.
§
Memory Tuning.
§
Disk I/O tuning.
§
Tools used for tuning.
§
Waits and Contention.
§
Latches and Spins.
§
Locks and Lock Resolution.
§
AWR reports, ADDM reports.
§
Oracle Database Replay.
Ø
Oracle Enterprise Manager and Grid Control.
§
Maintaining everything for
OEM.
§
RMAN from OEM.
§
Data Guard from OEM.
§
AWR Reports and ADDM.
§
Tuning from OEM.
If you require
any further information please do not hesitate to contact us
please feel
free to mail us for demo session or call @ 9989754807
contact: trainings@keentechnologies.com
website url: http://www.keentechnologies.com
No comments:
Post a Comment