Trainer

24 yrs exp

Duration

28 Days

Recordings

44 hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

What will you learn?

  • Designed for 2+ yrs DBAs to enhance skill practically
  • Database Architecture and Administration
  • Clusterware Architecture, Installation & Administration
  • Backup and Recovery in RAC
  • High Availability with Services using TAF and FAN
  • Explain the necessity of global resources
  • Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
  • Convert a single-instance Oracle Database to RACs
  • Dataguard configuration
  • Using DGMGRL utility for Dataguard management
  • Performing Switchover and Failover tasks
  • Exadata Architecture, verions and understanding Components
  • Exadata cellcli and dcli commands, managing storage servers
  • Performing Database patching
  • Upgrading clusterware and database from 12.2 to 19c

Who should go for this training?
The following professionals can go for this course:

  • DBA's having minimum 2+ years experience.

What are the pre-requisites for this Course?

  • Oracle DBA

Course Overview

Course Content

Expand All
  • List the major architectural components of Oracle Database
  • Explain memory structures 
  • Describe background processes  
  • Correlate logical and physical storage structures
  • Describe multitenant architecture
  • Describe the methods and tools used to create PDBs
  • Create PDBs from seed by using SQL*Plus
  • Clone PDBs by using SQL*Plus
  • Unplug and plug in PDBs and Drop PDBs by using SQL*Plus
  • Connect to an Oracle Database
  • Describe the tools used to access an Oracle Database
  • Describe the Oracle-supplied user accounts for Oracle Database
  • Query the data dictionary in an Oracle Database
  • Describe initialization parameter files and parameters
  • View and modify initialization parameters in SQL*Plus 
  • Start up and shut down Oracle databases 
  • Open and close PDBs 
  • Work with the Automatic Diagnostic Repository (ADR) 
  • Query dynamic performance views

  • Describe Oracle Net Services
  • Explain how listeners work 
  • Configure listeners for dynamic or static service registration 
  • Configure local naming for database connections 
  • Test Oracle Net connectivity with tnsping 
  • Configure communication between databases by creating database links
  • Create database users, Grant privileges to users
  • Create and grant roles to users or other roles 
  • Revoke privileges and roles from users and other roles 
  • Create and assign profiles to users 
  • Explain the various authentication options for users 
  • Assign quota to users
  • Explain how table data is stored in the database
  • Create and drop tablespaces 
  • Alter tablespaces, view tablespace information 
  • Implement Oracle Managed Files (OMF) 
  • Use SQL*Plus to move and rename online data files 
  • Implement tablespace encryption
  • Describe how the Oracle Database server automatically manages space
  • Save space by using compression 
  • Proactively monitor and manage tablespace space usage 
  • Describe segment creation in the Oracle database
  • Control deferred segment creation
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality 
  • Manage resumable space allocation 
  • Explain DML and undo data generation
  • Monitor and administer undo data 
  • Describe the difference between undo data and redo data 
  • Configure undo retention 
  • Guarantee undo retention 
  • Enable temporary undo 
  • Use the Undo Advisor
  • Describe ways to move data
  • Explain the general architecture of Oracle Data Pump 
  • Use Data Pump to move data between Oracle databases 
  • Use SQL*Loader to load data from a non-Oracle database (or user files) 
  • Use external tables to move data via platform-independent files
  • Identify DBA responsibilities regarding database backup and recovery
  • Identify the types of failure that can occur in an Oracle database 
  • Describe instance recovery 
  • Describe complete and incomplete recovery 
  • Configuring the Fast Recovery Area 
  • Multiplex the control file & redo log files 
  • Configure ARCHIVELOG mode 
  • Configuring the Backup Retention Policy 
  • Backup Optimization and the CONFIGURE command 
  • Configuring an Archived Redo Log Deletion Policy
  • About Consistent and Inconsistent RMAN Backups
  • About Online Backups and Backup Mode
  • About Backup Sets & Image Copies
  • About Multiple Copies of RMAN Backups
  • About RMAN Control File and Server Parameter File Auto backups
  • About RMAN Incremental Backups & Retention Policies
  • Overview of RMAN Backups
  • Specifying Backup Output Options
  • Backing Up Database Files with RMAN
  • Backing Up CDBs and PDBs
  • Backing Up Archived Redo Logs with RMAN
  • Making and Updating RMAN Incremental Backups

  • Overview of the RMAN Recovery Catalog
  • Creating a Recovery Catalog
  • Registering a Database in the Recovery Catalog
  • Managing Stored Scripts
  • Maintaining & dropping the Recovery Catalog

  • Determine the need for performing recovery
  • Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor and Recovery datafiles
  • Overview of Complete Database Recovery
  • Performing Complete Database Recovery
  • Performing Complete Recovery of CDBs
  • Performing Recovery of Non-Critical datafiles
  • Performing Recovery of Critical datafiles
  • Incomplete Recovery scenarios Loss of Redologs
  • Incomplete Recovery scenarios Loss of Control files
  • Incomplete Recovery scenarios Loss of All Files 
  • Overview of RMAN Incremental Backups
  • Performing Incremental Backups & recovery scenario
  • Performing point-in-time Recovery (PITR) scenarios
  • Understand Database Patching & Upgrade
  • List the purposes and create duplicate database with RMAN
  • Duplicate a database based on a running instance
  • Manually configure and manage Dataguard Setup
  • Understanding Dataguard Roles & types of Modes

  • Configuration DGMGRL
  • Using DGMGRL for monitoring and configuring Dataguard setup
  • Performing switchover and failover tasks using DGMGRL
  • Configure Snapshot standby database
  • perfrom switchover and switchback from snapshot to physical standby
  • Monitor snapshot standby databases
  • Explain the principles and purposes of clusters
  • Describe cluster hardware best practices
  • Describe the Oracle Clusterware architecture
  • High Availability with RAC design
  • RAC Architecture and purpose of VIP’s
  • SCAN NAME, SCAN VIPs, SCAN Listeners architecture
  • Standard cluster and Flex Cluster concepts
  • Components of Clusterware
  • Understanding Processes architecture
  • perform preinstallation tasks for Grid Infrastructure.
  • Perform an image-based Grid Infrastructure installation
  • Verify the installation
  • Configure Automatic Storage Management (ASM) disk groups
  • Demonstrate your Clusterware management proficiency
  • Demonstrate Oracle Cluster Registry (OCR) backup and recovery techniques
  • Manage network settings
  • Describe the scope and capabilities of what-if command evaluation
  • Describe the architecture and components of Flex ASM
  • Install and configure Flex ASM
  • Administer Flex ASM
  • Explain and apply Automatic Storage Management (ASM) initialization parameters
  • Manage ASM instances and associated processes
  • Monitor ASM
  • Install the Oracle database software
  • Create a cluster database 
  • Convert a single-instance Oracle database to RAC
  • Use Enterprise Manager Cluster Database pages 
  • Define redo log files in a RAC environment 
  • Define undo tablespaces in a RAC environment 
  • Explain the benefits of Local Temporary Tablespaces
  • Start and stop RAC databases and instances 
  • Modify initialization parameters in a RAC environment 
  • The RAC database to use ARCHIVELOG mode and the fast recovery area
  • RMAN for the RAC environment
  • Describe the need for global concurrency control
  • Describe Global Resource Directory
  • Explain how global resources are managed
  • Describe about RAC global resource access coordination
  • Configure and manage services in a RAC environment
  • Use services with client applications
  • Use services with the Database Resource Manager
  • Use services with the Scheduler
  • Configure services aggregation and tracing
  • Configure client-side connect-time load balancing
  • Configure client-side connect-time failover
  • Configure server-side connect-time load balancing
  • Configure Transparent Application Failover (TAF)
  • Describe the purpose of Transaction Guard and Application Continuity
  • Describe the key concepts relating to Application Continuity
  • Perform an online database relocation
  • Add an Oracle RAC One Node Database to an existing Cluster
  • Convert an Oracle RAC One Node database to a RAC database
  • Use DBCA to convert a single instance database to a RAC One Node database
  • Describe the multitenant architecture in a non-RAC environment
  • Describe the multitenant architecture in a RAC environment
  • Create a RAC multitenant container database (CDB)
  • Create a pluggable database (PDB) in a RAC CDB
  • Use default CDB and PDB services
  • Create PDB services to associate PDB services with server pools
  • Drop a pluggable database (PDB) from a RAC CDB
  • Describe the types of patches and upgrades available
  • Plan for rolling patches and rolling upgrades
  • Compare software versions with the active version
  • Install a patch with the opatch utility
  • Upgrade clusterware from 12.2 to 19c including practice
  • Describe the types of patches available
  • Install a patch set with the Oracle Universal Installer (OUI) utility
  • Install a patch with the opatch utility
  • Patching and Upgrading database from 12.2 to 19c including practice
  • Provide an overview-level description of Exadata Storage Server and the different Exadata Database Machine configurations
  • Exadata X8M Hardware
  • Exadata Database Machine X8M-2
  • Exadata Database Machine X8M-8
  • RDMA Over Converged Ethernet (RoCE): Overview
  • Outline the key capacity and performance specifications for Exadata Database Machine
  • The Exadata network architecture
  • RDMA over Converged Ethernet (RoCE)
  • How multiple Exadata racks can be interconnected
  • The Exadata software architecture
  • The Exadata Storage Server storage entities and their relationships
  • Disk Group Configuration
  • Exadata Smart Scan Model
  • Exadata Storage Index: Overview
  • Hybrid Columnar Compression: Overview
  • Exadata Smart Flash Cache: Overview
  • Persistent Memory (PMEM) 
  • In-Memory Columnar Caching on Storage Servers
  • Exafusion Direct-to-Wire Protocol
  • Exadata X8M RoCE: High Priority Networking
  • I/O Resource Management: Overview
  • Configure Exadata Storage Server software
  • Create and configure ASM disk groups using Exadata storage
  • Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server
  • Describe the requirements for Smart Scan
  • Describe the circumstances that prevent using Smart Scan
  • Identify Smart Scan in SQL execution plans
  • Use database statistics and wait events to confirm how queries are processed
  • Describe the general steps to migrate your database to Exadata
  • Performing Capacity Planning
  • Exadata Migration Considerations
  • List the main approaches for migrating your database to Exadata
  • Identify the most appropriate approach for different circumstances
