Oracle Database 10g: Administration II Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 5 Days

Course details

The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database. Specific subjects to be considered are: Using flashback technology to recover from user errors and from database failures. Controlling resource utilization on database servers whose resource demand exceeds its capacity. Automating routine tasks and functions using the database Scheduler. Handling database corruption and even preventing such occurrences wherever possible. Utilizing diagnostic sources in troubleshooting database problems. Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database. Automatic resumption of database operations even in the face of failures and errors. User-managed and automatically managed backup strategies and database recovery operations.

Prerequisites:

Oracle Database 10g: Administration I

ORACLE FLASHBACK TECHNOLOGY :

about flashback technology
flashback query • select...as of timestamp
select...as of scn • flashback table
flashback versions query
flashback transaction query
guarantee undo retention

MANAGING RESOURCES :

database resource manager architecture
consumer groups
resource plans
automatic & adaptive consumer group mapping
enabling & monitoring the resource manager
explicit consumer group switching

AUTOMATING TASKS WITH THE DATABASE SCHEDULER (BASIC) :

scheduler architecture
manage programs
manage schedules
manage jobs

AUTOMATING TASKS WITH THE DATABASE SCHEDULER (ADVANCED) :

manage job classes
manage windows & window groups
manage chains
about events & the scheduler

GLOBALIZATION SUPPORT OBJECTIVES :

globalization settings
nls_lang
nls_language & nls_territory
date & time localization
linguistic indexes
about locale builder

HANDLING DATABASE CORRUPTION :

about database corruption
db_block_checksum
analyze...validate structure
dbverify
using dbms_repair()

DIAGNOSTIC SOURCES :

more about the trace & alert files
diagnostic highlights from em
configuring the alert log
managing policies

SECURING THE ORACLE LISTENER :

managing & monitoring the listener
secure the listener
secure external procedure calls

MONITORING & MANAGING MEMORY :

automatic shared memory management
using em & the memory advisors
monitor in memory access mode

MONITORING & MANAGING STORAGE :

about resumable space allocation
table management
using the segment advisor

MANAGING REDO LOG STORAGE & MONITORING INSTANCE RECOVERY :

about redo data
tune redo writing & archiving
more about instance recovery
log_checkpoints_to_alert flashback database
about flashback database
configuring the flash recovery area
performing database flashback
monitoring

FLASHBACK PERFORMANCE :

flashback database considerations

CONFIGURING RMAN :

about database backup & recovery structures
rman architecture
launch & use rman
configure rman
allocate rman channels

BACKUP WITH RMAN :

about backup file types
performing full backups
performing incremental backups
establishing a backup retention policy
generate catalog reports
report unrecoverable
report need backup
report schema
list incarnation

BACKUP WITH RMAN USING EM :

monitoring the flash recovery area
about em & rman
scheduling backups with rman
manage current backups
backup reports
manage restore points

NON-CRITICAL RECOVERY OPERATIONS :

about the recovery process
recover temporary tablespaces
recover read-only tablespaces
recover index tablespaces
recover redo log group member

recreate the password file

DATABASE RECOVERY OPERATIONS :

control file recovery
complete media recovery
incomplete media recovery
performing block media recovery
recovery using em

AUTOMATIC STORAGE MANAGEMENT :

asm and the broader database architecture
defining an asm instance
configuring storage in the asm instance

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Administration and Secretarial jobs in Ireland

Are you from Professional Training Solutions Ltd ? Claim your course!

Courses you can instantly connect with... Do an online course on Administration and Secretarial starting now.