Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

Mehmet Salih Deveci

5 years ago

I will share with you Step by Step Oracle Tutorial | Oracle Database Tutorials for Beginners in this post.

Oracle Tutorial | Oracle Database Tutorials for Beginners

If you don’t know Oracle database and want to learn, you are at the right adress.

You can learn Oracle database step by step with following steps. I have started Oracle database Tutorials from beginning, so read each article in order.

Before Oracle Database Tutorial, Oracle DBA ( Database Administrator ) needs useful scripts to monitor, analyze and check Oracle database for routine database operations and monitoring, If you don’t have Oracle DBA Scripts, you can read following Article.

Useful Oracle RAC (Cluster Command) Scripts | Oracle DBA Scripts All in One -1

Oracle Database Tutorials

Lesson 1- What is the Data, Information and Database ?

What is the Data & Information and Data Volumes

What is the Database and Relational Database Management System (RDBMS)

What is the Database, Why Database ?

Most Popular Database Management Systems in the World

Oracle DBA Tutorials

Lesson 2- Oracle History, Release and Editions & Oracle Database Architecture

Read 3 Articles related with Oracle database architecture to learn architecture of Oracle database.

Oracle Database Version History & Oracle Release Versions

https://ittutorial.org/oracle-database-editions-oracle-features/

Oracle Database Architecture -3 SMON, PMON, DBWR,CKPT and LGWR Processes

Oracle Database Architecture -2 Buffer Cache, Redolog Buffer, Onlinelog and Archivelog

Oracle Database Architecture -1 Controlfile, Datafile, SGA and PGA

Lesson 3- Oracle Database Installation Step by Step

You can find Oracle 11g, Oracle 12c , Oracle 18c and Oracle 19c Software and Database installation with following links.

Oracle 19c

Oracle Database 19c on Linux 7.6 Step by Step Installation -2

Oracle 18c

Oracle Database 18c Step by Step Installation on Linux 7.6 and RHEL -2

Oracle 12c

Oracle Database 12c Silent Installation

Oracle 11g

Oracle 11g Software and Database Installation-2

Lesson 4– Create ASM Disk & Oracle Automatic Storage Management ( ASM ) Installation Step by Step

You can learn what is the ASM ( Automatic Storage Management ) and Filesystem with following links.

Oracle Automatic Storage Management 18c Step by Step Installation -2

Oracle Automatic Storage Management ( ASM ) -2 Add Disk and Drop Disk Operations in Oracle ASM

How to Create and Configure Oracle ASM Disk on Linux Using OracleASM ASMLib Utility and oracleasm module not loaded or /dev/oracleasm not mounted solution

What is the Oracle ASM Cluster Filesystem (ACFS) and How to Create ACFS

How to Change Hostname of a Standalone Oracle Restart ( ASM )

Lesson 5– Oracle Database Startup and Shutdown Step

Learn how to startup and shutdown Oracle database and what is going on during these operation.

Oracle Database Startup and Shutdown Steps

Lesson 6– Oracle Database Parameter Files

Learn What are the parameter files of Oracle database and what are the differences.

Oracle Database 12c Parameter Files ( Spfile & Pfile )

Alter System Set Command | Oracle Database Parameters Change

Lesson 7– Oracle Database Archivelog Mode

Learn Oracle database Archivelog and noarchivelog mode.

Oracle Database Enable Archivelog Mode and Archivelog Deletion and Generation Frequency

Lesson 8– Oracle Data Pump Export Import

Learn how to export and import database, schemas, tables in Oracle database.

Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-4

Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-3

Lesson 9– Oracle Database Backup with RMAN ( Recovery Manager )

Learn how to backup database, tablespace, datafiles, controlfiles in Oracle database.

List Backup and RMAN Backup Reports | Oracle RMAN ( Recovery Manager ) Backup Tutorials -8

Backup Performance via Block Change Tracking | Oracle RMAN ( Recovery Manager ) Backup Tutorials -7

Full Backup Database in Oracle via RMAN | Oracle RMAN ( Recovery Manager ) Backup Tutorials -6

Incremental and Cumulative Backup via RMAN | Oracle RMAN ( Recovery Manager ) Backup Tutorials -5

Backup Tablespace, Datafile, Archivelog, Controlfile via RMAN | Oracle RMAN ( Recovery Manager ) Backup Tutorials -4

Lesson 10– Oracle Database Restore and Recover with RMAN ( Recovery Manager )

Learn how to restore and recover database, tablespace, datafiles, controlfiles in Oracle database.

Restore Tablespace, Archivelog and Datafile via RMAN | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -5

Restore Database & Recover Database with Set Until Time via RMAN | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -4

Restore Database and Recover database via RMAN | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -3

How to Restore Oracle Database ( Controlfile, Datafile, Archivelog ) via RMAN from Tape Backup

Lesson 11– Oracle Dataguard – Disaster Recovery

What is the Disaster recovery and dataguard and How to install Oracle Dataguard ?

Oracle Dataguard ( Standby ) Architecture -3

Oracle Dataguard ( Standby ) Architecture -2

Oracle DataGuard Step by Step Installation with RMAN Duplicate Method -2

Snapshot Standby ( Read Write ) in Oracle Dataguard

Active Dataguard in Oracle

Lesson 12– Oracle Flashback Technology

Oracle Flashback Database

Flashback Table in Oracle Database

Restore Any Lost Datafile with Flashback Database Technology -2

Flashback Data Archive in Oracle Database

Do you want to learn Advanced Oracle Database Tutorial detailed, then read the following articles.

Oracle Tutorial | Advanced Oracle Database Tutorials for Senior Oracle DBA