Course Duration:3 Months

Course Details

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

Are you providing Training Classes
IT Courses / Govt Exam Preparation
Higher Studies / Studies Abroad
Post Your Training / Course Enquiry
Are you looking Institutes / Coaching center for
  • IT Courses
  • Govt Exam Preparation
  • Higher Studies in India
  • Studies Abroad
Select your Training / Study Category
Please select atleast one Query.Minimum 10 characters required
NEWFreeCompanies HiringUpdates//nuPM