O
Database Administrators (DBAs) are responsible for the design, 6. Storage Structures and architecture of Oracle 11g DBA
implementation, support and maintenance of computerized databases Logical structure Vs Physical structure
in today’s organizations. The role also includes architecting, building and Defining the tablespaces and data files
scaling databases for future data growth and capacity. They are also Create/Manage tablespaces
responsible for security, performance and availability of data to users Obtain tablespace information
and customers. Managing Undo Data
Learn To: 7. File Management.
Control File Management
Create and manage users. Redo Log File Management
Install and configure an Oracle Database. Parameter File Management
Create and manage storage structures. Obtain tablespace information
Administer the Oracle Database.
Understand the Oracle database architecture and how its 8. User Management.
components work and interact with one another. Create and manage database user accounts
Perform backup and recovery. Roles / Privileges
Control resource usage by using Profiles
Prerequisite
SQL & linux (free)
Oracle Administration II (OCP)
Oracle DBA Training Course Content
9. Oracle Net Services.
Understand Oracle Net concepts
Use Oracle Net Manager to create and configure listeners
OCP + Real time + interview prep Use the listener control utility to control the Oracle Net Listener
Testing Oracle Net connectivity
Shared Server: Connection pooling
Oracle Administration I (OCA)
10. Oracle Backup & Recovery (User Managed).
Introduction Introduction
Different types of oracle products and features. Design, Testing, Implementation Strategies
Offline(cold)/Online(hot) backups
New features in oracle 11g
Performing Complete Recovery
Differences among oracle9i, oracle 10g, oracle 11g and oracle 12C Performing Incomplete Recovery
features along with its importance.
`11. Oracle Backup & Recovery (System Managed: RMAN).
2. Installing oracle database 11g software. Introduction
System requirements. RMAN Architecture
Redhat Linux 5.8 Installation (with and without Vmware Configuration
Setting up Catalog
workstation)
Online/Offline Backup using RMAN
Installation of multiple oracle servers and multiple oracle databases
Backups Options
on Vmware workstation Incremental Backups
Complete Recovery
3. Creation of an oracle database. Incomplete Recovery
Oracle Database 11g Architecture Table Space Point in Time Recovery (TSPITR)
Oracle instance architecture Disaster Recovery
Oracle Read Consistency and Concurrency
12. Cloning.
4. Controlling the database RMAN / Manual
Start and stop the enterprise manager database console
Start and stop the listener 13. Logical Backup & Transporting data between databases.
Introduction Data pump (expdp, impdp) Utilities
Startup and shutdown the database Exporting/Importing Tables/schema/tablespace/database
Transportable Table space within & across the database and
5. Database Creation. platforms
Manual
Database Configuration Assistant(DBCA) 14. Proactive Maintenance & PT
Optimizer statistics
O
Automatic Workload Repository,ASH,ADDM,TKPROE different types of patch
SQL Tune & manage Index steps to apply patch
partition/cluster table
19. Data Guard
15. Flashback what is data guard
Introduction Different types of dg
Configuration fail over
Flashback Query/Table/Drop/Database broker configuration
Flashback Version Query
Creating Restore Points 20. Oracle 12C
Integration
16. Up-gradation and migration Architecture
up gradation type: manual/dbua New features
upgrade database from 10g/11g to 12c CDB-PDB
Migration database between os
21. Daily job's of a DBA
17. SQL*LODER
introduction
22. Monitoring & Troubleshoot of your oracle
CSV to ORACLE table
append mode
database
other format
i. ORA-00060, ORA-00600,ORA-1555,ORA-03113,
18. Patch on Oracle Manage memory & hard disk space
oracle patching tool
why/when patch
23. concept of OEM 12c with BMC ticketing tool