Brochure Download

Modes of Training

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Contact Us

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : OCM Certified, 24 exp and delivered more than 700 batches
  • QUALITY CONTENT : More content including advance features covered better in Industry
  • ONLINE LAB : Online Server access provided for doing your LAB practices
  • BEST PRICE : Affordable and best competitive price in the market
  • RECORDINGS : High-quality sessions recordings access for referring multiple times
  • REALTIME SCENARIOS : Training contains projects on Real-time Scenarios to gain more confidence
Key Benefits

Upcoming Batches

SELF-PACED LEARNING

This Course Includes:

₹0/-

Our Instructor

Akal Singh

Oracle Certified Master
  • 4.5 Instructor Rating
  • 2,852 Reviews
Akal Singh stands at the forefront of the fastest moving technologies in IT Industry. He spent his past 24 yrs experience as Oracle DBA with skills into DBA Support, High Availability Design & Implementations, Technical Solutions, Automation using Scripting, Database Designing & as a Corporate Trainer too. With deep technical industry knowledge, Akal Singh has implemented many real time projects on advance Database areas.

His certification list includes many OCP, Oracle Certified Expert/Specialist (OCE) and Oracle Certified Master (OCM). He is an expertise in OS Administrations, Virtualizations/VMWare and Oracle Database 8i/9i/10g/11g & 12c, RAC, Data Guard, ASM, Oracle Exadata, Oracle Performance Tuning, Golden Gate, Streams, Oracle Security & many more advance technologies.

