Course Objectives - * Use RMAN to create and manage backup sets and image copies * Recover the database to a previous point in time * Use Oracle's Flashback technology to recover your database * Detect block corruptions and take appropriate measures to correct them * Use the various Database advisors and views to monitor and improve database performance * Control database resource usage with the Resource Manager * Simplify management tasks by using the Scheduler * Improve the security of the listener * Review database log files for diagnostic purposes * Customize language-dependent behavior for the database and individual sessions

Topics Covered

1. Using Globalization Support • Datetimes with Timezones • Specifying Language-Dependent Behavior • Locale Variants • Linguistic Sorting • Case and Accent Insensitive Sorts • Linguistic Comparisons • Obtaining Information about the Current NLS Configuration 2. Securing the Oracle Listener • Listener Password Authentication • Controlling Database Access • Securing the EXTPROC Service Entry 3. Configuring Recovery Manager • Using a Flash Recovery Area with RMAN • Setting Parameters for RMAN • Starting RMAN • Configuring Persistent Settings for RMAN • Control File Autobackups • Retention Policies 4. Using Recovery Manager • Issuing Recovery Manager Commands • Parallelization of Backup Sets • Compressed Backups • Copying the Whole Database • Making Incremental Backups • Block Change Tracking • Incrementally Updating Backups • Monitoring RMAN Backups 5. Diagnostic Sources • The Alert Log • Viewing Alerts with EM • Alerts Notification • Editing Thresholds • Trace Files 6. Recovering from non-critical losses • Creating New Temporary Tablespace • Recreating Redo Log Files • Recovering an Index Tablespace • Read-Only Tablespace Recovery • Loss of Password Authentication File 7. Database Recovery • Recovery Steps • User-Managed Recovery Procedures: RECOVER Command • Types of incomplete recovery • Incomplete Recovery Best Practices • Recovery Using EM • Simple Recovery Through RESETLOGS • Point-in-time recovery using RMAN 8. Flashback database • When to Use Flashback Technology • Configuring Flashback Database • Monitoring Flashback Database • Best Practices for the Database and Flash Recovery Area • Flash Recovery Area Space Usage • Flashback Database Examples 9. Recovering from User Errors • Recycle Bin • Flashback Dropped Tables Using EM • Querying Dropped Tables • Flashback Versions Query • Flashback Transaction Query • Using Flashback Versions Query and Flashback Transaction Query • Flashback Table • Using EM To Flashback Tables 10. Dealing with Database Corruption • What is block corruption? • Interpreting DBVERIFY • The ANALYZE command • How to Handle Corruptions • The DBMS_REPAIR Package • Block Media Recovery (BMR) • Detecting Database Corruptions Using DBVERIFY • Using RMAN to Repair Corrupt Blocks 11. Automatic Database Management • Automatic Optimizer Statistics Collection • Workload Repository • Database Control and Advisors • Using the SQL Tuning Advisor • Using the SQL Access Advisor • Automatic Undo Retention Tuning 12. Monitoring and Managing Storage • Redo Logfile Size Advisor • Resumable Statements • Tablespace Space Usage Monitoring • Accessing the Segment Advisor • Shrinking Segments Using SQL • Segment Resource Estimation • Monitoring Index Space • Identifying Unused Indexes 13. Automatic Storage Management • ASM Concepts • ASM General Architecture • Creating an ASM instance • Creating tablespaces that use ASM storage • Viewing ASM information • Migrating a tablespace to use ASM storage 14. Monitoring and Managing Memory • Oracle Memory Structures • Automatic PGA Memory Management • Using the Memory Advisor • Using Automatic Shared Memory Management to avoid long running query issues 15. Managing Resources • Creating a New Resource Plan • Creating Resource Consumer Groups • Assigning Users to Resource Consumer Groups • Adaptive Consumer Group Mapping • Using Sub-Plans to limit CPU Utilization • Administering the Resource Manager • Resource Plan Directives 16. Automating Tasks with the Scheduler • Creating a Scheduler Job • Using Scheduler Programs • Creating and Using Schedules • Creating a Job Class • Prioritizing Jobs within a Window • Viewing Job Execution Details • Creating a job that runs a program outside of the database

Who should attend

* Professionals wanting to achieve OCP like * Database Administrators * Sales Consultants * Support Engineer * Project Manager * Database Designers * Technical Consultant

Pre-requisites

* Knowledge of sql * Knowledge of WS1

What you need to bring

* Photoid * Passport size photo"

Key Takeaways

* Certificate from Oracle * Training materials from Oracle * Training from Professional