Oracle Database 12c/18c/19c Administration Workshop II

Day 1

• Lesson 1 : Database Architecture and ASM
• Lesson 2 : Configuring for Recoverability
• Lesson 3 : Using the RMAN Recovery Catalog
• Lesson 4 : Configuring Backup Specifications

Day 2

• Lesson 5 : Using RMAN to Create Backups
• Lesson 6 : Performing User-Managed Backup and Recovery
• Lesson 7 : Using RMAN to Perform Recovery
• Lesson 8 : Using RMAN to Duplicate a Database

Day 3

• Lesson 9 : Performing Tablespace Point-in-Time Recovery
• Lesson 10 : Monitoring and Tuning RMAN
• Lesson 11 : Using Flashback Technology
• Lesson 12 : Additional Flashback Operations

Day 4

• Lesson 13 : Diagnosing the Database
• Lesson 14 : Managing Memory
• Lesson 15 : Managing Database Performance
• Lesson 16 : Space Management

Day 5

• Lesson 17 : Managing Resources
• Lesson 18 : Automating Tasks with the Scheduler
• Lesson 19 : Administering the Scheduler
• Lesson 20 : Globalization

Lesson 1 : Database Architecture and ASM

• Describe the Oracle Database architecture
• Describe Automatic Storage Management (ASM)
• Set up initialization parameter files for ASM and database instances
• Start up and shut down ASM instances
• Administer ASM disk groups

Lesson 2 : Configuring for Recoverability

• Invoke RMAN and set and list simple configurations
• Configure your database in ARCHIVELOG mode
• Configure multiple archive log file destinations to increase availability
• Specify a retention policy
• Configure the Flash Recovery Area
• Describe the benefits of using the Flash Recovery Area

Lesson 3 : Using the RMAN Recovery Catalog

• Contrast the usage of a recovery catalog with that of the control file for the RMAN repository
• Create and configure a recovery catalog
• Register a database in the recovery catalog
• Synchronize the recovery catalog
• Use RMAN stored scripts
• Back up the recovery catalog
• Create a virtual private catalog

Lesson 4 : Configuring Backup Specifications

• Use Enterprise Manager to configure backup settings
• Enable control file autobackup
• Allocate channels to use in backing up
• Configure backup optimization

Lesson 5 : Using RMAN to Create Backups

• Create image file backups
• Create a whole database backup
• Create a full database backup
• Enable fast incremental backup
• Create duplex backup sets
• Back up a backup set
• Create an archival backup for long-term retention
• Create a multisection backup
• Create a compressed backup
• Create an encrypted backup
• Report on and maintain backups

Lesson 6 : Performing User-Managed Backup and Recovery

• Describe the difference between user-managed and server-managed backup and recovery
• Manually back up a data file, tablespace, and database
• Back up and recover a control file
• Perform user-managed complete database recovery
• Perform user-managed incomplete database recovery
• Recover from a lost TEMP file
• Recover from a lost redo log group

Lesson 7 : Using RMAN to Perform Recovery

• Perform complete recovery when a critical or noncritical data file is lost
• Recover using incrementally updated backups
• Switch to image copies for fast recovery
• Restore a database onto a new host
• Recover using a backup control file

Lesson 8 : Using RMAN to Duplicate a Database

• List the purposes of creating a duplicate database
• List the methods of duplicating a database
• Duplicate a database using RMAN Use an RMAN backup to duplicate a database
• Duplicate a database based on a running instance

Lesson 9 : Performing Tablespace Point-in-Time Recovery

• List what operations occur when you perform tablespace point-in-time recovery (TSPITR)
• Define the terminology used with TSPITR
• Identify the circumstances where TSPITR is a good solution
• Determine the correct target time for the point-in-time recovery
• Identify those situations where TSPITR cannot be used, and how to work around them
• Perform automated TSPITR

Lesson 10 : Monitoring and Tuning RMAN

• Monitor the progress of RMAN jobs
• Configure RMAN appropriately for asynchronous I/O
• Configure RMAN multiplexing so as to keep tape drives streaming efficiently
• Evaluate the balance between speed of backup versus speed of recovery
• Explain the effect of the following parameters on RMAN performance: MAXPIECESIZE, FILESPERSET, MAXOPENFILES
• Explain how the RMAN BACKUP DURATION option can cause backups to either execute faster or take longer, (freeing up resources for other processing)

Lesson 11 : Using Flashback Technology

• Query the recycle bin
• Restore dropped tables from the recycle bin
• Perform Flashback Query
• Use Flashback Version Query
• Use Flashback Transaction Query
• Use Flashback Transaction

Lesson 12 : Additional Flashback Operations

• Enable row movement on a table
• Perform Flashback Table operations
• Configure Flashback Database
• Perform Flashback Database operations
• Monitor Flashback Database
• Set up and use a Flashback Data Archive

Lesson 13 : Diagnosing the Database

• Set up Automatic Diagnostic Repository
• Use and monitor Support Workbench
• Run health checks
• Identify the causes of database corruption:
  • Hardware
  • Software
• Detect and repair database corruption

Lesson 14 : Managing Memory

• Describe the memory components in the SGA
• Implement Automatic Memory Management
• Manually configure SGA parameters
• Configure automatic PGA memory management

Lesson 15 : Managing Database Performance

• Monitor the performance of sessions and services
• Use the SQL Tuning Advisor to:
  • Identify SQL statements that are using the most resources
  • Tune SQL statements that are using the most resources
• Use the SQL Access Advisor to tune a workload
• Describe the benefits of Database Replay

Lesson 16 : Space Management

• Describe how the Oracle database server 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

Lesson 17 : Managing Resources

• 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

Lesson 18 : Automating Tasks with the Scheduler

• 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

Lesson 19 : Administering the Scheduler

• Incorporate advanced Scheduler concepts
  • Windows
  • Window groups
  • Job classes
  • Consumer groups
• Use job chains to perform a series of related tasks
• Use advanced Scheduler concepts to prioritize jobs

Lesson 20 : Globalization

• Determine a correct database character set that meets your business requirements
• Obtain globalization support configuration information
• Customize language-dependent behavior for the database and individual sessions
• Specify different linguistic sorts for queries
• Retrieve data that matches a search string ignoring case or accent differences