In this course, you will gain hands-on experience with:

• Advanced backup and recovery concepts
• Implementing a backup and recovery strategy
• Employing database monitoring practices
• Basic database tuning
• Scheduling of tasks

В программе курса:

• Using Globalization Support.

Database Character Sets and National Character Sets. Datetimes with Timezones. Configuring the Database Local Timezone. Configuring Datetime Formats. Specifying Language-Dependent Behavior for the Server. Language and Territory Dependent Parameters. Other NLS Server Parameters. Specifying Language-Dependent Behavior for the Session. Using NLS Parameters in SQL Functions. Linguistic Sorting. Linguistic Index Support. Character Set Scanner Utilities. Data Conversion Between Client and Server Character Sets. NLS Data Conversion with Oracle Utilities. Obtaining Character Set Information. Obtaining NLS Settings Information.

• Controlling Access to the Oracle Listener.

Oracle Net Services Review. Listener Password Authentication. Setting Listener Password. Oracle Net Services External Procedures. Overview of the EXTPROC Agent. Modifying the Configuration for External Procedure Calls. Configure a Dedicated Listener for External Procedure Calls.

• Configuring Recovery Manager.

Recovery Manager Features. Recovery Manager Components. Media Management. Using a Flash Recovery Area with RMAN. Setting Parameters for RMAN. Connection Types with RMAN. Additional RMAN CommandLine Arguments. Configuring RMAN Settings Using EM. Channel Allocation.

• Using Recovery Manager.

Issuing Recovery Manager Commands. RMAN Commands. The BACKUP Command. Image Copy. BACKUP Options. Backing Up Archived Redo Logs. Copying the Whole Database. Making Incremental Backups. Block Change Tracking. Managing Backups with EM. RMAN Dynamic Views. Monitoring RMAN Backups.

• Diagnostic Sources.

Diagnostic Files. Alert Models Architecture. Server-Generated Alert Types. Viewing Alerts with Enterprise Manager. Alerts Notification. Alert Log Monitoring Configuration. Trace Files. Specifying the Location of Trace Files. System Log Files.

• Recovering from Noncritical Losses.

Recovery of Noncritical Files. Creating New Temporary Tablespace. Re-creating Redo Log Files. Recovering an Index Tablespace. Read-only Tablespace Recovery. Authentication Methodsfor Database Administrators. Loss of Password Authentication File.

• Database Recovery.

Recovery Steps. Server Managed Recovery:RESTORE and RECOVER Commands. Recovering a Control File Autobackup. Incomplete Recovery Overview. Types of Incomplete Recovery. Using RECOVER for Incomplete Recovery. UNTIL TIME Recovery Steps. Cancel-Based Recovery. Incomplete Recovery of a DatabaseUsing RMAN. Recovery UNTIL SEQUENCE. Recovery Using Enterprise Manager. Simplified Recovery Through RESETLOGS.

• Flashback Database.

Flashback Any Error. When to Use Flashback Technology. Flashback Database Architecture. Configuring Flashback. Database. Configure Flashback Database with EM. Monitoring Flashback Database. Monitoring Flashback Database with EM. Monitoring Flash Recovery Area with EM. Flashback Database Considerations.

• Recovering from User Errors.

Flashback Time Navigation. Recycle Bin. Querying the Recycle Bin. Flashback Dropped Tables Using EM. Restoring Objects from the Recycle Bin. Recycle Bin Automatic Space Reclamation. Recycle Bin Manual Space Reclamation. Querying Dropped Tables. Flashback Versions Query Overview. Flashback Transaction Query Overview. Rolling Back a Flashback Table Operation. Guaranteed Undo Retention. SCN and Time Mapping Enhancements.

• Dealing with Database Corruption.

Block Corruption. DBVERIFY Utility. The ANALYZE Command. Using Flashback for Logical Corruption. The DBMS_REPAIR Package Block Media Recovery (BMR). RMAN BMR Interface.

• Automatic Management.

Oracle Wait Events. System Statistics. Session-Related Statistics. Statistics Collection. Automatic Optimizer Statistics. Collection. Dictionary and Special Views. Statspack. Workload Repository. AWR Snapshot Baselines. Advisory Framework Overview. Typical Advisor Tuning Session. SQL Tuning Advisor Overview. The Undo Advisor.

• Monitoring and Managing Storage.

Online Redo Log File Configuration. Redo Logfile Sizing Advisor. Increasing the Performance of Archiving. Using Resumable Space Allocation. Resuming Suspended Statements. Proactive Tablespace Monitoring Overview. Tablespace Space Usage Monitoring. Segment Advisor Overview. Accessing the Segment Advisor. Shrinking Segments Using SQL. Segment Resource Estimation. Growth Trend Report. Monitoring Index Space. Identifying Unused Indexes. Index-Organized Tables. IOT Row Overflow. Querying DBA_TABLES for IOT Information. Querying DBA_INDEXESand DBA_SEGMENTS for IOT information. Maintaining a Mapping Table. Clusters. Cluster Types.

• Automatic Storage Management.

ASM Key Features and Benefits. ASM Concepts. ASM General Architecture. ASM Instance Functionalities. ASM Instance Creation. ASM Instance Initialization Parameters. Accessing an ASM Instance. Dynamic Performance View Additions. Starting Up and Shuting Down an ASM Instance. ASM Disk Groups. Failure Group. Disk Group Mirroring. Disk Group Dynamic Rebalancing. Monitoring Long-Running Operations Using V$ASM_OPERATION. ASM Files. ASM Filenames. ASM File Name Syntax. ASM File Name Mapping. ASM File Templates and Alias. SQL Commands and File Naming. Database Instance Parameter Changes.

• Monitoring and Managing Memor.

Oracle Memory Structures. Buffer Cache. Using Multiple Buffer Pools. Shared Pool. Large Pool. UGA and Oracle Shared Server. Java Pool. The Redo Log Buffer. Automatic Shared Memory Management. SGA Tuning Principles. Database Control andAutomatic Shared Memory Management. Manual Configuration. Behavior of Auto-Tuned SGA Parameters. Program Global Area (PGA). Automatic PGA Memory Management. PGA Management Resources. Using the Memory Advisor.

• Managing Resource.

Database Resource Manager Concepts. The Initial Plan: SYSTEM_PLAN. Creating a New Resource Plan. Creating a Simple Plan. Oracle Enterprise Manager:Resource Manager. Active Session Pool Mechanism. Creating Resource. Consumer Groups. Assigning Users to Consumer Groups. Automatic Consumer Group Switching. Adaptive Consumer Group Mapping. Using Sub-Plans to Limit CPU Utilization. Creating a Complex Plan. Resource Allocation Methods for Resource Plans. Resource Allocation Methods for Consumer Groups. Administering the Resource Manager. Assigning Resource Manager Privileges. Setting the Resource Plan for an Instance. Viewing Resource Consumer Groups. Changing a Consumer GroupWithin a Session. Database Resource Manager Information. Resource Plan Directives. Monitoring the Resource Manager.

• Automating Tasks with the Schedule.

Scheduling Needs. Scheduler Concepts. Privileges for Scheduler Components. Creating a Scheduler Job. Calendaring Expressions. Creating and Using Schedules. Advanced Scheduler Concepts. Creating a Job Class. Job Logging. Creating a Window. Prioritizing Jobs Within a Window. Enabling and Disabling Scheduler Components. Managing Jobs. Managing Programs. Managing Schedules. Managing Windows. Window Priority. Managing Attributes of the Scheduler. Viewing Job Execution Details. Viewing Job Logs. Purging Job Logs. Data Dictionary Views.