|
Oracle 11g DBA Course Contents
a) LINUX Administration (OEL 4 and RHEL 4 & OEL 5 and RHEL 5)
b) Oracle 11g SQL and PL/SQL
c) OPERATING SYSTEM INSTALLATIONS
Redhat Enterprise Linux (RHEL 4) and OEL 4 Installations
Redhat Enterprise Linux (RHEL 4) and OEL 4 Installations (Text Mode)
Redhat Enterprise Linux (RHEL 5) and OEL 5 Installations (Text Mode)
d) ORACLE INSTALLATIONS
Oracle Manual Installations on RHEL 4 and OEL 4
Oracle Basic Installations on RHEL 4 and OEL 4
Oracle Advanced Installations on RHEL 4 and OEL 4
Oracle Installations on RHEL 4 and OEL 4 by using Database Configuration Assistant (DBCA)
d) Oracle Database 11g Architecture.
Oracle Logical Storage Structures
Oracle Logical Database Structures.
Oracle Physical Storage Structures.
Multiplexing database files.
Oracle Memory Structures
e) Controlling the Database
Creating and Configuring a listener.ora and tnsnames.ora file
For Manual Installations as well as advanced and DBCA installations.
Starting and Stopping ISQL* Plus
Starting and Stopping Database Control
Changing the Listener Status
Startup and Shutdown
Starting Up a Database NOMOUNT
Starting Up a Database MOUNT
Starting Up a Database OPEN
Shutting down the database.
SHUTDOWN OPTIONS
g) TableSpace Management
Tablespaces and Data Files
Space Management in Tablespaces
Creating a New Tablespace
Storage for Locally Managed Tablespaces
Altering a Tablespace
Actions with Tablespaces
Dropping Tablespaces
Viewing Tablespace Information.
h) Control files management
Multiplexing Control files
How to recreate a controlfiles from the trace file.
I) Redologfile Management
How to multiplex redo log files.
Creating Redo log groups
How to drop redo log groups
j) Archivelog files management
How to configure flash_recovery_area for manual installations.
How to configure flash_recovery_area and flash_recovery_area size for basic, advanced and dbca installations.
k) Administering Users
Database User Accounts
Creating a User
Profiles and Users
Authenticating Users
Default and Temporary Tablespaces
Checklist for Creating Users
Privileges
System Privileges
Object Privileges
Assigning Quota to Users
Assigning Roles to Users
Roles
Benefits of Roles
Predefined Roles
Secure Roles
How to assign quota to the user.
l) Oracle Net Services
Creating and configure a listener in client server environment
Starting the Listener Server Process
Stopping a listener process
Oracle Networking and Database Connectivity
Establishing Oracle Connectivity
Linux Server to Linux Server Communication (DBA)
Windows to Linux Server Communication (DBA) using putty
Windows to Linux Server Communication by using tnsnames.ora file (DBA)
Windows to Linux Server Communication by using Oracle 11g Client Software
(Developer, Tester etc)
Windows to Windows Server Communication using Remote Desktop (DBA)
Windows to Windows Server communication using tnsnames.ora file (DBA)
Windows Client to Windows Server Communication using Oracle 11g Client Software (Developer, Tester etc)
m) Flashback Technologies
Flashback Drop (Uses Recycle bin feature)
Flashback Table (Uses undo data)
Flashback Version Query (Uses undo data)
Flashback Transaction Query (Uses undo data)
Flashback Database (Uses flashback log/flash recovery area)
n) Logical Backups
Logical backups using exp/imp
Full Logical Backups, User Level Backups and Table level backups
Logical backups using data pump technologies.
Logical Incremental backups
o) Physical Backups
Cold backups or offline backups or closed backups
Hot backups or Online Backups or Open Backups
Physical Backups using RMAN
How to configure RMAN in a client Server Technology on two or more machines.
p) Backup and Recovery Concepts using RMAN
Backup and Recovery Issues
Categories of Failures
Statement Failures
User Process Failure
Network Failure
User Errors
Instance Failure
Instance Recovery
Phases of Instance Recovery
Media Failure
Control Files
Redo Log Files
Multiplexing the Redo Log
Archived Log Files
ARCHIVELOG Mode
q) Database Backups Using RMAN
Recovery Manager (RMAN)
Configuring Backup Settings
Scheduling Backups: Strategy
Scheduling Backups: Options
Scheduling Backups: Settings
Scheduling Backups: Schedule
Backup Control File to Trace
Manage Backups
Flash Recovery Area
r) Database Recovery (Using RMAN)
Opening a Database
Changing Instance Status
Keeping a Database Open
Loss of a Control File
Loss of a Redo Log File
Loss of a Data File in NOARCHIVELOG Mode
Loss of a Noncritical Data File in ARCHIVELOG Mode
Loss of a System-Critical File in ARCHIVELOG Mode
s) Database Cloning
Online Cloning for the Production Servers
Offline Cloning for the Non-Production Servers.
t) Data Guard (Disaster and Recovery)
Data Guard Complete Implementation on Two Servers
Primary and Standby database servers
Failover mechanism
u) Upgradation from Oracle 10g to 11g
Manual Upgradation
Upgradation using DBCA
v) Patch Management
How to apply CPU (critical patch updates) to the Database.
How to file SR (Service Requests) using
https://metalink.oracle.com
How to download and apply oracle patches.
w) Database Tuning
Both Text based as well as OEM based
Monitoring the Database Aspects
Tuning the Database Areas
Monitoring using the ADDM (Automatic Database Diagnostic Monitor)
Running ADDM using OEM
Running ADDM using Command prompt
Using the UTLBSTAT.SQL and UTLESTAT.SQL files
Implementing the OEM-Tuning Pack
Using SQL Tuning Advisor
Running SQL Access Advisor
Managing AWR (Automatic Workload Repository)
Accessing AWR through OEM
Managing AWR using DBMS_WORKLOAD_REPOSITORY package
Using OEM to View AWR Report
x) Automatic Storage Management (ASM)
How to maintain RDBMS instance
How to maintain ASM instance
Advantages of ASM compare with OS file System
y) Database Refreshes
z) Database Server Troubleshooting.
Listener Issues
Client Server issues
Data Guard Issues
RMAN issues
Performance and Tuning Troubleshooting Issues
Upgrade issues
Patch Management issues
Installation and Configuration issues
Online and Offline Cloning issues
Logical Backup and Physical backup issues
Flashback issues
Control file issues
Redolog file issues
Archive log file issues
Visit: www.hyddbatraining.com
Phone: +91 9966293445 / +91 8142368899 / 040-30629114
Contact Us
DBA School
# 501, Mahindra Residency,
Near Aditya Trade Center,
Ameerpet,
Hyderabad
|
