Oracle DBA
Introduction to Oracle Concepts This is a brief introduction to Oracle Concepts for the DBA. Conceptually, you can think of an Oracle database as nothing more than a large electronic filing cabinet, a place to store and retrieve information. At the computer level, Oracle is a computer program that manages an electronic filing cabinet.
- DATABASE COMPONENTS AND DEMOS
- INSTALLATION OF LINUX
- INSTALLATION OF ORACLE 11g ON LINUX
- CREATION OF 11g DATABASE ON LINUX
- UNDERSTANDING AND CONFIGURATION OF PFILE &SPFILE
- DATABASE STARTUP AND SHUTDOWN PROCEDURES
- MANAGING ALERT.LOG FILE & TRACE FILE
- BACKGROUND PROCESS
- MANAGING TABLESPACES & DATAFILES
- DATABASE USERS ADMINISTRATION
- MANAGING ONLINE REDOLOG FILE
- DATABASE ARCHIVE MANAGEMENT
- MANAGING CONTROL FILES
- BACKUPS ,RESTORE & RECOVERY
- PHYSICAL BACKUP CASE STUDIES
- LOGICAL BACKUPS(TRADITIONAL)
- ORACLE DATAPUMP
- TRANSPORTABLE TABLESPACES
- CONFIGURATION OF SQL NETPROTOCOL
- CONFIGURATION OF RMAN
- UNDERSTANDING & CONFIGURATION OF CLONE DATABASE
- CONFIGURATION OF ACTIVE DATAGUARD
- FLASHBACK TECHNOLOGIES
- CONFIGURATION OF RMAN CLONING
- PERFORMANCE TUNING
- 10G TO 11G DATABASE UPGRADATION
- DATABASE MIGRATION
- MISCELLANEOUS TOPICS
- Understanding,creation of trace files and controlfiles
- How to resize online redolog files
- How to create user profile
- Configuration of OMF(Oracle Managed Files)
- How to create tablespace without specifying a datafile
- How to enable multiblock size environment
- How to create tablespaces with different blocksize
- How to rename a datafile
- How to move a datafile
- Automatic Storage management(ASM)
- Converting non ASM to ASM
- Understanding & usage of SQL Loader
- Transportable tablespace for a single partition in Oracle Database 11g feature
- RMAN Enhancements
- Configuration of Oracle Enterprise Manager(OEM)