oracle 10g database administration

ahana systems and solutions (p) 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 guaranteed restore points
setup and maintenance for oracle flashback database

performing complete restore and recovery of database

database restore and recovery with rman: overview
basic database restore and recovery scenarios
preparing and planning database restore and recovery
rman restore: restoring lost database files from backup

performing flashback and database point-in-time recovery

about point-in-time recovery and flashback features
oracle flashback query: recovering at the row level
oracle flashback5?: returning individual5?s to past states
oracle flashback drop: undo a drop5? operation
reversing database changes with flashback database
performing database point-in-time recovery

...''

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.

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.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.