学习目的
从零开始学习 Oracle 数据库，达到 OCP 实操水平。
学习计划
目标用 100 天学习 Oracle 数据库，为记录学习过程，计划连更 100 天学习笔记。
学习纲要
这块先空着，佛系学习法，学到哪算哪，回头再总结。
// TODO
学习环境
- 数据库版本
Oracle Database 19c Release (19.3.0.0.0 - 64-bit, 19.15.0.0.0 - 64-bit)
Oracle Real Application Clusters (Oracle RAC)
Oracle SQL Developer 19.2.1
Oracle Grid Infrastructure 19c Release 15 (19.15.0)
Enterprise Manager Cloud Control 13c Release 5 (13.5.0)
- 操作系统版本
Oracle Linux Release 7.9 (64-bit)
学习内容
General database and network administration
Create a pluggable database
Create tablespace
Managing undo
Manage application containers
Network configuration
Shared server configuration
Control file management
Managing Pluggable Databases
Backup/Recovery
Configure Recovery Catalog
Perform recovery and duplication
Perform backup and backup configuration
Configuring Flashback Database
Data management
Memory management
Plugging in tablespaces and creating external tables
Manage tablespaces
Managing Partitioning
Configuration that allows searching of previous versions of data
Star query optimization
Managing materialized views
Auditing
Additional configuration
Performance management
Create synonym
Configure Resource Manager
SQL statement tuning
Create appropriate schema objects
Configuring parallel execution
Instance tuning
Configuring Data Guard
Create a standby database
Configuring the standby database for testing purposes
Other Standby Database Configurations
Administration automation
Perform switchover
Configuring Real Application Clusters
Enabling Grid Infrastructure
Administering ASM disk groups
Managing Grid Infrastructure
Creating a RAC database
Additional configuration
学习资料
https://education.oracle.com/ocm-exam-registration
https://education.oracle.com/19c-ocm-exam-registration
https://education.oracle.com/en/oracle-database-12c-oracle-certified-master-ocm-exam/courP_7394
(2024-01-02, 2024 年第 2 篇原创文章, #oracle-learn)
