ORACLE DBA RAC Training

  1. Home
  2. Contact Us

ORACLE DBA RAC Training

    Course Highlights:
  • Real time Faculty/Trainer working in MNC Organization
  • 24*7 Live Server Access for Practice
  • Practical Session with real time scenarios throughout the course
  • Study Material document with snapshot
  • Access to Live Recorded Session file
  • Resume Preparation help
  • Certification help document
  • Course Duration 30-35 hours.
    Introduction to DBMS

    What is a database?
    History of Oracle database
    Role of a Database Administrator

    Basic SQL
  • What are DML, DDL and DCL?
  • Examples on DML, DDL and DCL
    Installing Oracle database software (11g R2 and 12c R1)
  • Pre-requisites for a successful Oracle software installation
  • Installation of oracle software using GUI and Manual Method
  • Installation of Oracle 11g R2 database software
  • Installation of Oracle 12c database software (Latest Release)
    Oracle Database Architecture
  • Detail explanation on components of an Oracle database architecture
  • Oracle database memory and process architecture
    Oracle Database Creation
  • Introduction
  • Planning for an Oracle database creation
  • Creating an Oracle database using the MANUAL method
  • Creating an Oracle database using the GUI Tool (DBCA)
  • Startup and Shutdown Methods
  • Best practices using OFA for database creation
    Database storage Management
  • Introduction
  • Tablespaces creation methods
  • Datafiles creation methods
  • How to resize/rename thetablespace/datafiles
  • How to Change the location of datafiles
  • How to create controlfile trace
  • Redolog file architecture and best practices
  • How to resize/rename the redolog file
  • Benefits of Archiving, how to enable/disableArchivelog mode for a database
  • Temporary tablespaces and temporary tablespace groups
  • Best practices for database storage management
  • Scripts fortablespaceadministration
    Oracle Networking
  • Introduction
  • Oracle listener configuration using NETCA and Manual method
  • SQLNET filebenefits and configuration
  • Oracle database connections from other systems
  • Configuration of tnsnames.ora fileusing NETCA and Manual method
  • Listener administration
    User Administration and Security
  • Create database users
  • Database resource management
  • Locking/unlocking a user account
  • User’s password management
  • How to audit Oracle DBA commands (SYS Operations).
    User Managed Backup and Recovery
  • Introduction: Backup and Recovery Strategy for user managed backup
  • How to backup an Oracle database using COLD BACKUP
  • How to backup an Oracle database using HOT BACKUP
  • Recovery scenarios using User managed backup
    RMAN Backup and Recovery
  • RMAN backup vs manual backup
  • Benefits of normal and compress mode backup
  • What is catalog and benefits?
  • What is virtual catalog and benefits?
  • How to create catalog/virtual catalog
  • Database backup using RMAN with normal and compressed mode
  • Oracle database backup metadata
  • Database backup using catalog and nocatalog
  • Querying the RMAN metadata
  • Fast Recovery Area management
  • What is incremental backup? types of incremental backups and their benefits
  • How to backup incremental database
  • Best practices for backup management and backup strategy (RTO and RPO)
  • Recovery scenarios using RMAN
    Oracle database upgrades
  • Introduction
  • Upgrade using GUI and Manual Method
  • Best practices for database upgrade
    Oracle database Logical backup
  • Traditional Export/import vsExpdp/impdp
  • Benefits of Logical backup
  • Physical backup vs logical backup
  • Pre requisites to take datapump backup
  • Backup methods using datapump
  • How to start/stop datapump job
  • Monitoring datapump jobs
    Job Management
  • Scheduling JOBS and scripts through UNIX/LINUX crontab utility
  • Scheduling jobs in database using DBMS utility
  • Oracle database job management
    Cloning
  • Introduction
  • Cloning database using RMAN and Cold backup
  • Cloning database using same datafilestorage locations and different datafilestorage locations
    Patching

    Introduction

    How to apply cpu and psu patches

    Oracle Database Performance Tuning
  • What is proactive/reactive tuning?
  • V$ views for performance monitoring and analysis
  • How to size the Oracle database memory structures for optimal performance
  • Oracle database wait events
  • Oracle UNDO management sizing for optimal performance
  • Oracle TEMP space sizing for optimal performance
  • How to generate AWR, ADDM, and ASSH reports
  • How to interpret AWR, ADDM, and ASSH reports using real-time scenarios
  • SQL Query tracing using TKPROF
  • Database Statistics best practices for optimal performance
    Oracle Data Guard
  • Introduction
  • What are role transitions? Redo apply services and protection modes
  • Creation of physical standby database using RMAN and Manual Method
  • What is Active and snapshot standby database and their benefits
  • Standby database administration
    Oracle 12c New Features: Multitenant Architecture
  • Understanding Container database (CDB) and Pluggable Database (PDB) in Oracle 12c release
  • How Oracle 12c CDB,PDB instance architecture differs from Oracle 11g,10g instance architectures
  • How to create a non-CDB database in Oracle 12c (Traditional database) using DBCA Tool
  • How to create a CDB database in 12c (using the multitenant feature)
  • How to move (plug) the non-CDB database into the CDB database as a pluggable database (PDB)
  • Learn about various other new features of Oracle 12c
  • Real world Business use cases for using Oracle 12c Multitenant architecture
    Advance Course: High Availability
  • Oracle ASM
  • Introduction
  • Oracle ASM Architecture
  • Install and configure ASM using GUI and Manual method
  • Oracle ASM Disk Group management
  • Restore and Recovery scenarios of ASM Diskgroup
  • Disk group management using command line utility (ASMCMD)
  • Best practices using MAA Architecture
    Oracle Data Guard
  • Introduction
  • Oracle Dataguard Architecture
  • What are role transitions? Redo apply services and protection modes
  • Creation of physical standby database using RMAN and Manual Method
  • What is Active and snapshot standby database and their benefits
  • How to configure Active standby database and snapshot standby database
  • Standby database administration and issues
  • Scenarios on Role switchover/failover
  • Scenarios on restore and recovery
  • Best practices using MAA Architecture
    Oracle RAC
  • Introduction
  • What is SCAN and benefits?
  • Oracle RAC Architecture
  • Pre-requisites for RAC installations
  • Installation and configuration of Oracle 2 Node RAC using DNS Server:
  • Install and configure DNS Server for SCAN IP
  • Installation and configuration of clusterware
  • Grid and RAC install
  • Backup management and strategy for OCR and Votedisk
  • Oracle RAC Service management
  • Node addition and deletion
  • Node eviction issues
  • Cluster issues
  • Startup and shutdown oracle database using SRVCTL utility
  • Cluster management using CRSCTL utility
  • Creation of Standby database using 2 Node RAC
  • Oracle Golden Gate