ORACLE 12c CORE-DBA
1. Introduction
What is DBA?
Why a Company needs a DBA?
Roles & Responsibilities of DBA
Identify the oracle product
Oracle Architecture
Physical and Logical Phase of Database
2. Installing oracle database 12c software
System requirements.
Redhat Linux Installation
Install software with the Oracle Universal Installer on Linux Platform
Identify System Requirements
Optimal Flexible Architecture (OFA)
Discuss Oracle Base
Discuss Oracle Home
Prerequisite Checks and Fixup Utility
3. Container and Pluggable Database Architecture
Describe the multitenant architecture
Describe the root and pluggable database containers
Differentiate the root from a pluggable database
Explain pluggable database plugging
List impacts in various areas
Initialization Parameter Files
Starting Up Oracle Databases
Shutting Down Oracle Databases
Opening and Closing PDBs
Working with the Automatic Diagnostic Repository (ADR)
Querying Dynamic Performance Views
4. CDB and PDB Creation
Methods and Tools to Create PDBs
Creating PDBs from Seed with SQL*Plus
Cloning PDBs with SQL*Plus
Unplugging and Plugging In PDBs with SQL*Plus
Dropping PDBs with SQL*Plus
Configure and create a CDB, Create a PDB from PDB$SEED
Plug or clone a non-CDB into a CDB
Clone a local or remote PDB into a CDB
Unplug and plug a PDB from one CDB to another CDB
Explore the instance and structure of PDBs
Migrate a pre-12.1 non-CDB database to CDB
5. Managing Tablespaces and Users in CDB and PDBs
How Table Data is Stored
Creating Tablespaces in SQL*Plus
Altering and Dropping Tablespaces in SQL*Plus
Viewing Tablespace Information in SQL*Plus
Implementing Oracle Managed Files
Moving and Renaming Online Data Files in SQL*Plus
Permanent & temporary tablespaces in CDB and PDBs
6. Managing Storage Space
Oracle Database Space Management Features
Block Space Management
Row Chaining and Migration
Free Space Management Within Segments
Types of Segments
Allocating Extents
Understanding Deferred Segment Creation
Space-Saving Features
7. Managing UNDO Data
Undo Data: Overview
Transactions and Undo Data
Storing Undo Information
Comparing Undo Data and Redo Data
Managing Undo
Local Undo Mode Versus Shared Undo Mode
Configuring Undo Retention
Categories of Undo
8. Administering User Security
Creating Users
Granting Privileges
Creating and Granting Roles
Revoking Privileges and Roles
Creating and Assigning Profiles
Authenticating Users
Assigning Quotas to Users
Applying the Principal of Least Privilege
Common and local users, roles and privileges
New Administrative Privileges
New Administrative Privilege SYSBACKUP
New Administrative Privilege SYSDG
New Administrative Privilege SYSKM
OS Authentication and OS Groups
Password Authentication for SYSBACKUP
Password Authentication for SYSDG
New System Privilege PURGE DBA_RECYCLEBIN 10-19
Creating Policies Database and Role Analysis
Creating Policies Context Analysis
Analyzing and Reporting
SYSTEM and OBJECT Used Privileges
Used Privileges Results
Compare Used and Unused Privileges
9. Configuring the Oracle Network Environment
Oracle Net Services
How Listeners Work
Configuring Listeners for Dynamic Service Registration
Configuring Listeners for Static Service Registration
Configuring Local Naming for Connections
Testing Oracle Net Connectivity with tnsping
Configuring Communication Between Databases
Dedicated Versus Shared Server Configurations
10. Moving Data (DATAPUMP)
Moving Data: General Architecture
Oracle Data Pump: Overview
Oracle Data Pump: Benefits
Full Transportable Export/Import Overview
Full Transportable Export/Import Usage
Full Transportable Export/Import Example
Plugging a Non-CDB into CDB Using Data Pump
Plugging a Non-CDB into CDB Using Replication
Transporting a Database over the Network Example
Disabling Logging for Oracle Data Pump Import Overview
Disabling Logging for Oracle Data Pump Import Usage
Disabling Logging for Oracle Data Pump Import Command-Line Examples
Exporting Views as Tables Overview
Exporting Views as Tables Usage
Exporting Views as Tables Command-Line Examples
Specifying the Encryption Password
Compressing Tables during Import
11. Backup and Recovery Concepts
DBA Responsibilities
Categories of Failure
Understanding Instance Recovery
Understanding Types of Backups
Comparing Complete and Incomplete Recovery
Duplicating a Database ( Database Cloning )
Use Table Recovery
Backup and Recovery Concepts
Perform basic backup and recovery
Configure and manage RMAN settings, Configure FRA
Describe the use of the RMAN recovery catalog, Create Catalog
Register a database in the RMAN recovery catalog
Perform full and incremental backups
Configure Block Change tracking, Perform incremental level backups
Recover an incremental level 0 backup with level 1 incremental
Perform automated TSPITR, Perform table recovery from backups
Perform CDB and PDB backups
Recover CDB and PDB from essential file loss
12. ACTIVITIES (RESTORE & RECOVERY LAB)
Media Failure: CDB or PDB Temp File Recovery
Media Failure: PDB Temp File Recovery
Media Failure: Control File Loss
Media Failure: Redo Log File Loss
Media Failure: Root SYSTEM or UNDO Data File
Media Failure: Root SYSAUX Data File
Media Failure: PDB SYSTEM Data File
Media Failure: PDB Non-SYSTEM Data File
13. Using Flashback Technologies
Describe Flashback Database architecture
Understand flashback technologies from various types of errors
Configure your database to use flashback technologies
Perform flashback query, version query, transaction backout
Perform flashback table, recyclebin, flashback data archive
14. Patching Activity
Database Patch Management Introduction
Applying Interim and Patch set Patches
Patch History & Documentation
15. Monitoring and Tuning Database Performance
SQL Tuning Process
Oracle Optimizer
Optimizer Statistics
SQL Plan Directives
Adaptive Execution Plans
SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer
Managing Performance Activities
Performance Planning Considerations
Database Maintenance
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor
Performance Monitoring
Performance Tuning Methodology
Database Server Statistics and Metrics
