Oracle 12c Database Administration Ii

Modules / Chapter

1. Recovery Manager Configuration

• Parameters Affecting RMAN
• Use of a Flashback Recovery Area
• The CONFIGURE Command
• Persistent Settings
• NOCATALOG / CATALOG Mode
• Catalog Management / Virtual Catalog
• Channel Allocation
• ControlfileAutobackup
• Retention Policies

2. Recovery Manager Operations

• Using the BACKUP Command
• Creating Backup Sets / Image Copies
• Parallelization
• Compressed Backups
• Whole Database Copying / Cloning
• Incremental Backups
• Block Change Tracking
• RMAN Backup Monitoring
• REPORT and LIST Commands

3. Non-Critical Loss Recovery

• Password and Network Files
• Read-Only Tablespaces
• Temporary Tablespaces
• Index Tablespaces
• Redo Log Members / Control Files

4. Database Recovery

• Recovering the Control File
• Reasons for Incomplete Recovery
• Recovery after RESETLOGS
• Incomplete Recovery Using EM
• Incomplete Recovery Using RMAN
• Incomplete Recovery Using SQL

5. Flashback Database

• When to Use
• Configuration and Use
• Monitoring Flashback Database
• Using EM for Flashback Database
• Flash Recovery Area Maintenance
• Flash Recovery Area Monitoring

6. User Error Recovery

• The New Recycle Bin
• Flashback a Dropped Table Using EM
• Querying Dropped Tables
• Flashback Versions Query
• Flashback Transaction Query

7. Block Corruption Management

• DBVERIFY and ANALYZE
• DBMS_REPAIR
• Block Media Recovery
• DBMS_BLOCK_CHECKING Parameter
• Using RMAN for Block Corruption

8. Automatic Database Management

• Management and Advisory Framework
• Automatic Statistics Collection
• The Automated Workload Repository
• Database Advisors
• SQL Tuning Advisors
• SQL Access Advisors
• Active Session History (ASH)
• Automatic Statistics Collection
• Automatic Undo Retention
• Adjusting Thresholds / Managed Metrics

9. Automatic Storage Management

• ASM Architecture
• ASM Initialization Parameters
• ASM Filenames in SQL Commands
• ASM Tablespaces
• Disk Groups / Failure Groups
• ASM Startup/Shutdown / ASMCMD
• ASM Disk Group Administration

10. Globalization Support

• Timezones and Datetimes
• Language-Dependent Behavior
• Locales and Variants
• Case and Accent Insensitive Sorts
• Linguistic Sorting
• Querying GS Configuration

11. Resource Management

• Resource Manager Configuration
• Resource Consumer Groups
• Resource Plans and Directives
• Directives for Resource Allocation
• Adaptive Consumer Group Mapping
• Enabling and Switching Plans

12. Scheduler

• Creating Jobs and Job Classes
• Creating Schedules and Windows
• Scheduler Programs
• Prioritizing Jobs
• Scheduler Component Reuse
• Query Scheduler Information

13. Storage Management

• Tuning Archiving
• Redo Log Size Advisor
• Segment Advisor
• Managing Resumable Operations
• Proactive Tablespace Management
• Table/Index Size Estimation
• Optimizing Storage Options
• Online Index Rebuilds

14. Listener Security

• Password Authentication
• Securing EXTPROC
• Controlling Access

15. Diagnostic Sources

• Alert Logs and Trace Files
• Enterprise Manager and Alerts
• Controlling Trace File Size
• Alert Notification

16. Memory Management

• Memory Structures
• Automatic Shared Memory Management
• SGA configuration / SGA_TARGET
• Automatic PGA Memory Management
• The Memory Advisor

17. Performance Tuning

• Application Identification
• Enterprise Manager Tools
• SQL Tuning Advisor
• SQL Access Advisor
• DBMS_SQLTUNE
• DBMS_ADVISIOR
• Quick Tune

18. The Virtual Private Database

Labs

• Lab 1: Recovery Manager Configuration
• Lab 2: Recovery Manager Backups
• Lab 3: Database Recovery using RMAN
• Lab 4: Flashback Database
• Lab 5: Flashback for User Errors
• Lab 6: Dealing With Block Corruption
• Lab 7: Automated Management Tools
• Lab 8: Using the Scheduler
• Lab 9: Managing Storage
• Lab 10: Scheduler
• Lab 11: Listener Security
• Lab 12: Diagnostic Sources
• Lab 13: Oracle Auditing
• Lab 14: Performance Tuning