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