H2K Infosys | Oracle DBA Online Course Details

Oracle 11g features will be discussed

Details:

Installing the Oracle Database 10g

• Installing the Oracle Database 10g Software
• Explain core DBA tasks and tools
• Plan an Oracle installation
• Use optimal flexible architecture
• Install software with the Oracle Universal Installer (OUI)

Creating an Oracle 10g Database

• Creating an Oracle 10g Database
• Create a database with the DatabaseConfiguration Assistant (DBCA)
• Create a database design template with the DBCA
• Generate database creation scripts with the DBCA

Managing the Oracle Instance

• Managing the Oracle Instance
• Start and stop the Oracle database and components
• Use Enterprise Manager (EM)
• Access a database with SQL*Plus and iSQL*Plus
• Modify database initialization parameters
• Understand the stages of database startup
• View the Alert log
• Use the Data Dictionary

Managing Database Storage

• Structures
• Describe table data storage (in blocks)
• Define the purpose of tablespaces and data files
• Understand and utilize Oracle Managed Files (OMF)
• Create and manage tablespaces
• Obtain tablespace information
• Describe the main concepts and functionality of Automatic Storage
• Management (ASM)

Administering User Security

• Administering User Security
• Create and manage database user accounts
• Authenticate users
• Assign default storage areas (tablespaces)
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles
• Implement standard password security features
• Control resource usage by users

Managing Schema Objects in Oracle

• Managing Schema Objects in Oracle 10g Database
• Define schema objects and data types
• Create and modify tables
• Define constraints
• View the columns and contents of a table
• Create indexes, views and sequences
• Explain the use of temporary tables
• Use the Data Dictionary

Managing Undo Data

• Managing Undo Data
• Explain DML and undo data generation
• Monitor and administer undo
• Describe the difference between undo and redo data
• Configure undo retention
• Guarantee undo retention
• Use the undo advisor

Configuring the Oracle Network Environment

• Configuring the Oracle Network Environment
• Use Enterprise Manager for configuring the Oracle network environment
• Create additional listeners
• Create Net Service aliases
• Configure connect-time failover
• Control the Oracle Net Listener
• Test Oracle Net connectivity
• Identify when to use shared versus dedicated servers

Proactive Maintenance

• Proactive Maintenance
• Use statistics
• Manage the Automatic Workload Repository (AWR)
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe advisory framework
• Set alert thresholds
• Use server-generated alerts
• Use automated tasks

Performance Management

• Performance Management
• Use Enterprise Manager pages to monitor performance
• Use the SQL Tuning Advisor
• Use the SQL Access Advisor
• Use Automatic Shared Memory Management
• Use the Memory Advisor to size memory buffers
• Use performance related dynamic views
• Troubleshoot invalid or unusable objects

Oracle 10g Database Backup

• Oracle 10g Database Backup and Recovery Concepts
• Identify the types of failure that may occur in an Oracle Database
• Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log files
• Configure ARCHIVELOG mode

Performing Database Backups

• Performing Database Backups
• Create consistent database backups
• Back your database up without shutting it down
• Create incremental backups
• Automate database backups
• Monitor the flash recovery area

Performing Database Recovery

• Performing Database Recovery
• Recover from loss of a control file
• Recover from loss of a redo log file
• Perform complete recovery following the loss of a data file

Performing Flashback

• Performing Flashback
• Describe Flashback database
• Restore the table content to a specific point in the past with Flashback Table
• Recover from a dropped table
• View the contents of the database as of any single point in time with Flashback Query
• See versions of a row over time with Flashback Versions Query
• View the transaction history of a row with Flashback Transaction Query

Moving Data

• Moving Data
• 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

Configuring Recovery Manager

• Configuring Recovery Manager in Oracle 10g Database
• 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

Recovery Manager(RMAN)

• Using Recovery Manager(RMAN)
• 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
• 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

• 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
• 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

Monitoring and Managing Memory

• Monitoring and Managing Memory in Oracle 10g Database
• 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

Performance Management

• Automatic Performance Management
• Identifying Tunable Components
• Oracle Wait 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

• Monitoring and Managing Storage
• 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

Automatic Storage Management

• 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

Automating Tasks

• Patching, cloning, upgrade and migration
• High availability architecture
• Oracle 11g features will be covered