Excellent Oracle DBA Traning Institute in chennai vadapalani

29/06/2015 Professional & Short Term Course

Price: Check with seller

No image available


Database Maintenance • Manage optimizer statistics • 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 • Use automated tasks Performance Management • Performance Monitoring • Managing Memory Components • Enabling Automatic Memory Management (AMM) • Automatic Shared Memory Advisor • Using Memory Advisors • Dynamic Performance Statistics • Troubleshooting and Tuning Views • Invalid and Unusable Objects Backup and Recovery Concepts • Part of Your Job • Statement Failure • User Error • Understanding Instance Recovery • Phases of Instance Recovery • Using the MTTR Advisor • Media Failure • Archive Log Files Performing Database Backups • Backup Solutions: Overview • Oracle Secure Backup • User-Managed Backup • Terminology • Recovery Manager (RMAN) • Configuring Backup Settings • Backing Up the Control File to a Trace File • Monitoring the Flash Recovery Area Performing Database Recovery • Opening a Database • Data Recovery Advisor • Loss of a Control File • Loss of a Redo Log File • Data Recovery Advisor • Data Failures • Listing Data Failures • Data Recovery Advisor Views Moving Data • Describe ways to move data • Create and use directory objects • Use SQL*Loader to move data • Use external tables to move data • General architecture of Oracle Data Pump • Use Data Pump export and import to move data Working with Support • Use the Enterprise Manager Support Workbench • Work with Oracle Support • Log service requests (SR) • Manage patches Oracle Database 11g Administration Workshop II TrainingCore Concepts and Tools of the Oracle Database • The Oracle Database Architecture: Overview • ASM Storage Concepts • Connecting to the Database and the ASM Instance • DBA Tools Overview Configuring for Recoverability • Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology • Using the Recovery Manager (RMAN) • Configuring your Database for B&R Operations • Configuring Archivelog Mode • Configuring Backup Retention • Configuring and Using a Flash Recovery Area (FRA) Using the RMAN Recovery Catalog • Tracking and Storing Backup Information • Setting up a Recovery Catalog • Recording Backups • Using RMAN Stored Scripts • Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog) Configuring Backup Settings • Configuring and Managing Persistent Settings for RMAN • Configuring Autobackup of Control File • Backup optimization • Advanced Configuration Settings: Compressing Backups • Configuring Backup and Restore for Very Large Files (Multisection) Creating Backups with RMAN • RMAN backup types • Creating and Using the following: • - Backup Sets and Image Copies • - Whole Database Backup • - Fast Incremental Backup • - Configure Backup Destinations • - Duplexed Backup Sets • - Archival Backups Restore and Recovery Task • Restoring and Recovering • Causes of File Loss • Automatic Tempfile Recovery • Recovering from the Loss of a Redo Log Group • Recovering from a Lost Index Tablespace • Re-creating a Password Authentication File • Complete and Incomplete Recovery • Other Recovery Operations Using RMAN to Perform Recovery • Complete Recovery after Loss of a Critical or Noncritical Data File • Recovering Image Copies and Switching Files • Restore and Recovery of a Database in NOARCHIVELOG Mode • Incomplete Recovery • Performing Recovery with a Backup Control File • Restoring from Autobackup: Server Parameter File and Control File • Restoring and Recovering the Database on a New Host Monitoring and Tuning RMAN • Monitoring RMAN Jobs • Balance Between Speed of Backup Versus Speed of Recovery • RMAN Multiplexing • Synchronous and Asynchronous I/O • Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION Diagnosing the Database • Data Recovery Advisor (DRA) • Block Corruption • Automatic Diagnostic Repository (ADR) • Health • Monitor • The ADR Command-Line Tool, ADRCI Using Flashback Technology I • Flashback Technology: Overview and Setup • Using Flashback Technology to Query Data • Flashback Table • Flashback Transaction Query • Performing Flashback Transaction Backout Using Flashback Technology II • Oracle Total Recall • Flashback Drop and the Recycle Bin Performing Flashback Database • Configuring Flashback Database • Performing Flashback Database Operations • Monitoring Flashback Database Managing Memory • Oracle Memory Structures • Oracle Database Memory Parameters • Using Automatic Memory Management • Automatic Shared Memory Management • Using Memory Advisors • Using Data Dictionary Views Managing Database Performance • Tuning Activities • Using Statistic Preferences • Optimizer Statistics Collection • Monitor the Performance of Sessions and Services • Automatic Workload Repository (AWR) • Describing the Benefits of Database Replay Managing Performance by SQL Tuning • SQL Tuning and SQL Advisors •

Contact Details :Dotexe Technologies, #23, South Sivan Koil Street, Vadapalani Chennai–600026,Phone:+914465485599,WWW.dotexetechnologies.com


More Details

Total Views:6
Reference Id:#663869
Phone Number:7358244331
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com