the best oracle dba (10g & 11g) dba training@dba school hyderabad
Post on 14-Oct-2014
155 Views
Preview:
DESCRIPTION
TRANSCRIPT
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
Oracle 11g DBA Course Contents
a) LINUX Administration
b) Oracle SQL and PL/SQL
c) OPERATING SYSTEM INSTALLATIONS
Oracle Enterprise Linux 4 (OEL 4) Installations (Both Automatic and Manual using Graphic mode)Oracle Enterprise Linux 4 (OEL 4) Installations (Both Automatic and Manual using Text mode)
Oracle Enterprise Linux 5 (OEL 5) Installations (Both Automatic and Manual using Graphic mode)Oracle Enterprise Linux 5 (OEL 5) Installations (Both Automatic and Manual using Text mode)
d) ORACLE INSTALLATIONS
Oracle Manual database Installations on OEL 4 Oracle Basic Database Installations on OEL 4Oracle Advanced Database Installations on OEL 4Oracle Database Installations on OEL 4 by using Database Configuration Assistant (DBCA)
d) Oracle Database 11g Architecture.
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
Oracle Logical Storage StructuresOracle Logical Database Structures.Oracle Physical Storage Structures.Oracle Instance ArchitectureShared and Dedicated Server processesOracle Memory StructuresDatabase Buffer CacheRedolog Buffer CacheShared PoolLarge PoolJava PoolStreams PoolBackground Processes
e) Controlling the Database
Creating and Configuring a listener.ora and tnsnames.ora fileFor Manual Installations as well as advanced and DBCA installations.Starting and Stopping ISQL* PlusStarting and Stopping Database ControlChanging the Listener StatusStartup and ShutdownStarting Up a Database NOMOUNTStarting Up a Database MOUNTStarting Up a Database OPENShutting down the database.SHUTDOWN OPTIONS like Shutdown Normal, Shutdown Transactional, Shutdown Immediate and Shutdown Abort
g) TableSpace Management
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
Tablespaces and Data FilesSpace Management in TablespacesCreating a New TablespaceStorage for Locally Managed TablespacesAltering a TablespaceActions with TablespacesDropping TablespacesViewing Tablespace InformationHow to find the database sizeHow to find used database sizeHow to find free database sizeHow to find the table size
h) Control files managementMultiplexing Control filesHow to recreate a controlfiles from the trace file.How to take backup of a controlfileHow to restore a controlfile
I) Redologfile ManagementHow to multiplex redo log files.Creating Redo log groupsHow to drop redo log groups Adding Redolog Members to a Redolog GroupDropping a Redolog Member from a Group
j) Archivelog files management
How to configure flash_recovery_area for manual database installations.How to configure flash_recovery_area size for manual database installationsHow to configure flash_recovery_area and flash_recovery_area size for basic, advanced and dbca installations.How to enable ArchivelogmodeHow to change database mode from noarchivelog mode to Archivelogmode
k) Security
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
Users and Resource ControlCreating New UsersModifying User Settings with the ALTER USER StatementRemoving Users
Introduction to ProfilesCreating ProfilesManaging PasswordsControlling Resource UsageDropping a Profile
Changing User, Profile, Password, and Resource DataSystem and Object Privileges
Identifying System PrivilegesUsing Object Privileges
Managing System and Object PrivilegesGranting and Revoking System PrivilegesGranting and Revoking Object Privileges
Database RolesHow to Use RolesUsing Predefined Roles
Creating and Modifying RolesCreating and Assigning Privileges to a RoleAssigning Roles to Users and to Other RolesLimiting Availability and Removing Roles
Roles in the Enterprise Manager ConsoleQuotas
Assigning Quota to UserAltering Quota to a UserAssigning Unlimited Quota to a UserRemoving Entire Quota from a User
Assigning Permanent and Temporary Tablespaces to a User
l) Oracle Net Services
Creating and configure a listener in client server environmentStarting the Listener Server ProcessStopping a listener processOracle Networking and Database ConnectivityEstablishing Oracle Connectivity
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
Listener Control UtilityMonitoring with Listener ControlLocal Naming Testing Oracle Net ConnectivityLinux Server to Linux Server Communication (DBA)Windows to Linux Server Communication (DBA) using puttyWindows 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/impFull Logical Backups, User Level Backups and Table level backupsLogical backups
The Data Pump Export/Import ProcessUsing Data Pump Export and Import
Creating a DirectoryData Pump Export OptionsStarting a Data Pump Export job
Data Pump Import OptionsStarting a Data Pump Import JobComparing Data Pump Export/Import to Export/Import
Logical Incremental backups using exp and impLogical Incremental backups using data pump technologies i.e expdp and impdp
o) Physical Backups
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
Cold backups or offline backups or Closed backupsHow to take cold backups for non-production environments like DEV, TST and STAGINGHot backups or Online Backups or Open BackupsHow to take Hot Backups for Production environments.
p) RMAN Backups and Recovery (Physical Backups)
RMAN Features and ComponentsRMAN vs. Traditional Backup MethodsBackup TypesRMAN commands and OptionsConfiguring the RMAN EnvironmentSetting up a RepositoryRegistering a DatabaseControlfile Autobackup
Backup OperationsFull Database BackupsTablespaceDatafilesControl File, SPFILE BackupArchived Redo LogsIncrementally Updated BackupsBackup CompressionValidating Backups
Using the Recovery CatalogMaking Backups with RMANMaintaining RMAN Backups and the RepositoryScripting RMANRestoring a Control FileRestoring a TablespaceRestoring a DatafileRestoring an Entire DatabaseValidating Restore Operations
Restore PreviewRestore ValidatePoint in Time Recovery
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
REPORT and LISTPerforming Complete RecoveryPerforming Incomplete RecoveryPerforming Flashback RecoveryHandling Online Redo Log FailuresTuning RMANTroubleshooting RMANPerforming Backup and Recovery with Enterprise Manager (OEM)
s) Database Cloning
Online Cloning for the Production Servers
Offline Cloning for the Non-Production Servers.
t) Data Guard (Disaster and Recovery)
Introduction to Oracle Data Guard
Data Guard Architecture
Complete Implementation of Data Guard between Primary and Standby Servers
Preparing the Primary Database
Implementing Standby databases
Standby Database Administration
Log Management Services
Switchover and Failover
Data Guard Troubleshooting
u) Upgrading to Oracle Database 11g
Manual Upgradation
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
Upgradation using DBCA
V) Patch Management
What is a Patch?
How to apply CPU (critical patch updates) to the Database.
How to file SR (Service Requests) using
https://support.oracle.com
How to download Oracle patches from the Oracle Customer Connection
i.e httS://support.oracle.com
How to Apply Patches to the Database
w) Database Tuning
Both Text based as well as OEM basedMonitoring the Database AspectsTuning the Database AreasMonitoring using the ADDM (Automatic Database Diagnostic Monitor)Running ADDM using OEMRunning ADDM using Command promptUsing the UTLBSTAT.SQL and UTLESTAT.SQL filesImplementing the OEM-Tuning PackUsing SQL Tuning AdvisorRunning SQL Access AdvisorManaging AWR (Automatic Workload Repository)Accessing AWR through OEMManaging AWR using DBMS_WORKLOAD_REPOSITORY packageUsing OEM to View AWR Report
x) Automatic Storage Management (ASM)
Introduction to Automatic Storage Management (ASM)
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
How to implement RDBMS instance
How to implement ASM instance
How to maintain ASM Disks
Diskgroups and Failure Groups
ASM Command-Line
Managing Databases in ASM
ASM Operations
Typical ASM Diskgroup Commands
Troubleshooting ASM
y) Database Refreshes
z) Managing Large Databases
Bigfile Tablespace Basics
Creating and Modifying Bigfile Tablespaces
Bigfile Tablespace ROWID Format
DBMS-ROWID and Bigfile Tablespaces
Using DBVERIFY with Bigfile Tablespaces
Advanced Oracle Table Types
Index Organized Tables
Global Temporary Tables
External Tables
Partitioned Tables
z) Database Server Troubleshooting.
DBA SCHOOL, #501,502 Mahindra Residency, Near Aditya Trade Center, Ameerpet, Hyderabad
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
Faculty: Satya Seelam
(10 Years DBA Exp in USA)
Visit: www.hyddbatraining.com
Phone: +91 9966293445 / +91 8142368899 / 040-30629114
Contact Us
DBA School (Software Training Institute)
Flat #501 & 502, Mahindra Residency,
Near Aditya Trade Center,
Ameerpet,
Hyderabad
top related