EXAMS: WHAT TO KNOW
• Relates to: Oracle9i DBA OCP
This Cramsession prepares you for the Oracle 9i certification
exam #1Z0-032, “DBA Fundamentals II.” Passing this exam, plus
three other tests, makes you an Oracle9i Certified Database Administrator
(called an “OCP” or an “OCP-DBA”).
The two broad areas this exam covers are Oracle network
administration, and database backup and recovery.
Network administration includes:
- The Oracle Net architecture
- How to configure Oracle clients (the
hostnaming and localnaming methods)
- How to configure Oracle servers
- How
to configure the shared server option
- Network troubleshooting
Backup and recovery includes:
- Understanding how Oracle tracks and applies database updates
- The kinds
of failure that can occur with databases
- Proper responses to those
failures
- How to configure the database archive log mode
- How to backup
and recover databases
- How to install and configure the Recovery Manager
(RMAN)
- How to use RMAN in backup and recovery
- How to use tools for
recovery from user error (LogMiner, Flashback Query, and Export/Import
utilities)
- Which dictionary views contain backup and recovery
information
What you should know to pass this test:
Understand the architecture of Oracle Net (called Net8 or
SQL*Net in prior releases).
Know how to configure Oracle clients, servers, and the shared
server option. Especially understand the different configuration options for
clients and how to set up each. Know how to debug Oracle Net problems.
Understand the steps Oracle’s Listener takes in
responding to user requests. How do these steps differ for bequeathing and the
shared server option? What is the role of the dispatchers, and what SGA memory
areas do they use?
For backup and recovery, understand Oracle’s
architecture and how the database product handles database updates,
transactions, redo logs, and archived logs. Which instance background processes
have a role in these activities?
What is the difference between redo and undo records?
Know what transactions are, and how they relate to recovery
scenarios.
Know what a database checkpoint is, what background processes
are involved in it, and how it differs from a COMMIT.
Understand RMAN’s purpose and benefits, and when to use
an RMAN catalog. Also be familiar with the RMAN commands, and installation and
maintenance procedures.
Know how to backup a database, with and without RMAN.
Know how to perform complete and incomplete database recovery
with and without RMAN.
Know the differences between ARCHIVELOG and NOARCHIVELOG mode
databases. What are the advantages of each, and how do they differ when it
comes to recovery?
Understand when you must shutdown a database to recover it,
versus when you can do a “database-up” recovery.
What is the difference between “restore” and
“recovery”? What is the role of the redo and archive logs in
recovery? When can you recover without logs versus when are they
required?
Understand the roles of LogMiner and Oracle Flashback Query in
recovering from user error.
Understand the role and uses of the Export and Import
utilities. How do they complement physical database backups and recoveries?
Know the main Export and Import commands.
What is the DB_VERIFY utility and how is it used?
Be prepared to answer questions about which data dictionary
views you would query to locate backup and recovery information.
|
Email this Article
Print this Article
