Course Duration in Hours
90
90
Tasks of an Oracle Database Administrator
Installation of Oracle Database Software
Optimal Flexible Architecture (OFA)
Oracle Universal Installer
Prerequisite Checks
Installation
Configuration Assistants
Creating an Oracle Database
Database Architecture
Exploring the Storage Structure
Control Files
Redo Log Files
Table spaces and Data files
Segments, Extents, and Blocks
Oracle Instance Management
Oracle Memory Structures
Oracle Processes
Data Dictionary
Database Control
Grid Control
Database Configuration Assistant (DBCA) Overview
Creating a Database
Passwords and Storage
File Locations and Backup Recovery
Content and Initialization Parameters
Other Actions with DBCA
Managing the Database
Starting and Stopping iSQL*Plus
Starting and Stopping Database Control
Accessing Database Control
SYSOPER and SYSDBA
Database Home Page
Changing the Listener Status
NOMOUNT MOUNT OPEN States
SHUTDOWN Options
Initialization Parameter Files
Viewing the Alert Log
Net Services
Oracle Net Services
Oracle Net Listener
Monitoring the Listener
Listening Addresses
Static Database Registration
Listener Control Utility
Oracle Net Connections
Directory Naming
Advanced Connections
Oracle Net Manager
Configuring Service Aliases with Net Manager
Managing Schema Objects
Schemas
Accessing Schema Objects
Schema Object Namespaces
Specifying Data Types in Tables
Other Data Types
Creating and Modifying Tables
Understanding Data Integrity
Defining Constraints
Viewing the Attributes of a Table
Viewing the Contents of a Table
Creating Indexes
Creating Views
Using a Sequence
Storage Structures
Tablespaces and Data Files
Space Management in Tablespaces
Storage for Locally Managed Tablespaces
Altering a Tablespace
Actions with Tablespaces
Dropping Tablespaces
Viewing Tablespace Information
Administering Users
Database User Accounts
Creating a User
Profiles and Users
Authenticating Users
Database Users and Schemas
Privileges : System and Object
Roles
Assigning Quota to Users
Assigning Roles to Users
Managing Data
Data Pump Export
Data Pump Import
DIRECTORY Objects
Control File Syntax Considerations
Input Data and Data Files
Loading Methods
Comparing Direct and Conventional Path Loads
Loading Data with SQL*Loader
External Tables
Transportable tablespace
Undo Management
Undo Data
Transactions and Undo Data
Storing Undo Information
Monitoring Undo
Administering Undo
Configuring Undo Retention
Guaranteeing Undo Retention
Sizing the Undo Tablespace
Using the Undo Advisor
Backup and Recovery Concepts
Backup and Recovery Issues
Categories of Failures
Instance Recovery
Phases of Instance Recovery
Tuning Instance Recovery
Configuring for Recoverability
ARCHIVELOG Mode
Configuring Backup Strategy
Scheduling Backups: Review
Backup Control File to Trace
Manage Backups
Database Recovery
Opening a Database
Changing Instance Status
Keeping a Database Open
Scenarios:
Loss of a Control File
Loss of a Redo Log File
Loss of a Data File in NOARCHIVELOG Mode
Loss of a Noncritical Data File in ARCHIVELOG Mode
Loss of a System-Critical Data File in ARCHIVELOG Mode
Oracle Recovery Manager
Oracle Recovery Catalog maintenance
Backups using Oracle Recovery Manager
Recovery using Oracle recovery manager
Database Cloning using RMAN
Tablespace Point in time recovery
Incomplete recovery
many more.......
B.E/B.tech/M.S.C/M.B.A/B.S.C etc...
Feria IT Solutions, Sholinganallur (Chennai),Chennai,IN