Scribd Logo
Upload

Welcome to Scribd!

  • 144 views

    Oracle Workshop 1 Syllabus

    Uploaded by

    Anonymous RyqwFMMuJM
    This document outlines the topics that will be covered in an Oracle database administration workshop, including exploring Oracle database architecture, preparing the database environment, creating and managing databases, configuring security and networking, managing storage and users, backups and recovery, and moving data. Specific topics that will be addressed include memory and process structures, installation, initialization parameters, auditing, monitoring performance, patching, backups, recovery, and using Data Pump to move data between databases.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Oracle Workshop 1 Syllabus

    Uploaded by

    Anonymous RyqwFMMuJM
    144 views3 pages
    This document outlines the topics that will be covered in an Oracle database administration workshop, including exploring Oracle database architecture, preparing the database environment, creating and managing databases, configuring security and networking, managing storage and users, backups and recovery, and moving data. Specific topics that will be addressed include memory and process structures, installation, initialization parameters, auditing, monitoring performance, patching, backups, recovery, and using Data Pump to move data between databases.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the topics that will be covered in an Oracle database administration workshop, including exploring Oracle database architecture, preparing the database environment, creating and managing databases, configuring security and networking, managing storage and users, backups and recovery, and moving data. Specific topics that will be addressed include memory and process structures, installation, initialization parameters, auditing, monitoring performance, patching, backups, recovery, and using Data Pump to move data between databases.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    144 views3 pages

    Oracle Workshop 1 Syllabus

    Uploaded by

    Anonymous RyqwFMMuJM
    This document outlines the topics that will be covered in an Oracle database administration workshop, including exploring Oracle database architecture, preparing the database environment, creating and managing databases, configuring security and networking, managing storage and users, backups and recovery, and moving data. Specific topics that will be addressed include memory and process structures, installation, initialization parameters, auditing, monitoring performance, patching, backups, recovery, and using Data Pump to move data between databases.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    ADMINSTRATION WORKSHOP 1

    SYLLABUS 11G
    Exploring the Oracle Database Architecture

    Explain the Memory Structures

    Describe the Process Structures

    Overview of Storage Structures

    Preparing the Database Environment

    Identify the tools for Administering an Oracle Database

    Plan an Oracle Database installation

    Install the Oracle software by using Oracle Universal Installer (OUI)

    Creating an Oracle Database

    Create a database by using the Database Configuration Assistant (DBCA)

    Managing the Oracle Instance

    Setting database initialization parameters

    Describe the stages of database startup and shutdown

    Using alert log and trace files

    Using data dictionary and dynamic performance views

    Configuring the Oracle Network Environment

    Configure and Manage the Oracle Network

    Using the Oracle Shared Server architecture

    Managing Database Storage Structures

    Overview of tablespace and datafiles

    Create and manage tablespaces

    Space management in tablespaces

    Administering User Security

    Create and manage database user accounts

    Grant and revoke privileges

    Create and manage roles

    Create and manage profiles

    Managing Data and Concurrency

    Monitor and resolve locking conflicts

    Managing Undo Data

    Overview of Undo

    Transactions and undo data

    Managing undo

    Implementing Oracle Database Security

    Database Database Security and Principle of Least Privilege

    Work with Standard Auditing

    Database Maintenance

    Use and manage optimizer statistics

    Use and manage Automatic Workload Repository (AWR)

    Use advisory framework

    Manage Alerts and Thresholds

    Performance Management

    Use Automatic Memory Management

    Use Memory Advisors

    Troubleshoot invalid and unusable objects

    Intelligent Infrastructure Enhancements

    Use the Enterprise Manager Support Workbench

    Managing Patches

    Backup and Recovery Concepts

    Identify the types of failure that can occur in an Oracle database

    Describe ways to tune instance recovery

    Identify the importance of checkpoints, redo log files, and archived log files

    Overview of flash recovery area

    Configure ARCHIVELOG mode

    Performing Database Backups

    Create consistent database backups

    Back up your database without shutting it down

    Create incremental backups

    Automate database backups

    Manage backups, view backup reports and monitor the flash recovery area

    Performing Database Recovery

    Overview of Data Recovery Advisor

    Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

    Moving Data

    Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)

    Explain the general architecture of Oracle Data Pump

    Use Data Pump Export and Import to move data between Oracle databases

    You might also like