22 yrs exp


40 Days


60 Hrs


Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

What will you learn?

  • Learn about the Oracle Database Architecture.
  • Create and manage an Oracle Database Instance.
  • Create and manage Storage Structures.
  • Configure the Oracle Network Environment.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Develop backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use Flashback Technologies and data duplication to complement backup and recovery procedures.
  • Secure the availability of your database by appropriate backup and recovery strategies.
  • Understand the multitenant architecture.
  • Create and manage a multitenant container database and pluggable databases.
  • Understand regular and application pluggable databases.
  • Manage storage within a multitenant container database and pluggable databases.
  • Manage security within a multitenant container database and regular and application pluggable databases

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

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course?

Oracle SQL and Linux Basics

Course Overview

Course Content

  • Create and manage database user accounts:
  • Grant and revoke privileges
  • Create and manage roles & profiles
  • Start and stop the Oracle database instance and components
  • Modify database initialization parameters
  • Describe the stages of database startup & shutdown options
  • Access dynamic performance views & view alert log
  • Describe the storage of table row data in blocks
  • Create and manage tablespaces & obtain information
  • List the major architectural components of Oracle Database
  • Explain memory structures and background processes
  • Correlate logical and physical storage structure     
  • ​Describe pluggable databases
  • Describe the locking mechanism and how Oracle manages concurrency
  • Monitor and resolve locking conflicts
  • 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
  • Create Listeners, Net Service aliases
  • Use the Listener Control Utility to manage Oracle Net Listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers
  • Describe DBA responsibilities for security and auditing
  • Enable and create unified auditing policies
  • Maintain the audit trail
  • Explain the general architecture of Oracle Data Pump
  • Describe ways to move data, Create and use directory objects
  • Use Data Pump Export and Import to move data between Oracle DBs
  • Use SQL*Loader to load data from a non-Oracle DB (or user files)
  • Use external tables to move data via platform-independent files
  • Describe database architecture as it relates to backup and recovery
  • Describe NOARCHIVELOG mode & tools for backup and recovery
  • Perform basic backup and recovery
  • Configure and manage RMAN settings, Configure FRA
  • Configure the control files & redo log files for recoverability
  • Configure ARCHIVELOG mode and the archived redo log files for recoverability
  • Describe the use of the RMAN recovery catalog, Create Catalog
  • Register a database in the RMAN recovery catalog
  • Describe Oracle backup solutions, RMAN backup types
  • Describe, compare, and determine your backup strategy
  • Schedule backups accordingly, perform whole backups
  • Perform full and incremental backups
  • Use Oracle-suggested backup strategy, Report and manage backups
  • Begin refining your basic backups:

           - Configure Block Change tracking, Perform incremental level backups

           - Recover an incremental level 0 backup with level 1 incremental

  • Compress backups, Use media manager
  • Create multi-section backups of very large files
  • Create proxy copies, duplexed backup sets, archival backups
  • Back up other files:

         - Back up a control file to trace

         - Back up archived redo log files, ASM metadata

         - Catalog additional backup files

  • Describe and create RMAN-encrypted backups
  • Use Transparent-mode, Password-mode & Dual-mode encryption
  • Detect and repair database corruption
  • Use the Automatic Diagnostic Repository (ADR)
  • Analyze instance recovery with ADRCI
  • Use the Data Recovery Advisor
  • Understand how to employ the best Oracle Database recovery technology for your failure situation
  • Describe instance or crash recovery
  • Describe complete and point-in-time recovery
  • Describe recovery through RESETLOGS
  • Perform the appropriate type of restore and recovery
  • Recover from media failures in data files
  • Perform complete and incomplete or “point-in-time” recoveries
  • Recover from the loss of the server parameter file
  • Recover from control file and redo log file failures
  • Re-create the password authentication file
  • Recover index and read-only tablespaces
  • Review the automatic recovery of the tempfile
  • Describe the basic procedure of restoring the database to a new host
  • Distinguish and describe point-in-time recovery (PITR) of table, tablespace, and database
  • List what operations occur when you perform a point-in-time recovery
  • Determine the correct target time for the point-in-time recovery
  • Perform automated TSPITR, Perform table recovery from backups
  • Understand flashback technologies from various types of errors
  • Configure your database to use flashback technologies
  • Perform flashback query, version query, transaction backout
  • Perform flashback table, recyclebin, flashback data archive

  • Describe Flashback Database architecture
  • Configure your database to support Flashback Database
  • Transport tablespaces between databases by using image copies or backup sets
  • Transport databases by using data files or backup sets

  • List the purposes and create duplicate database with RMAN
  • Duplicate a database based on a running instance
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds, Use server-generated alerts

  • Enterprise Manager to monitor performance
  • Automatic Memory Management (AMM)
  • The Memory Advisor to size memory buffers
  • Manage optimizer statistics
  • Use the SQL Tuning Advisor to:

                - Identify SQL statements that are using the most resources

                - Tune SQL statements that are using the most resources

  • Use the SQL Access Advisor to tune a workload
  • Configure the Database Resource Manager
  • Access and create resource plans, Create consumer groups
  • Map consumer groups to plans, Activate a resource plan
  • Monitor the Resource Manager
  • Automating Tasks by Using Oracle Scheduler
  • Describe how the Oracle Database server automatically manages space
  • Save space by using compression
  • Control deferred segment creation & Use the Segment Advisor
  • Reclaim wasted space using the segment shrink
  • Manage resumable space allocation
  • Describe the multitenant architecture
  • Describe the root and pluggable database containers
  • Differentiate the root from a pluggable database
  • Explain pluggable database plugging
  • List impacts in various areas
  • Configure and create a CDB, Create a PDB from PDB$SEED
  • Plug or clone a non-CDB into a CDB
  • Clone a local or remote PDB into a CDB
  • Unplug and plug a PDB from one CDB to another CDB
  • Explore the instance and structure of PDBs
  • Migrate a pre-12.1 non-CDB database to CDB
  • Connections to CDB / PDB, Start up and shut down a CDB
  • Open and close PDBs
  • Change the different modes and settings of PDBs
  • Evaluate the impact of parameter value changes
  • Permanent & temporary tablespaces in CDB and PDBs
  • Common and local users, roles and privileges
  • Perform CDB and PDB backups
  • Recover CDB and PDB from essential file loss
  • Perform flashback database
  • Describe activity tracking with Heat Map
  • Describe Automatic Data Optimization
  • Use views and procedures to monitor ADO
  • Move a data file online, Move a partition online
  • Describe the new RMAN enhancements
  • Perform cross-platform data transport
  • Use Table Recovery

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.

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : OCM Certified, 22 Yrs exp and delivered more than 350 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


