Oracle DBA
Course Name: Oracle DBA
Duration : 40 Hours
Faculty: Real time experience
Our trainers have real time experience in various MNCs. We are providing best online training on Oracle apps.
Course content:
Course Topics:
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 obtool 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 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 BigfileTablespaces
- 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 setup
- 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