Oracle Database Administration Fundamentals

Oracle Database merupakan salah satu sistem manajemen basis data (RDBMS) terpopuler yang digunakan oleh berbagai organisasi berskala kecil hingga enterprise. Dengan fitur unggulan seperti keamanan tinggi, ketersediaan data, serta skalabilitas yang baik, Oracle menjadi pilihan utama dalam mendukung aplikasi bisnis yang kritikal dan kompleks.
Peran Database Administrator (DBA) sangat penting dalam memastikan Oracle Database berjalan optimal. Tugas utama DBA mencakup instalasi, konfigurasi, pengelolaan storage, pengaturan user dan keamanan, hingga mekanisme backup dan recovery dengan RMAN. Seiring perkembangan teknologi, DBA juga dituntut untuk memahami arsitektur multitenant yang menggabungkan Container Database (CDB) dan Pluggable Database (PDB).
Training Oracle Database Administration Fundamentals dirancang untuk membekali peserta dengan pemahaman dasar administrasi database Oracle. Materi pelatihan mencakup instalasi, pembuatan database, manajemen tablespace, kontrol akses user, backup & recovery, hingga pengenalan database multitenant. Dengan bekal ini, peserta diharapkan mampu melakukan administrasi database secara mandiri dan menjadi fondasi untuk keahlian Oracle Database tingkat lanjut.

OBJECTIVES

1. Memahami konsep dasar arsitektur database Oracle dan perbedaannya dengan instance
2. Mampu melakukan instalasi Oracle Database baik secara on-premise maupun di cloud
3. Mampu membuat, mengelola, dan menghapus database menggunakan Database Configuration Assistant (DBCA)
4. Mengelola storage dengan tablespace, data files, control files, redo logs, dan archivelog
5. Mampu membuat dan mengelola user serta mengatur keamanan dengan privilege dan role
6. Memahami dan mengelola objek database seperti tables, indexes, views, dan materialized views
7. Melakukan backup, restore, dan recovery menggunakan Oracle RMAN
8. Memahami konsep multitenant architecture (CDB dan PDB) serta mengelolanya
9.  Menggunakan fitur otomasi dengan Oracle Scheduler dan troubleshooting database dasar

AUDIENCE

1. Database Administrator
2. IT Professional
3. Software Developer
4. System Administrator

PREREQUISITES

Tidak ada training khusus yang dipersyaratkan

CONTENT

1. Installing the Oracle Binaries

1.1 Understanding the OFA
1.2 Installing Oracle
1.3 Installing in the Cloud

2. Creating a Database

2.1 Using the Database Configuration Assistant
2.2 Database vs Instance
2.3 Stopping and Starting the Database
2.4 Configuring the LISTENER
2.5 Database Instance Configuration in Oracle
2.6 Dropping a Database
2.7 Creating the Database in the Cloud

3. Configuring an Efficient Environment

3.1 Customizing Your OS Command Prompt
3.2 Customizing Your SQL Prompt
3.3 Creating Shortcuts for Frequently Used Commands
3.4 Rerunning Commands Quickly
3.5 Developing Standard Scripts
3.6 Organizing Scripts
3.7 Automating Scripts

4. Tablespaces and Data Files

4.1 Understanding the First Five
4.2 Need for More Tablespaces
4.3 Container Tablespaces
4.4 Creating Tablespaces
4.5 Using Oracle Managed Files
4.6 Displaying the Tablespace Size
4.7 Altering Tablespace Size
4.8 Additional Data File Operations
4.9 Using ASM for Tablespaces

5. Managing Control Files, Online Redo Logs, and Archivelogs

5.1 Managing Control Files
5.2 Online Redo Logs
5.3 Controlling the Generation of Redo
5.4 Implementing Archivelog Mode

6. Users and Basic Security

6.1 Types of Users
6.2 Managing Default Users
6.3 Creating Users
6.4 Managing Privileges

7. Tables and Constraints

7.1 Understanding Table Types
7.2 Understanding Data Types
7.3 Creating a Table
7.4 Modifying a Table

8. Indexes

8.1 Vector Indexes
8.2 Deciding When to Create an Index
8.3 Planning for Robustness
8.4 Creating Indexes
8.5 Maintaining Indexes

9. Views, Duality Views, and Materialized Views

9.1 Implementing Views
9.2 JSON Relational Duality Views
9.3 Materialized Views

10. Data Dictionary Fundamentals

10.1 Data Dictionary Architecture
10.2 A Different View of Metadata
10.3 A Few Creative Uses of the Data Dictionary
10.4 The Dual Table
10.5 Annotations

11. Large Objects

11.1 Describing LOB
11.2 Creating a Table with a LOB Column
11.3 Maintaining LOB Columns
11.4 Loading LOBS

12. Containers and Pluggables

12.1 Paradigm Shift
12.2 Administrating the Root Container (CDB)
12.3 PDB open Modes
12.4 Creating a Pluggable Database Within a CDB
12.5 Administrating Pluggable Databases
12.6 Limiting the Amount of Space Consumed by PDB
12.7 Restricting Changes to SYSTEM at PDBl
12.8 Viewing PDB History

13. RMAN Backups and Reporting

13.1 Understanding RMANI
13.2 Staning RMAN
13.3 RMAN Architectural Decisions
13.4 Check for Corruption
13.5 Using a Recovery Catalog
13.6 Querying for Output in the Data Dictionary
13.7 RMAN Reporting

14. RMAN Restore and Recovery

14.1 Determining Whether Media Recovery is Required
14.2 Determining What to Restore
14.3 Using Data Recovery Advisor
14.4 Complete Recovery
14.5 Restoring and Recovering the Entire Database
14.6 Restoring and Recovering Data Files
14.7 Performing Block-Level Recovery
14.8 Restoring a Container Database and Its Pluggable Databases
14.9 Restoring Archivelog Files
14.10 Restoring a Control File
14.11 Using an Autobackup
14.12 Restoring the Spfile
14.13 Incomplete Recovery
14.14 Flashback
14.15 Restoring and Recovering to a Different Server

15. External Tables

15.1 SQL*Loader vs. External Tables
15.2 External Table Types
15.3 Creating External Tables
15.4 Inline SQL from External Table
15.5 Unloading and Loading Data Using an External Table
15.6 Oracle Data Pump

16. Automation and Troubleshooting

16.1 Automating Jobs with Oracle Scheduler
16.2 Examples of Automated DBA Job
16.3 Autonomous Database
16.4 Database Troubleshooting

17. Migration to Multitenant and Fleet Management

17.1 Migration to Multitenant
17.2 Fleet Management

18. Data Management

18.1 Models
18.2 JSON
18.3 Graph
18.4 Machine Learning and Al
18.5 Data Studio
18.6 DBMS_CLOUD
18.7 REST and ORDS
18.8 Data Sharing