This Course Includes:
  • Delivered by our experts having 22 yrs exp
  • 40 Virtual online sessions
  • Access for 60 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicated online AksWave server access
  • 70 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

Not yet scheduled

9 % OFF 22,000/- $242 20,000/-


This Course Includes:
  • Access for 60 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicate online AksWave server access
  • 70 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email


Our Instructor

Demo Video

No Video Found

No Demo Video

Certification Guidence

  • This course is designed for clearing the Oracle Database 12c Administration 1Z0-062 Certification exam.
  • This entire course content and our trainers helps you to get expertise and clear the certification program easily
  • You will be awarded with Akswave course completion certificate after the course completion.
AksWave Certificate

Further details related to Oracle Database 12c Administration certification find here.


Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that 

particular session.

You can contact our support team, or just drop an email to with your queries.

For practical execution, our trainer/technical team will provide server access details to the student

The course material and recorded videos which are provided during the course period. You can download it anytime.

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant

& special discount for 2 or more participants.

Live-Online training is where you can have live session with the trainer and clarify queries parallely.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.

* If request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If request made after 2 days, then Refund is made after deduction of administration fee.

Combo Offers

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


Manoj Kumar

2 years ago

I recently took Oracle RAC training from Akswave. Akal Sir is one of the best teacher for Oracle RAC. I learned lot of concepts, understood well and he cleared many of my doubts too. His explanation and presentation is better and easy to understand. About online Lab environment its good and the Co-ordinators are very helpful in clearing my doubts. I personally enjoyed and learned many new things in AKSWAVE.

Ravi Krishna

3 years ago

I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. Lets see when the GoldenGate classroom training will start, I like to join.

Azjad Hussain

3 years ago

Akswave Oracle Training is one of the best institute in Ameerpet, comparing to other institutes in terms of Lab Infrastructure , helping nature faculties and the amazing skilled Mr Akal singh. Now waiting for cloud training to be started.

Google Ratings


Facebook Ratings


Twitter Ratings