Oracle DBA 12c | 19c Certification Training

✔ List the major architectural components of Oracle DBA

✔ Explain the memory structures

✔ Describe the background processes

✔ Understanding 12c multitenant architecture

✔ Exploring CDB and PDB databases

✔ Describe database administrator (DBA) role, explain typical tasks and tools
✔ Plan an Oracle software installation
✔ Install 12c Database software

✔ Plan database creation
✔ Create Multitenant Container and Pluggable Databases
✔ Create Oracle DBA using SQL Plus
✔ Understand database users & sample schemas

✔ Managing database using Oracle Enterprise Manager & SQL*Plus
✔ Commonly used Initialization Parameters
✔ Manage database initialization parameters – SP file & P file
✔ Describe the stages of database startup
✔ Start and stop the Oracle database and components
✔ Viewing Alert log & manage Trace files
✔ Understand Data Dictionary Views
✔ Access dynamic performance views

✔ Storage Structures
✔ Segments, Extents & Oracle block
✔ Describe the storage of table row data in blocks
✔ Create and manage Tablespaces
✔ Tablespaces and Datafiles
✔ Managing Tablespaces in CDBs and PDBs
✔ Oracle Managed Files (OMF)
✔ Managing Temporary Tablespace

✔ Create and manage database user accounts:

✔ Authenticate users
✔ Assign default storage areas (tablespaces)

✔ Grant and revoke privileges
✔ Create and manage roles
✔ Create and manage profiles

✔ Describe locking mechanism and how Oracle manages data concurrency
✔ Monitor and resolve locking conflicts

✔ Explain DML and undo data generation
✔ Monitor and administer undo data
✔ Difference between undo data and redo data
✔ Configure undo retention
✔ Guarantee undo retention
✔ Use the Undo Advisor

✔ Oracle Net Services
✔ Configure Listener & Create Oracle Net Service aliases
✔ Configure connect-time failover
✔ Control the Oracle Net Listener
✔ Use tnsping to test Oracle Net connectivity
✔ Identify when to use shared servers and when to use dedicated servers
✔ Configuring Communication between Databases
✔ Connecting to another Database using DB Links

✔ Identify the types of failure that can occur in an Oracle database
✔ Importance of checkpoints, redolog files, control files & archive log files
✔ Understanding what is COLD & HOT backup
✔ Configure ARCHIVELOG mode & Fast Recovery Area
✔ Invoke and configure Recovery Manager (RMAN)
✔ Specify Retention policy

✔ Usage of a Recovery Catalog over control file for the RMAN repository
✔ Create and configure a recovery catalog
✔ Register Database & Synchronize with recovery catalog
✔ Use RMAN stored scripts
✔ Enable control file autobackup
✔ Configure backup destinations
✔ Allocate channels for Disk & Tape destinations
✔ Configure backup optimization
✔ Create compressed & encrypted backups

✔ Create consistent database backups (offline/cold)
✔ Back up your database without shutting down (online/hot)
✔ Create image file backups
✔ Create a whole database backup
✔ Create a full database backup
✔ Enable fast incremental backup
✔ Create duplex backup sets
✔ Back up a backup set
✔ Create RMAN multi-section backup
✔ Create an archival backup for long-term retention
✔ Monitor Backup jobs, Manage backups and view backup reports
✔ Monitor the fast recovery area

✔ Determine the need for performing recovery
✔ Describe the causes of file loss and determine the appropriate action
✔ Describe major recovery operations

✔ Perform recovery:

✔ Control file
✔ Redo log file
✔ Data file

✔ Perform complete recovery when a critical or non-critical data file is lost
✔ Recover using incrementally updated backups
✔ Switch to image copies for fast recovery
✔ Recover using a backup control file

✔ Describe ways to move data
✔ Create and use directory objects
✔ Use SQL*Loader to load data from a non-Oracle database (or user files)
✔ Use external tables to move data via platform-independent files
✔ Explain the general architecture of Oracle Data Pump
✔ Use Data Pump Export and Import to move data between Oracle databases

✔ Describe Flashback technology
✔ Perform Flashback Query
✔ Use Flashback Version Query
✔ Perform Flashback Table operations
✔ Use Flashback Transaction Query

✔ Describe and use Oracle Total Recall

✔ Creating and Managing Flashback Data Archive (FDA)

✔ Describe and use flashback recycle bins
✔ Configure Flashback Database
✔ Perform Flashback Database operations
✔ Monitor Flashback Database

✔ Describe DBA responsibilities for security and auditing
✔ Enable standard database auditing
✔ Specify audit options
✔ Review audit information
✔ Maintain the audit trail

✔ Optimizer overview
✔ Manage optimizer statistics
✔ Manage the Automatic Workload Repository (AWR)
✔ Use the Automatic Database Diagnostic Monitor (ADDM)
✔ Describe and use the advisory framework
✔ Accessing & analyzing Active Session History data

✔ Use performance-related dynamic view & EM to monitor performance

✔ Managing Memory:

✔ Describe the memory components in the SGA
✔ Implement Automatic Memory Management
✔ Manually configure SGA parameters
✔ Configure automatic PGA memory management

✔ Maintaining different types of Indexes
✔ Managing Partition Tables

✔ SQL Tuning
✔ Row chaining & migration
✔ SQL trace, Tkprof, Explain plan
✔ Use the SQL Tuning Advisor to:

✔ Identify SQL statements that are using the most resources
✔ Tune SQL statements that are using the most resources

✔ Use the SQL Access Advisor to tune a workload

✔ Detect and repair database corruption
✔ Handle block corruption
✔ Set up Automatic Diagnostic Repository (ADR) & Run health checks

✔ Describe how the Oracle database server automatically manages space
✔ Save space by using compression
✔ Proactively monitor and manage tablespace space usage
✔ Describe segment creation in the Oracle database
✔ Control deferred segment creation
✔ Use the Segment Advisor
✔ Reclaim wasted space from tables and indexes by using segment shrink
✔ Manage resumable space allocation

✔ Use transportable tablespaces
✔ Describe the concepts of transportable databases

✔ Describe the benefits of using ASM
✔ Manage the ASM instance
✔ Create and drop ASM disk groups
✔ Extend ASM disk groups
✔ Retrieve ASM metadata by using various utilities

✔ List the purposes of creating a duplicate database
✔ Choose a technique for duplicating a database
✔ Duplicate a database with RMAN

✔ Dataguard Architecture & background processes
✔ Configuring & Managing Dataguard
✔ Configuring Dataguard failover
✔ Managing switchover

✔ Multitenant Container Database and Pluggable Databases
✔ Managing Tablespaces and Users in CDB and PDBs
✔ Backup, Recovery, and Flashback CDBs and PDBs
✔ Automatic Data Optimization and Storage Enhancements
✔ In-Database Archiving and Temporal
✔ Privilege Analysis new feature and new administrative privileges
✔ ADR and Network enhancements
✔ Oracle Data Redaction
✔ High Availability using RMAN
✔ Tables, Indexes, and Online Operations enhancements
✔ Major enhancements in Data Pump, SQL Loader & External tables