Akal Singh is also recognized as Senior Corporate Instructor and worked with Oracle University training division providing more than 300 corporate trainings into database advance concepts.

Certifications include :
  • Oracle Certified Professional (OCP) 9i, 10g, 11g and 12c
  • Oracle Certified RAC Expert (OCE)
  • Oracle RAC 11g Release 2 and Grid Infrastructure Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 11g Exadata Certified Implementation Specialist
  • Oracle Exadata X5 Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 10g Certified Master (OCM)
  • Oracle Cloud Autonomous Database Specialist
  • Oracle Cloud Infrastructure Certified Associate
  • Foundation Certificate in IT Service Management (ITIL Certificate)

Demo Video

No Video Found

No Demo Video

Certification Guidence

No Records Found

Faq

Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
RAC Administration
(548 Reviews)

 22,000/-

save 8%

 24000/-
RAC Administration

Enroll Now

Classroom

RAC Administration +
12c Goldengate
(312 Reviews)

 21,000/-

save 13%

 24000/-
RAC Administration

Enroll Now

Online

RAC Administration +
Exadata X8
(130 Reviews)

 40,000/-

save 26%

 54000/-
Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
Apps DBA 12.2
(311 Reviews)

 20,000/-

save 29%

 28000/-

Related Courses

View All Courses

Testimonials

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8