Oracle Certified Professional (OCP)

Exploring the Oracle Database Architecture

Exploring the Oracle Database Architecture

• List the architectural components of Oracle Database

• Explain the memory structures

• Describe the background processes


Oracle Database Instance

• Understand initialization parameter files

• Start up and shut down an Oracle database instance

• View the alert log and access dynamic performance views


Administering User Security

• Create and manage database user accounts

• Grant and revoke privileges

• Create and manage roles

• Create and manage profiles


Create and manage tablespaces

• Explain how Oracle database server automatically manages space

• Save space by using compression

• Use the Segment Advisor

• Reclaim wasted space from tables and indexes by using the segment shrink functionality


Managing Data Concurrency

• Describe the locking mechanism and how Oracle manages data concurrency

• Monitor and resolve locking conflicts


Backup and Recovery Concepts

• Identify the importance of checkpoints, redo log files, and archive log files

Performing Database Backups

• Create consistent database backups

• Back up your database without shutting it down

• Create incremental backups

• Automate database backups

• Manage backups

Moving Data

• Describe ways to move data

• Use SQL*Loader to load data from a non-Oracle database

• 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

Managing Performance: SQL Tuning

• Use the SQL Tuning advisor


Creating an Oracle Database Using DBCA

• Generate database creation scripts by using DBCA

• Manage database design templates by using DBCA

Introduction to DBAAS

• Recognize the difference between a DBaaS Instance and a Database Instance

• Navigate with My Services Dashboard

• User authentication and roles

• Generate a Secure Shell (SSH) Public/Private Key Pair

Database Backup

• Cold Backup

• Backup with RMAN

• RMAN Catalog

• Recovery Manager Various Scenarios Practical’s

• Loss of a Control File

• Loss of a Redo Log File

• Loss of a Data File in NOARCHIVELOG Mode

• Loss of a Noncritical Data File in ARCHIVELOG Mode

• Loss of a System-Critical Data File in ARCHIVELOG Mode

• Oracle Recovery Manager

• Oracle Recovery Catalog maintenance

• Backups using Oracle Recovery Manager

• Recovery using Oracle recovery manager

• Database Cloning using RMAN

• Tablespace Point in time recovery

• Incomplete recovery