oracle 10g database administration

ahana systems and solutions pvt ltd
bangalore, india

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: chidanandamurthy

Course Description:

'' oracle 10g database administration

* oracle 10g database administration - i
* oracle 10g database administration - ii

oracle 10g database administration - i

course contents:

basic database administration
* overview of administering an oracle database
* types of oracle database users
* tasks of a database administration
* database architecture

oracle architecture
* oracle logical storage structures
* oracle logical database structures
* oracle physical storage structures
* multiplexing database files
* oracle memory structures

creating an oracle database
* deciding how to create an oracle database
* manually creating an oracle database
* understanding the create database statement
* understanding initialization parameters
* troubleshooting database creation
* dropping a database
* managing initialization parameters using a server parameter file

starting up and shutting down
* starting up a database
* altering database availability
* shutting down a database
* quiescing a database
* suspending and resuming a database

managing oracle database processes
* about dedicated and shared server processes
* configuring oracle database for shared server
* about oracle database background processes

managing control files
* guidelines for control files
* creating control files
* troubleshooting after creating control files
* backing up control files
* recovering a control file using a current copy
* dropping control files

managing the redo log
* basic working of redo log
* planning the redo log
* creating redo log groups and members
* relocating and renaming redo log members
* dropping redo log groups and members

managing archived redo logs
* what is the archived redo log?
* choosing between noarchivelog and archivelog mode
* controlling archiving
* specifying the archive destination
* specifying the mode of log transmission
* managing archive destination failure

managing5?spaces
* guidelines for managing5?spaces
* creating5?spaces
* altering5?space availability
* using read-only5?spaces
* renaming5?spaces
* dropping5?spaces
* managing the sysaux5?space
* viewing5?space information

managing datafiles and tempfiles
* guidelines for managing datafiles
* creating datafiles and adding datafiles to a5?space
* changing datafile size
* altering datafile availability
* renaming and relocating datafiles
* dropping datafiles
* copying files using the database server

managing the undo5?space
* what is undo?
* introduction to automatic undo management
* setting the undo retention period
* sizing the undo5?space
* managing undo5?spaces

using oracle-managed files
* what are oracle-managed files?
* enabling the creation and use of oracle-managed files
* creating oracle-managed files



oracle 10g database administration - ii

course contents:

using automatic storage management
* what is automatic storage management?
* overview of the components of automatic storage management
* administering an automatic storage management instance
* administering automatic storage management disk groups
* using automatic storage management in the database

managing schema objects
* creating multiple5?s and views in a single operation
* analyzing5?s, indexes and clusters
* truncating5?s and clusters
* renaming schema objects

managing space for schema objects
* managing space in data blocks
* managing storage parameters
* managing resumable space allocation

managing5?s
* about5?s
* guidelines for managing5?s
* creating5?s
* loading5?s
* automatically collecting statistics on5?s
* altering5?s
* redefining5?s online
* using flashback drop and managing the recycle bin
* managing index-organized5?s
* managing external5?s

managing indexes
* about indexes
* gidelines for managing indexes
* creating indexes
* altering indexes
* monitoring space usage of indexes
* dropping indexes

managing partitioned5?s and indexes
* about partitioned5?s and indexes
* partitioning methods
* creating partitioned5?s
* maintaining partitioned5?s
* dropping partitioned5?s

managing clusters
* about clusters
* guidelines for managing clusters
* creating clusters
* altering clusters
* dropping clusters

managing users
* create database users
* assign roles & privileges
* sysdba & sysoper privileges
* create and assign profiles
* set resource limits for profiles

loading and unloading data
* introduction to the data pump architecture
* benefits of data pump technology
* using data pump export and import
* monitoring a data pump job
* creating external5?s for data population
* defining external5? properties

manageability infrastructure
* the automatic workload repository (awr)
* active session history (ash)
* server-generated alerts
* the automated tasks feature
* the management advisory framework

the oracle scheduler and the database resource manager
* simplifying management tasks using the scheduler
* managing the basic scheduler components
* managing advanced scheduler components
* managing scheduler attributes

backup and recovery enhancements
* using the flash recovery area
* using incremental backups
* enhanced rman commands
* miscellaneous backup and recovery enhancements

flashback technology enhancements
* general flashback technology considerations
* flashback drop
* flashback5?
* row level flashback features

oracle net
* overview of oracle net
* connect descriptors
* listeners
* using the oracle net configuration assistant
* configuring the listener
* using the oracle net manager
* starting the listener server process
* directory naming with oracle internet directory

backup and recovery overview
* backup and recovery basic concepts
* the database recovery process: basic concepts
* forms of data recovery
* backup and recovery with rman
* oracle flashback technology: alternatives to point-in-time recovery

setting up and configuring backup and recovery
* using rman to start up and shut down databases
* setting up a database for rman backup
* setting up a flash recovery area for rman

backing up databases using rman
* specifying options affecting output of the rman backup command
* backing up database files and archived logs with rman
* using rman to validate database files
* listing rman backups, archived logs and database incarnations
* reporting on backups and database schema

data protection with restore points and flashback database
* restore points and flashback database: concepts
* using normal and guar ...''

Elements of this syllabus are subject to change.

Phone:91 80-26675891

School Address/Venue(s):

105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore �560050

Jobs & Resumes: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore

Search other schools for oracle 10g database administration training resources.

oracle 10g rac
Oracle DataGaurd
Oracle 11i Application DBA
SQL Server 2005
sql server 2005 - performance tuning and optimisation
SQL Server 2005: Analysis Services
SQL Server 2005: Integration Services
sql server 2005: reporting services
sql server 2005: developer

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.