Delegates will learn how to:

• Use RMAN to create and manage backup sets and image copies
• Recover the database to a previous point in time
• Use Oracle Secure Backup to backup and recover a database
• 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
• Review database log files for diagnostic purposes
• Customize language-dependent behavior for the database and individual sessions
• Administer a VLDB
• Implement a secure database
• Transport data across platforms

• Introduction: Grid Computing; Oracle Enterprise Manager 10g Product Controls; Database Architecture Review
• Configuring Recovery Manager: Recovery Manager Features and Components; Using a Flash Recovery Area with RMAN; Configuring RMAN; Control File Autobackups; Retention Policies and Channel Allocation; Using Recovery Manager to connect to a target database in default NOCATALOG mode; Displaying the current RMAN configuration settings; Altering the backup retention policy for a database
• Using Recovery Manager: RMAN Command Overview; Parallelization of Backup Sets; Compressed Backups; Image Copy; Whole Database and Incremental Backups; LIST and REPORT commands; Enable ARCHIVELOG mode for the database; Use Recovery Manager
• Oracle Secure Backup: Installation and Configuration; Implement the Oracle suggested strategy; RMAN and Oracle Secure Backup; Database and File-system files backup/restore to tape; Using webtool and web interface to configure Oracle Secure Backup devices (CLI/GUI); Configuring EM for Oracle Secure Backup and test backup to tape (EM); Using RMAN to backup your database to tape (CLI); Using the OB Web tool to backup file system files
• Recovering from Non-critical Losses: Recovery of Non-Critical Files; Creating New Temporary Tablespace; Recreating Redo Log Files, Index Tablespaces, and Indexes; Read-Only Tablespace Recovery; Authentication Methods for Database Administrators; Loss of Password Authentication File; Creating a new temporary tablespace; Altering the default temporary tablespace for a database
• Incomplete Recovery: Recovery Steps; Server and User-Managed Recovery commands; Recovering a Control File Autobackup; Creating a New Control File; Incomplete Recovery Overview; Incomplete Recovery Best Practices; Simplified Recovery Through RESETLOGS; Point-in-time recovery using RMAN
• Flashback: Flashback Database Architecture; Configuring and Monitoring Flashback Database; Backing Up the Flash Recovery Area; Using V$FLASH_RECOVERY_AREA_USAGE; Flashback Database Considerations; Using the Flashback Database RMAN interface; Using Flashback Database EM Interface; Managing and monitoring Flashback Database operations
• Dealing with Database Corruption: Block Corruption Symptoms: ORA-1578; DBVERIFY Utility and the ANALYZE command; Initialization parameter DB_BLOCK_CHECKING; Segment Metadata Dump and Verification; Using Flashback for Logical Corruption and using DBMS_REPAIR; Block Media Recovery; RMAN BMR Interface; Dumping and Verifying Segment Metadata
• Monitoring and Managing Memory: Oracle Memory Structures; Automatic Shared Memory Management; SGA Tuning Principles; Database Control and Automatic Shared Memory Management; Behavior of Auto-Tuned and Manual SGA Parameters; Resizing SGA_TARGET; PGA Management Resources; Using the Memory Advisor
• Automatic Performance Management: Identifying Tunable Components; Oracle Wait for Events and System Statistics; Troubleshooting and Tuning Views; Direct Attach to SGA for Statistic Collection; Workload Repository; Advisory Framework; ADDM Scenarios and Usage Tips; Using the SQL Tuning and SQL Access Advisor
• Monitoring and Managing Storage I: Database Storage Structures; Space Management Overview; Oracle-Managed Files (OMF); Row Chaining and Migrating; Proactive Tablespace Monitoring; Managing Resumable Space Allocation; SYSAUX Tablespace; Monitoring table and index space usage
• Monitoring and Managing Storage II: Automatic Undo Management; Redo Log Files; Table Types; Partitioned Tables; Index-Organized Tables (IoT); Managing index space with SQL; Configure optimal redo log file size; View Automatic Tuning of Undo Retention
• Automatic Storage Management: ASM General Architecture and Functionalities; Dynamic Performance View Additions; Managing an ASM Instance; ASM Disk Groups; Using asmcmd Command-Line; Migrating Your Database to ASM Storage; Creating an ASM instance in a separate Oracle Home; Migrating a tablespace to use ASM storage
• VLDB Support: Creating Bigfile Tablespaces; Packages and data dictionary changes to support VLDB; Creating and maintaining temporary tablespace groups (TTG); Partitioning and Partitioned Indexes; Skipping unusable indexes; Creating and using hash-partitioned global indexes; DML Error Logging; Interpreting Bigfile ROWIDs
• Managing Resources: Database Resource Manager Concepts and Configuration; Creating a New Resource Plan; Active Session Pool Mechanism; Maximum Estimated Execution Time; Creating a Complex Plan; Administering and Monitoring Resource Manager; Resource Plan Directives; Creating Resource Consumer Groups
• Automating Tasks with the Scheduler: Scheduler Concepts; Creating a Job Class and a Window; Managing Jobs, Programs, Chains, Events, Schedules, priority; Viewing and Purging Job Logs; Creating a program and a schedule; Creating a job that uses a program and a schedule; Altering the program and schedule for the job and observing the behavior change of the job; Monitoring job runs
• Database Security: Virtual Private Database: Overview; Creating a Column-Level Policy; Writing a Policy Function; Policy Types; Column level VPD with column masking; Transparent Data Encryption; Setting the listener password; Implement VPD
• Data Movement: External Tables Concepts; Creating a Directory object and External Table; Data Pump; Transport Database; RMAN CONVERT DATABASE Command; Transport Tablespace; Create a Directory Object; Create a Temporary Table
• Using Globalization Support: Globalization Support Features; Encoding Schemes; Database Character Sets and National Character Sets; Specifying Language-Dependent Behavior; Locale Variants; Using Linguistic Comparison and Sorting; Data Conversion Between Client and Server Character Sets; Determining the Default NLS Settings
• Workshop: Workshop Methodology, requirements, and set up; Scenario 1: Database performance; Scenario 2: Finding and Tuning Inefficient SQL; Scenario 3: SGA Management – REDO; Scenario 4: Running out of Undo Space; Scenario 5: Missing datafile; Scenario 6: Managing space in a tablespace – REDO; Scenario 7: Missing TEMP data file

• Required Prerequisites: Knowledge of basic database administration; Oracle Database 10g: Administration Workshop I Release 2
• Suggested Prerequisites: Oracle Database 10g: SQL Fundamentals I; Oracle Database 10g: SQL and PL/SQL Fundamentals