|
Oracle9i Database: Fundamentals
II
Exam Number: 1Z0-032
Associated Certifications: Oracle9i DBA OCP
Exam Price: $125.00 USD
Duration: 120 minutes
Passing Score: 66%
Networking Overview
Explain solutions included with Oracle9i for managing
complex networks
Describe Oracle networking add-on solutions
Basic Oracle Net Architecture
Explain the key components of the Oracle Net layered
architecture
Explain Oracle Net Services role in client server
connections
Describe how web client connections are established
through Oracle networking products
Basic Net Server-Side Configuration
Identify how the listener responds to incoming connections
Configure the listener using Oracle Net Manager
Control the listener using the Listener Control Utility
(lsnrctl)
Describe Dynamic Service Registration
Configure the listener for IIOP and HTTP connections
Basic Oracle Net Services Client-Side Configuration
Describe the difference between host naming and local
service name resolution
Use Oracle Net Configuration Assistant to configure:
Host Naming, Local naming method, Net service names
Perform simple connection troubleshooting
Usage and Configuration of the Oracle Shared Server
Identify the components of the Oracle Shared Server
Describe the Oracle Shared Server architecture
Configure the Oracle Shared Server
Identify and explain usefulness of related dictionary
views
Backup and Recovery Overview
Describe the basics of database backup, restore and
recovery
List the types of failure that may occur in an Oracle
environment
Define a backup and recovery strategy
Instance and Media Recovery Structures
Describe the Oracle processes, memory structures,
and files relating to recovery
Identify the importance of checkpoints, redo log files,
and archived log files
Describe ways to tune instance recovery
Configuring the Database Archiving Mode
Describe the differences between Archivelog and Noarchivelog
modes
Configure a database for Archivelog mode
Enable automatic archiving
Perform manual archiving of logs
Configure multiple archive processes
Configure multiple destinations, including remote
destinations
Oracle Recovery Manager Overview and Configuration
Identify the features and components of RMAN
Describe the RMAN repository and control file usage
Describe channel allocation
Describe the Media Management Library interface
Connect to RMAN without the recovery catalog
Configure the RMAN environment
User-Managed Backups
Describe user-managed backup and recovery operations
Discuss backup issues associated with read tablespaces
Perform closed database backups
Perform open database backups
Back up the control file
Perform cleanup after a failed online backup
Use the DBVERIFY utility to detect corruption
RMAN Backups
Identify types of RMAN specific backups
Use the RMAN BACKUP command to create sets
Back up the control file
Back up the archived redo log files
Use the RMAN COPY command to create image copies
User-Managed Complete Recovery
Describe media recovery
Perform recovery in Noarchivelog mode
Perform complete recovery in Archivelog mode
Restore datafiles to different locations
Relocate and recover a tablespace by using archived
redo log files
Describe read-only tablespace recovery
RMAN Complete Recovery
Describe the use of RMAN for restoration and recovery
Perform recovery in Noarchivelog mode
Perform complete recovery in Archivelog mode
Restore data files to different locations
Reloate and recover a tablespace by using archived
redo log files
User-Managed Incomplete Recovery
Describe the steps of incomplete recovery
Perform an incomplete database recovery
Identify the loss of current online redo log files
RMAN Incomplete Recovery
Perform an incomplete database recovery using UNTIL
TIME
Perform an incomplete database recovery using UNTIL
SEQUENCE
RMAN Maintenance
Perform cross checking of backups and copies
Update the repository when backups have been deleted
Change the availability status of backups and copies
Make a backup or copy exempt from the retention policy
Catalog backups made with operating system commands
Recovery Catalog Creation and Maintenance
Describe the contents of the recovery catalog
Create the recovery catalog
Maintain the recovery catalog by using RMAN commands
Use RMAN to register, resynchronize, and reset a database
Query the recovery catalog to generate reports and
lists
Create, store, and run scripts
Describe methods for backing up and recovering the
recovery catalog
Transporting Data Between Databases
Describe the uses of the Export and Import utilities
Describe Export and Import concepts and structures
Perform simple Export and Import operations
List guidelines for using Export and Import
Loading Data into a Database
Demonstrate usage of direct- load insert operations
Describe the usage of SQL*Loader
Perform basic SQL*Loader operations
List guidelines for using SQL*Loader and direct-load
insert
|
