ORACLE 12C DBA

• Create and manage database user accounts:
• Grant and revoke privileges
• Create and manage roles & profiles

• Start and stop the Oracle database instance and components
• Modify database initialization parameters
• Describe the stages of database startup & shutdown options
• Access dynamic performance views & view alert log

• Describe the storage of table row data in blocks
• Create and manage tablespaces & obtain information

• List the major architectural components of Oracle Database
• Explain memory structures and background processes
• Correlate logical and physical storage structure     
• ​Describe pluggable databases

• Describe the locking mechanism and how Oracle manages concurrency
• Monitor and resolve locking conflicts

• Explain DML and undo data generation
• Monitor and administer undo data
• Describe the difference between undo data and redo data
• Configure undo retention & Guarantee undo retention
• Enable temporary undo, Use the Undo Advisor

• Create Listeners, Net Service aliases
• Use the Listener Control Utility to manage Oracle Net Listener
• Use tnsping to test Oracle Net connectivity
• Identify when to use shared servers and when to use dedicated servers

• Describe DBA responsibilities for security and auditing
• Enable and create unified auditing policies
• Maintain the audit trail

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

• Describe database architecture as it relates to backup and recovery
• Describe NOARCHIVELOG mode & tools for backup and recovery
• Perform basic backup and recovery

• Configure and manage RMAN settings, Configure FRA
• Configure the control files & redo log files for recoverability
• Configure ARCHIVELOG mode and the archived redo log files for recoverability

• Describe the use of the RMAN recovery catalog, Create Catalog
• Register a database in the RMAN recovery catalog

• Describe Oracle backup solutions, RMAN backup types
• Describe, compare, and determine your backup strategy
• Schedule backups accordingly, perform whole backups

• Perform full and incremental backups
• Use Oracle-suggested backup strategy, Report and manage backups
• Begin refining your basic backups:

           - Configure Block Change tracking, Perform incremental level backups

           - Recover an incremental level 0 backup with level 1 incremental

• Compress backups, Use media manager
• Create multi-section backups of very large files
• Create proxy copies, duplexed backup sets, archival backups
• Back up other files:

         - Back up a control file to trace

         - Back up archived redo log files, ASM metadata

         - Catalog additional backup files

• Describe and create RMAN-encrypted backups
• Use Transparent-mode, Password-mode & Dual-mode encryption

• Detect and repair database corruption
• Use the Automatic Diagnostic Repository (ADR)
• Analyze instance recovery with ADRCI
• Use the Data Recovery Advisor

• Understand how to employ the best Oracle Database recovery technology for your failure situation
• Describe instance or crash recovery
• Describe complete and point-in-time recovery
• Describe recovery through RESETLOGS

• Perform the appropriate type of restore and recovery
• Recover from media failures in data files
• Perform complete and incomplete or “point-in-time” recoveries

• Recover from the loss of the server parameter file
• Recover from control file and redo log file failures
• Re-create the password authentication file
• Recover index and read-only tablespaces
• Review the automatic recovery of the tempfile
• Describe the basic procedure of restoring the database to a new host

• Distinguish and describe point-in-time recovery (PITR) of table, tablespace, and database
• List what operations occur when you perform a point-in-time recovery
• Determine the correct target time for the point-in-time recovery
• Perform automated TSPITR, Perform table recovery from backups

• 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

• Describe Flashback Database architecture
• Configure your database to support Flashback Database

• Transport tablespaces between databases by using image copies or backup sets
• Transport databases by using data files or backup sets

• List the purposes and create duplicate database with RMAN
• Duplicate a database based on a running instance

• Manage the Automatic Workload Repository (AWR)
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe and use the advisory framework
• Set alert thresholds, Use server-generated alerts

• Enterprise Manager to monitor performance
• Automatic Memory Management (AMM)
• The Memory Advisor to size memory buffers

• Manage optimizer statistics
• 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

• Configure the Database Resource Manager
• Access and create resource plans, Create consumer groups
• Map consumer groups to plans, Activate a resource plan
• Monitor the Resource Manager
• Automating Tasks by Using Oracle Scheduler

• Describe how the Oracle Database server automatically manages space
• Save space by using compression
• Control deferred segment creation & Use the Segment Advisor
• Reclaim wasted space using the segment shrink
• Manage resumable space allocation

• 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

• 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

• Connections to CDB / PDB, Start up and shut down a CDB
• Open and close PDBs
• Change the different modes and settings of PDBs
• Evaluate the impact of parameter value changes

• Permanent & temporary tablespaces in CDB and PDBs
• Common and local users, roles and privileges

• Perform CDB and PDB backups
• Recover CDB and PDB from essential file loss
• Perform flashback database

• Describe activity tracking with Heat Map
• Describe Automatic Data Optimization
• Use views and procedures to monitor ADO
• Move a data file online, Move a partition online

• Describe the new RMAN enhancements
• Perform cross-platform data transport
• Use Table Recovery