Course Name : ORACLE DBA 10g & 11g 24*7 Technical Support
Duration : 35 hours
Faculty : Realtime experience Sun trainings is a best online center in Hyderabad. We are providing very best online training on ORACLE DBA 10g & 11g.
Course Content: INTRODUCTION
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 table space and data files • Create and manage table spaces • Space management in table spaces Administering User Security • Create and manage database user accounts • Grant and revoke privileges • Create and manage roles • Create and manage profiles Managing Undo Data • Overview of Undo • Transactions and undo data • Managing undo Implementing Oracle Database Security • Database Security and Principle of Least Privilege • Work with Standard Database Auditing 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