Oracle DBA Online Training

About Oracle DBA

Every database requires one database administrator (DBA) to administrate the data. If we have many users then the oracle database is very large, one person is not enough to do that work. In such cases the work, responsibilities is divided between number of people.

  • Installing the oracle server and the oracle application
  • Allocating the system storage and planning future storage requirements for the database system
  • How to create primary database storage structures (tables paces) after the completion of application by application developers
  • Creating primary objects (tables, views, indexes) once application developers have designed an application
  • Modifying the database structure, as necessary, from information given by application developers

  • Grid computing
  • Oracle Enterprise manager 10g product controls
  • Database Architecture review
  • Using a flash recovery area with RMAN
  • Configuring RMAN
  • Control file Auto backup’s
  • Retention policies and channel allocation
  • Using recovery manager to connect to a target database
  • Displaying the current RMAN Configuration settings
  • Altering the backup retention policy with database


    Knowledge with oracle modules, sql can learn oracle DBA.


    SQL, Oracle modules are the pre-requisites for the oracle DBA. RizeTrainings provides oracle apps online training with real time experienced faculty .Our faculty provides job assistance training.

    Course Details:
    Grid Computing
    Oracle Enterprise Manager 10g Product Controls
    Database Architecture Review

    Configuring Recovery Manager
    Recovery Manager Features and Components
    Using a Flash Recovery Area with RMAN
    Configuring RMAN
    Control File Autobackups
    Retention Policies and Channel Allocation
    Using Recovery Manager to connect to a target database in default NOCATALOG mode
    Displaying the current RMAN configuration settings
    Altering the backup retention policy for a database

    Using Recovery Manager
    RMAN Command Overview
    Parallelization of Backup Sets
    Compressed Backups
    Image Copy
    Whole Database and Incremental Backups
    LIST and REPORT commands
    Enable ARCHIVELOG mode for the database
    Use Recovery Manager

    Oracle Secure Backup

    Installation and Configuration Implement the Oracle suggested strategy
    RMAN and Oracle Secure Backup
    Database and File-system files backup/restore to tape
    Using obtool and web interface to configure Oracle Secure Backup devices (CLI/GUI)
    Configuring EM for Oracle Secure Backup and test backup to tape (EM)
    Using RMAN to backup your database to tape (CLI)
    Using the OB Web tool to backup file system files

    Recovering from Non-critical Losses
    Recovery of Non-Critical Files
    Creating New Temporary Tablespace
    Recreating Redo Log Files, Index Tablespaces, and Indexes
    Read-Only Tablespace Recovery
    Authentication Methods for Database Administrators
    Loss of Password Authentication File
    Creating a new temporary tablespace
    Altering the default temporary tablespace for a database

    Incomplete Recovery
    Recovery Steps
    Server and User Managed Recovery commands
    Recovering a Control File Autobackup
    Creating a New Control File
    Incomplete Recovery Overview
    Incomplete Recovery Best Practices
    Simplified Recovery Through RESETLOGS
    Point-in-time recovery using RMAN

    Flashback Database Architecture
    Configuring and Monitoring Flashback Database
    Backing Up the Flash Recovery Area
    Flashback Database Considerations
    Using the Flashback Database RMAN interface
    Using Flashback Database EM Interface
    Managing and monitoring Flashback Database operations

    Dealing with Database Corruption
    Block Corruption Symptoms: ORA-1578
    DBVERIFY Utility and the ANALYZE command
    Initialization parameter DB_BLOCK_CHECKING
    Segment Metadata Dump and Verification
    Using Flashback for Logical Corruption and using DBMS_REPAIR
    Block Media Recovery
    RMAN BMR Interface
    Dumping and Verifying Segment Metadata

    Monitoring and Managing Memory
    Oracle Memory Structures
    Automatic Shared Memory Management
    SGA Tuning Principles
    Database Control and Automatic Shared Memory Management
    Behavior of Auto-Tuned and Manual SGA Parameters
    Resizing SGA_TARGET
    PGA Management Resources
    Using the Memory Advisor

    Automatic Performance Management
    Identifying Tunable Components
    Oracle Wait Events and System Statistics
    Troubleshooting and Tuning Views
    Direct Attach to SGA for Statistic Collection
    Workload Repository
    Advisory Framework
    ADDM Scenarios and Usage Tips
    Using the SQL Tuning and SQL Access Advisor

    Monitoring and Managing Storage I
    Database Storage Structures
    Space Management Overview
    Oracle-Managed Files (OMF)
    Row Chaining and Migrating
    Proactive Tablespace Monitoring
    Managing Resumable Space Allocation
    SYSAUX Tablespace
    Monitoring table and index space usage

    Monitoring and Managing Storage II
    Automatic Undo Management
    Redo Log Files
    Table Types
    Partitioned Tables
    Index-Organized Tables (IOT)
    Managing index space with SQL
    Configure optimal redo log file size
    View "Automatic Tuning of Undo Retention"

    Automatic Storage Management
    ASM General Architecture and Functionalities
    Dynamic Performance View Additions
    Managing an ASM Instance
    ASM Disk Groups
    Using asmcmd Command Line
    Migrating Your Database to ASM Storage
    Creating an ASM instance in a separate Oracle Home
    Migrating a tablespace to use ASM storage

    VLDB Support
    Creating Bigfile Tablespaces
    Packages and data dictionary changes to support VLDB
    Creating and maintaining temporary tablespace groups (TTG)
    Partitioning and Partitioned Indexes
    Skipping unusable indexes
    Creating and using hash-partitioned global indexes
    DML Error Logging
    Interpreting Bigfile ROWIDs

    Managing Resources
    Database Resource Manager Concepts and Configuration
    Creating a New Resource Plan
    Active Session Pool Mechanism
    Maximum Estimated Execution Time
    Creating a Complex Plan
    Administering and Monitoring Resource Manager
    Resource Plan Directives
    Creating Resource Consumer Groups

    Automating Tasks with the Scheduler
    Scheduler Concepts
    Creating a Job Class and a Window
    Managing Jobs, Programs, Chains, Events, Schedules, priority
    Viewing and Purging Job Logs
    Creating a program and a schedule
    Creating a job that uses a program and a schedule
    Altering the program and schedule for the job and observing the behavior change of the job
    Monitoring job runs

    Database Security
    Virtual Private Database: Overview
    Creating a Column-Level Policy
    Writing a Policy Function
    Policy Types
    Column level VPD with column masking
    Transparent Data Encryption
    Setting the listener password
    Implement VPD

    Data Movement
    External Tables Concepts
    Creating a Directory object and External Table
    Data Pump
    Transport Database
    Transport Tablespace
    Create a Directory Object
    Create a Temporary Table

    Using Globalization Support
    Globalization Support Features
    Encoding Schemes
    Database Character Sets and National Character Sets
    Specifying Language-Dependent Behavior
    Locale Variants
    Using Linguistic Comparison and Sorting
    Data Conversion Between Client and Server Character Sets
    Determining the Default NLS Settings

    Workshop Methodology, requirements, and setup
    Scenario 1: Database performance
    Scenario 2: Finding and Tuning Inefficient SQL
    Scenario 3: SGA Management - REDO
    Scenario 4: Running out of Undo Space
    Scenario 5: Missing datafile
    Scenario 6: Managing space in a tablespace - REDO
    Scenario 7: Missing TEMP data file

    RIZE Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. RIZE come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.

    RIZE trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.

    The course begins in a few days, and I still do not have my login information. What do I do?
    Once your registration for a course is completed, we will send activation link to start your sessions.

    What happens if I miss my training date, do I have any options?
    In case you miss training date, we will send recorded sessions to you. Otherwise, we assign for next live batch.

    How does the online training work?
    All of our online courses are live instructor led online courses. You will have the ability to interact directly with the trainer. Once registered for a class you will receive detailed instructions on how to access your class.

    How do I receive the course materials?
    You receive a link to download the course materials when you register. Our trainers assist you in your assessments, case studies, sample projects, interview skills etc;

    Will I be able to view the sessions again at a later time?
    Yes, We provide recorded sessions.

    Who are your trainers?
    All our trainers are working professionals from the Industry and have at least 10-12 yrs of relevant experience in various domains. They are subject matter experts. So that participants get a great learning experience.

    Can I get the same in-class experience at home or work?
    Yes. You can attend courses anywhere that has an Internet connection. If you choose to participate from your home or workplace, you must validate your own equipment to ensure it meets the required specifications.

    What should I bring to class?
    You need to have your course materials, Internet, computer headset and the Link to your Rizetrainings classroom e-mail, which contains the link and LOGIN credentials you need to take your course.

    Where can I get more information?
    If you need more information, please call us at +91 8019199995 or send mail to . Rize Trainings Advisors will be happy to assist you.

    Do you offer placements?
    We help our customers for preparing their resumes, work on sample live projects and provide assistance for interview preparation. We don't offer any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

    What happens if I have technical problems during my class?
    If you have technical difficulties, you call us at +91 8019199995 . Our support team will resolve any issues you might encounter.

    Back to top