After completing this lesson, you should be able to do the following: • Implement Transparent Data Encryption (TDE) • Use TDE with encrypted columns • Describe Data Pump (DP) encryption • Identify components of Recovery Manager (RMAN)– encrypted backups • Define basic concepts of a Virtual Private Database (VPD) • Apply a column-level VPD policy

After completing this lesson, you should be able to: • Simplify management tasks by using the Scheduler • Create a job, program, and schedule • Monitor job execution • Use a time-based or event-based schedule for executing Scheduler jobs • Use job chains to perform a series of related tasks • Use advanced Scheduler concepts to prioritize jobs

After completing this lesson, you should be able to do the following: • Configure the Database Resource Manager • Access and create resource plans • Create consumer groups • Specify directives for allocating resources to consumer groups • Map consumer groups to plans • Activate a resource plan • Monitor the Resource Manager

After completing this lesson, you should be able to: • Identify the features of Automatic Storage Management (ASM) • Set up initialization parameter files for ASM and database instances • Execute SQL commands with ASM file names • Start up and shut down ASM instances • Administer ASM disk groups • Use RMAN to migrate your database to ASM

After completing this lesson, you should be able to: • Describe how the Oracle database automatically manages space • Proactively monitor and manage tablespace space usage • Use the Segment Advisor • Reclaim wasted space from tables and indexes by using the segment shrink functionality • Manage resumable space allocation • Describe the concepts of transportable tablespaces and databases TBS and DB

After completing this lesson, you should be able to manage schema objects and: • Determine appropriate table types for your requirements: heap, partition, IOT, or cluster • Perform related DBA tasks: – Estimating the size of new tables – Analyzing growth trends – Managing optimizer statistics – Reorganizing schema objects online

After completing this lesson, you should be able to: • Diagnose database performance issues • Configure the Automatic Workload Repository • Access the database advisors • Use the SQL Access Advisor to improve database performance • Use asynchronous COMMIT effectively

After completing this lesson, you should be able to: • Describe the memory components in the SGA • Implement Automatic Shared Memory Management • Manually configure SGA parameters • Configure automatic PGA memory management

After completing this lesson, you should be able to: • Identify the causes of database corruption: – Hardware – Software • Detect database corruption by using: – ANALYZE – DBVERIFY – DB_BLOCK_CHECKING – DBMS_REPAIR • Repair corruptions by using RMAN

After completing this lesson, you should be able to: • Query the recycle bin • Configure Flashback Database • Perform Flashback Database to a point in time • Monitor flashback log statistics • Enable and disable the Flashback Database feature • Use the Enterprise Manager Recovery Wizard to perform Flashback Database • Use guaranteed restore points with Flashback Database

After completing this lesson, you should be able to: • Perform complete or incomplete user-managed recovery • Identify situations where incomplete recovery is necessary • Perform complete or incomplete recovery by using RMAN • Perform incomplete recovery based on time, SCN, log sequence, restore points, or the cancel method • Recover an automatically backed up control file • Use Enterprise Manage to perform recovery • Recover read-only tablespaces

After completing this lesson, you should be able to do the following: • Use the RMAN BACKUP command to create backup sets and image copies • Manage the backups and image copies taken with RMAN

After completing this lesson, you should be able to do the following: • Describe the RMAN repository and recovery catalog • Describe the Media Management Library interface • Configure database parameters that affect RMAN operations • Connect to the three different types of databases by using RMAN • Configure two types of retention policies • Change RMAN default settings with CONFIGURE

After completing this lesson, you should be able to do the following: • List the course objectives and explain the class structure • Review the Oracle Database 10g architecture

After completing this lesson, you should be able to do the following: • List the course objectives and explain the class structure • Review the Oracle Database 10g architecture

Tham khảo sách 'oracle database 10g: administration workshop ii', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả

Introduction Lesson Objectives 1-2 Course Objectives 1-3 Suggested Schedule 1-4 What Is Covered in the DBAI Course 1-5 Course Examples: The HR Schema 1-6 Oracle Database 10g: The Database for the Grid 1-7 Database Architecture: Review 1-8

After completing this lesson, you should be able to do the following: • Describe available ways for moving data • Create and use directory objects • Use SQL*Loader to load data from a non-Oracle database (or user files) • Explain the general architecture of Data Pump • Use Data Pump Export and Import to move data between Oracle databases • Use external tables to move data via platform- independent files

Tham khảo sách 'less17_flashback_tb3', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả

Tham khảo sách 'less16_recovery_tb3', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả