Oracle – DBA 11g, 12c & 18c
Oracle 11g/12c DBA’ course follows a step by step methodology in introducing concepts and Demo’s to the students so that they can learn with ease. … Almost in every organization, you will find Database Administrator’s (DBA’s) to maintain the organization’s database.
Instructor: Tom Steven
- Lectures: 11
- Quizzes: 3
- Students: 5
- Duration: 10 weeks
Oracle 12c is a new version of a database management system. offers Oracle 12c DBA training according to the current requirements of the IT industry. The Oracle database 12c is a relational database management system (RDBMS), also manufactured by Oracle. A feature of this new version is the inclusion of a cloud computing feature, denoted by `c`, in the name 12c. The term 12c DBA is often used for 12c database administrators. It represents the person or group of individuals responsible for creating and maintaining the Oracle 12c database. Oracle Corporation offers DBA certification programs as OCA and OCP. In this exam, every DBA tests his skills and gets certified.
Content
Instance vs. Oracle Database 11G
Components of an Oracle Database 11G Instance
Components of an Oracle Database 11G
Data files, Control files and Redo Logs
Checkpoints, Roll Forward and Rollback
Redo log concepts, Instance and Media recovery
Buffer Cache Block Management – LRU List
SGA vs. PGA
Background processes
Background processes
Unix Kernel Parameters Setup
Important configuration files – sysctl.conf, limits.conf, meminfo ,cpuinfo
Installation of Oracle Software
Installation Oracle Database 11G using DBCA
Setting up of Environment
Startup and Shutdown of the Oracle Database 11G
Startup and Shutdown of the Oracle Database 11G
Init parameters
Displaying init.ora values with v$parameter
Sizing SGA components
Shared pool concepts and components
Overview of PGA for sorting and pga_aggregate_target
Alteration of Modifiable and Non Modifiable Init parameters vs. Spfile
Explaining the use of control files
File locations for control Files
Obtaining Control File Information
Multiplexing Control File
Convert Oracle Database 11G to Archive log Mode
Archiving the Oracle Redo Logs
Archiving the Oracle Redo Logs
Managing Tablespaces – Create, alter, drop, rename, offline, online, read only, read write
Creating, Resizing, Renaming, offline Datafiles
Creating and Managing Temporary Tablespaces and Tempfiles
Creating and Managing Undo Tablespaces
Understanding Undo Retention
Free Space / Used Space in Tablespace
Troubleshooting Undo – snapshot too old
Online redo log (log_buffer)
Dictionary queries
Dictionary queries
Redo log switch
Multiplexing the Online Redo Log Files
Dictionary and v$ views
The dba_, all_ and user_ structures
Querying the tables, indexes, and segments views
Monitoring the alert log
Oracle Database trace/dump files
Oracle Database tables : Creation and Maintenance Operations
Oracle Database Indexes : Creating B*-Tree, bitmap and function-based Indexe
Oracle Database Views
Oracle Database Views
Reorganize Tables
Index rebuilding
Creating New Database Users
Managing Profiles
Identifying System and Object Privileges
Granting and Revoking Privileges
Creating and Modifying Roles
Displaying user security Information from the Data Dictionary
Displaying user security Information from the Data Dictionary
Understanding the Listener and how connection takes place from Client to Server
Use Netca
Creating the listener.ora file
Creating the tnsnames.ora file
Verifying network connectivity with ping and tnsping
Testing Oracle Database 11G connection via Listener
Testing Oracle Database 11G connection via Listener
Hot vs. Cold backups
Backup in Archivelog vs. Noarchivelog Mode
Taking Cold Backups
Taking Hot Backups
Concepts of Hot Backup
Complete and Incomplete Recovery
Restoration from cold Backup with complete data loss
Restoring and Recovering from loss of Datafiles – System and non-system ,loss of Read Only Tablespaces
Loss of Controlfiles
Loss of Redo Logs – Innotactive and notactive
Complete and Incomplete Recovery
Complete and Incomplete Recovery
Advantages of RMAN
Advantages of Catalog over Nocatalog
Catalog Creation
RMAN Closed Database and Hot Backups
RMAN Backup Management (Backup Database , tablespace , Datafile ,controlfile ,archivelogs , spfile)
Viewing Backups using List
Configure RMAN(Configure channels , autobackup , tape / disk ,retention Policies)
Reporting Bacukups
Restoring and Recovering from loss of Datafiles – System and non system ,loss of Read Only Tablespaces
Loss of Controlfiles
Loss of Redo Logs – Inactive and Active
Complete and Incomplete Recovery
Complete and Incomplete Recovery
Imp and exp utilities
Data pump (impdp and expdp
DB Verify for Corruption
Flashback Oracle Database, Flashback Drop , Flashback Query
Using opatch for Oracle Database Patching.
Using opatch for Oracle Database Patching.
Cloning using Hot Backup
Cloning Using RMAN Duplicate Database
Cloning Using RMAN Duplicate Database
Understand the Performance Problem Scope
Discuss with the affected Users
Check dynamic performance views useful in tuning
Use dynamic performance views to view statistics and wait events
Create and manage AWR snapshots
Generate AWR reports
Generate ADDM reports
Log a performance Service Request with Oracle Support
Log a performance Service Request with Oracle Support
Tuning SGA
Tuning the Shared Pool
Tuning the Buffer Cache
Checkpoint and Redo Tuning
Diagnose checkpoint and redo issues
Size the redo log file
Size the redo log buffer
Diagnose PGA memory issues
Size the PGA memory
Diagnose temporary space issues
Understanding Locks
Detect enqueue contention
Detect enqueue contention
Cost Based Optimizer
Using EXPLAIN PLAN
Using “set autotraceâ€Â
Interpreting EXPLAIN PLAN Output
Collecting Schema , table and index statistics (dbms_stats)
Checking Statistics
Tracing a Database Session
Using TKPROF to analyze a trace File
Using TKPROF to analyze a trace File