Oracle 19 Database Full course - 10 Modules

Description

Course objective for Support Engineers (L1, L2 and L3)

•Gain confidence in handing database support tickets and less dependent on DBA.

•Gathering database logs, AWR reports, healthcheck and monitoring in SQL.

•Familiarization of RAC and Data guard architecture.

•Ability to diagnose the issues in RAC, Data guard and standalone database.

•Learn to troubleshoot database issues.

Course Prerequisites

None

•The Oracle architecture

•Background processes

•Physical files of databases

•Starting and stopping of database

•Overview of RMAN backups.

•Overview of Data pump backups.

•Troubleshooting issues and reading log file of database

•Adding datafiles, managing tablespace, releasing space

•How to do health check

•Oracle RAC architecture.

•Overview of ASM

•How to check logfiles and troubleshoot RAC issues

•Overview of installation of Oracle RAC.

•How to add and resize datafiles in RAC.

•How to clear space on OS in RAC environment.

•Health check of a RAC database.

•Oracle Data guard architecture.

•How to check logfiles and troubleshoot Data guard broker issues.

•How to fetch AWR report.

The whole system of ORACLE database is called as ORACLE SERVER.

Oracle Server = Database Instance + Database Physical files

Database Instance = SGA (Shared Global Area) + BGP (Background Processes)

Database Physical Files = Controlfiles + Datafiles + Archivelog files + Online redolog files +

Parameter files + Trace files + Networking files +

RMAN backup files + Alert log file

TAKE THIS COURSE