Administration base de données oracle 12c
In this course, you will learn about the Oracle Server architecture, expand the size of the database, implement security, and how to perform specific database administration tasks.
Duration
.
Audience
- Data analysts
- Database administrators
- Systems administrators
- Network managers
- Technical support personnel
Prerequisite
Knowledge of SQL
Objectives
- To understand and manage the Oracle Database Architecture
- To be able to manage and monitor to running of an Oracle Database 12c instance
- To understand how to manage network connections, security, and privileges on an Oracle Database 12c database
- To understand how to use manage tablespaces and undo data
- To understand how data concurrency and auditing is managed and implemented in Oracle Database 12c
- To understand how to prepare for and perform data backup and recovery tasks in Oracle Database 12c
- To understand the importance of proactive database maintenance, and how to implement it
- Use Oracle Database 12c tools to manage and monitor data, and automate tasks
Information
Our training is available online and on premises
Detailled program
Introduction and Duties of the DBA
- Oracle RDBMS Components
- DBA Responsibilities
Tables, Constraints, and Indexes
- Introduction to Datatypes and Tables
- Integrity Constraints
- Temporary Tables, Partitioned Tables, External Tables, and IOTs
- Indexes and Skip Scanning
- Online Reorganization
- Database Workspace Management
Other Database Schema Objects
- DDL Commands used
- Views, Materialized views
- Sequences, Synonyms, Database Links
- Outlines, Dimensions, Hierarchies
- PL/SQL Program Units
- Supplied Packages
- Oracle Data Dictionary
- Storage of Large Objects (BFILEs, BLOBs, CLOBs)
Starting and Stopping the Database
- What Tool to Use?
- Connecting as a Privileged User
- Password file authentication
- Starting a Database
- Shutting Down a Database
- Reading the Alert Log / Trace Files
- Quiescing the database
- SPFILE / Parameter management
How Space is Physically Consumed - Blocks and Extents
- Basic Definitions
- Blocks and Extents
- Fragmentation / Deallocation
How Space is Logically Consumed - Segments
- Introduction to Segments
- Managing Undo Segments
- Automatic Undo Management
- Managing Sort Activity
- Managing Data Segments
- Managing Index Segments
- Monitoring Database segments
Managing Tablespaces - Default behavior of CREATE TABLESPACE command
- Tablespace Overview
- System Tablespace
- Types of Tablespaces
- Creating additional tablespaces
- Altering Tablespaces
- Temporary Tablespaces - Default Temporary Tablespaces
- Tablespace Quotas
- Monitoring Tablespaces
Basic Oracle Architecture
- Architecture Overview
- Database Structures
- Process Structures
- Memory Structures - SGA
- Memory Structures - PGA
- Alternative Configurations
Oracle Database Files
- Basic Structures of an Oracle RDBMS
- Data Files
- Redo Log Files
- Archived Redo Log Files
- Control Files
- Oracle-Managed Files (OMF)
Users and Security
- Managing Database Users
- System / Object Privileges
- Managing Roles / Profiles
- Resource and Password Management
- The Virtual Private Database
Networking
- Duties of the DBA for Networking
- Overview of Oracle Network Architecture
- Name Resolution
- Oracle Net Client Configuration
- Oracle Net Server Configuration
- Tools
- Configuring the Listener
- Shared Server
Physical NOARCHIVELOG Mode Backups
- Oracle Database Backups
- Automatic Recovery Architecture
- NOARCHIVELOG Mode
- ARCHIVELOG Mode
- Physical Backups
- Closed Backups in NOARCHIVELOG Mode
Configuring Archivelog Mode
Physical ARCHIVELOG Mode Backups
- Configuration of the database for archiving
- Setting the ARCHIVELOG mode
- Establishing multiple archiving destinations
- Closed backups in ARCHIVELOG mode
- Open backups in ARCHIVELOG mode
- Controlfile Backup
Complete Recovery
- Recovery Structures and Processes
- Recovery in NOARCHIVELOG and ARCHIVELOG Mode
Incomplete Recovery
- What is Incomplete Recovery?
- Recovering from Loss of Current Redo Log Files
Data Loading
- SQL*Loader
- External Tables Data Pump