Oracle DBA Database Administrator Online for Novice by Shree Sai Technologies

OVERVIEW OF ORACLE DATABASE & DBA TASKS
ORACLE DATABASE ARCHITECTURE
Memory Architecture
Database Files/Components
Storage/Database Architecture
Init Parameter File and SPFILE
Password File
Creation of the first Oracle database.
Startup and Shutdown of a database
SGA,PGA
Background processes
DATABASE STORAGE
Table spaces and allocation types
Data files
Control files
Redo log Files
Archive log Files
INSTANCE MANAGEMENT
Parameter files (init.ora, listener.ora, tnsnames.ora)
Rules for sizing SGA components
Automated Oracle memory management (AMM)
Initialization file management
DATABASE OBJECTS
Introduction
Tables and Columns
Indexes
Packages, Stored procedures and Functions
Database links
Views and Synonyms
Oracle Data Dictionary
Popular Data Dictionary views and accessing them
USER MANAGEMENT, ROLES & PRIVILEGES
Introduction
Databases users
User roles and privileges
User profiles and table space quotas
OS authentication vs database authentication ORACLE NETWORKING
Introduction
Oracle listener configuration
Oracle database connections from other computers
Database Links
USER MANAGED ( MANUAL) BACKUP
Introduction
Cold Backup
Database in Archive Log mode
Hot Backup
Database Cloning using COLD and HOT Backups
How to recreate source database from backups
RMAN BACKUP
Differences between RMAN method and manual method
Database backup using RMAN
Database backup using RMANs compression mode
RMAN catalog
Database backup using RMAN catalog
Querying the RMAN metadata
Database Cloning using RMAN duplicate
Introduction and overview to Backups to Tape
Flashback Database and Flash Recovery Area for better management of backups
LOGICAL BACKUP
EXP/IMP
Data pump
DATABASE RECOVERY
Database Recovery Using User Managed Backup(Different Recovery Scenarios)
Database Recovery Using RMAN Backup(Different Recovery Scenarios)
UNDO MANAGEMENT
REDO LOG FILE MANAGEMENT
ORACLE DATABASE UPGRADES & PATCHES
Introduction to Oracle versions and how to understand a version
How to upgrade from one version to another version
How to upgrade from one patch set to another patch set within a release
What are one-off patches
What is O Patch utility
ORACLE UTILITIES OVERVIEW
SQL Trace
TK Prof
Explain Plan
Log miner
PERFORMANCE TUNING
Introduction
How to handle performance issues in the real world
V$ views for performance monitoring and analysis
How to size the Oracle database and memory for optimal performance
Oracle database wait events
Explain Oracle UNDO management internals and sizing.
Explain Oracle TEMP space internals and sizing.
Index Monitoring and internals of index maintenance by Oracle
Gather optimizer statistics using DBMS_STATS
Gathering and Analyzing ADDM,AWR, ASH Reports
ORACLE DATABASE HIGH AVAILABILITY OVERVIEW
Over View of Oracle Data guard (Physical and Logical Standby)
Configuring Oracle Data guard
Different Modes of Oracle Data guard
Role Transaction of Oracle Standby Databases
Oracle Golden Gate 10G NEW FEATURES
Introduction to Oracle 10g new features
1. Sys aux Table space
2. Big file Tables pace
3. ASSM ( Automatic Segment Space Management )
4. ASMM ( Automatic Shared Memory Management )
5. New Optional BG Process
i) MMON ii) MMAN iii) CTWR
iv) RVWR v) ORB vi) LCK
vii) LTOM viii) ASMB ix) RBAL
x) ORB
6. Renaming the Table space
7. Database Drop in Mount Restrict Mode
8. Virtual Private Database
9. Undo Table space Retention Guarantee
10. Redo log File Size Advisor
11. Startup_mttr_target
12. SGA_Max_Size
13. Sga_target
14. Automatic Storage Management
15. Data pump
16. RMAN Incremental Backup
17. Incremental Update on Image Copies
18. Introducing Copy Command
19. Expired RMAN Backups
20. Automatic Workload Repository
21. Automatic Database Diagnostic Monitor
22. Automatic Diagnostic Repository
23. DBMS_JOBS
24. New ID Utility
25. Automatic Session History
26. Virual Private Catalog
27. System Activity Report
28. Dropping database including backups at
RMAN prompt
29. Transporting Multiple Table spaces across multiple platforms
30. Redo log Compressions
31. New optional memory components
ORACLE 11g NEW SAILIENT FEATURES
1. Automatic Memory Tuning
2. ADR ( Automatic Diagnostic Repository)
3. DB Replay
4. Workload Capture
5. Redo log Compression
6. Case Sensitive Password
7. Virtual Columns & Indexes
8. Interval System Partition
9. SPA ( SQL Performance Analyzer )
10. SQL Plan Management
11. SQL Plan Baselines
12. Active Data guard
13. Incremental Update on Image Copies
14. Virtual Private Catalog
15. Flash Back Data Archive ( Total Recall )
16. NAT ( New Application Testing )
17. Rolling Patches ( RAC )
18. Single Node RAC ( SCAN )
19. Hangman Utility
20. LTOM ( Linux Monitoring Utility during Disaster ) ORACLE 12C NEW FEATURES
1. Cloud Computing
2. Container Database
3. Pluggable Database
4. DDL Logging
5. Multiple Indexes on Single Column
6. Temp Undo
7. Online renaming an Active Data file
8. Online moving an Active Data file
9. Restricting PGA Size
10. RMAN Bypass Undo
11. Dropping a Database along with Backup s at RMAN Prompt

12. RMAN - Table Recovery
13. RMAN - Table space Recovery
14. DDL No wait specified
15. OEM Integration with Oracle Meta link
16. Rolling Upgrade for Clustered Instances
17. DRA ( Data Recovery Advisor )
18. Cross Platform Migration ( Table space Migration Activity )
19. Adaptive Cursor Sharing / Adaptive Query Optimization
20. OFA ( Optimal Flexible Architecture )

SOME OF THE HIGHLITES

RESUME PREPERATION
FREE PLACEMENT ASSISTANCE
30 DAYS LAB FROM THE DATE OF JOINING