Oracle DBA Training in Bangalore


Oracle Database Administration

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

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

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

Configuring for Recoverability 

Configure multiple archive log file destinations to increase availability

Define, apply and use a retention policy 

Configure the Flash Recovery Area 

Use Flash Recovery Area

Using the RMAN Recovery Catalog

Identify situations that require RMAN recovery catalog

Create and configure a recovery catalog 

Synchronize the recovery catalog  

Create and Use RMAN stored scripts 

Back up the recovery catalog 

Create and use a virtual private catalog

Configuring Backup Specifications

Configure backup settings

Allocate channels to use in backing up  

Configure backup optimization 

Using RMAN to Create Backups

Create image file backups

Create a whole database backup  

Enable fast incremental backup  

Create duplex backup and back up backup sets 

Create an archival backup for long-term retention  

Create a multisection, compressed and encrypted backup  

Report on and maintain backups 

Using RMAN to Perform Recovery

Perform complete recovery from a critical or noncritical data file loss using RMAN

Perform incomplete recovery using RMAN  

Recover using incrementally updated backups  

Switch to image copies for fast recovery 

Restore a database onto a new host  

Recover using a backup control file  

Perform Disaster recovery 

Using RMAN to Duplicate a Database

Creating a duplicate database

Using a duplicate database 

Performing Tablespace Point-in-Time Recovery

Identify the situations that require TSPITR 

Perform automated TSPITR

Monitoring and Tuning RMAN

Monitoring RMAN sessions and jobs

Tuning RMAN 

Configure RMAN for Asynchronous I/O

Using Flashback Technology

Restore dropped tables from the recycle bin

Perform Flashback Query 

Use Flashback Transaction

Additional Flashback Operations

Perform Flashback Table operations

Configure, Monitor Flashback Database and Perform Flashback Database operations 

Set up and use a Flashback Data Archive 

Diagnosing the Database

Set up Automatic Diagnostic Repository

Using Support Workbench  

Perform Block Media Recovery 

Managing Memory

Implement Automatic Memory Management

Manually configure SGA parameters  

Configure automatic PGA memory management 

Managing Database Performance

Use the SQL Tuning Advisor

Use the SQL Access Advisor to tune a workload  

Understand Database Replay 

Space Management

Manage resumable space allocation

Describe the concepts of transportable tablespaces and databases  

Reclaim wasted space from tables and indexes by using the segment shrink functionality 

Managing Resources

Understand the database resource manager

Create and use Database Resource Manager Components

Automating Tasks with the Schedule

Create a job, program, and schedule

Use a time-based or event-based schedule for executing Scheduler jobs 

Create lightweight jobs 

Use job chains to perform a series of related tasks 

Administering the Scheduler

Create Windows and Job Classes

Use advanced Scheduler concepts to prioritize jobs 

Best Oracle SQL/PLSQL Training with Certification Providing in Akshaya Learning. Oracle courses in Bangalore with live projects training. Akshaya Learning is the best Oracle training institute in Bangalore with 100% placement Support Provided for Students.Oracle Fusion finance training institute in bangalore. We will provide oracle Course for beginners from Scratch to advanced Concepts in Real-time. Learn Oracle Goldengate,Oracle RAC,Oracle DBA training as a fresher and build your live project.

Oracle DBA Interview Questions