OCP - Oracle Certified Professional

Database Recovery  - odtwarzanie bazy danych
- Recover the control file
- Explain reasons for incomplete recovery
- Perform incomplete recovery using EM (enterprise manager) - recovery z EM
- Perform incomplete recovery using RMAN - używając RMAN-a
- Perform incomplete recovery using SQL - z linii poleceń, polecenia SQL

- Perform database recovery following a RESETLOGS operation

Flashback Database

- Determine which flashback technology to use for each recovery situation
- Configure and use Flashback Database
- Monitor the Flashback Database
- Use the Enterprise Manager Recovery Wizard to flashback database
- Manage (or maintain) the Flash Recovery Area

Managing Resources

- Configure the Resource Manager
- Assign users to Resource Manager groups
- Create resource plans within groups
- Specify directives for allocating resources to consumer groups

Automating Tasks with the Scheduler

- Simplify management tasks by using the Scheduler
- Create a job, program, schedule, and window
- Reuse Scheduler components for similar tasks
- View information about job executions and job instances

Monitoring and Managing Storage - zarządzanie i monitorowanie storage

- Tune redo writing and archiving operations
- Issue statements that can be suspended upon encountering space condition errors
- Reduce space-related error conditions by proactively managing tablespace usage
- Reclaim wasted space from tables and indexes using the segment shrink functionality
- Estimate the size of new table and indexes
- Use different storage options to improve the performance of queries
- Rebuild indexes online

Automating Tasks with the Scheduler - ASM

- Set up initialization parameter files for ASM and database instances
- Execute SQL commands with ASM file names
- Start up and shut down ASM instances
- Administer ASM disk groups
- Use RMAN to migrate your database to ASM

Monitoring and Managing Memory - zarządzanie i monitorowanie pamięci

- Implement Automatic Shared Memory Management
- Manually configure SGA parameters for various memory components in the SGA
- Use Automatic PGA Memory Management

Dealing with Database Corruption

- Define block corruption and list its causes and symptoms
- Detect database corruptions using the following utilities: ANALYZE DBVERIFY
- Detect database corruptions using the dbms_repair package
- Implement the DB_BLOCK_CHECKING parameter to detect corruptions
- Repair corruptions using RMAN

Automatic Database Management

- Use the Database Advisors to gather information about your database
- Use the SQL Tuning Advisor to improve database performance
- Use automatic undo retention tuning
Using Recovery Manager
- Use the RMAN BACKUP command to create backup sets and image copies
- Enable block change tracking
- Manage the backups and image copies taken with RMAN with the LIST and REPORT commands

Recovering from Non-Critical Losses

- Recover temporary tablespaces
- Recover a redo log group member
- Recover index tablespaces
- Recover read-only tablespaces
- Recreate the password file

Using Globalization Support Objectives

- Customize language-dependent behavior for the database and individual sessions
- Specify different linguistic sorts for queries
- Use datatime datatypes
- Query data using case insensitive and accent insensitive searches
- Obtain Globalization support configuration information

Configuring Recovery Manager

- Configure database parameters that affect RMAN operations
- Change RMAN default settings with CONFIGURE
- Manage RMAN’s persistent settings
- Start RMAN utility and allocate channels

Recovering from User Errors

- Recover a dropped table using Flashback technology
- Perform Flashback table operation
- Manage the recycle bin
- Recover from user errors using Flashback versions query
- Perform transaction level recovery using Flashback Transaction query

Certyfikat OCA Oracle Certified Professional oznaczony skrótem 1Z0-043 jest to drugim stopień certyfikacji dla Administratorów baz danych, egzamin taki można zdawać w certyfikowanych ośrodkach egzaminacyjnych m.in. w firmie Oracle Polska w Warszawie.

Cena takiego certyfikatu wynosi $ 125 USD.

Czas trwania to 90 minut czyli 1,5 godziny.

Ilość wszystkich pytań 70, trzeba mieć 70% pozytywnych odpowiedzi żeby zdać ten egzamin.

Do tego egzaminu można się przygotowywać z materiałów z kursy Oracle10g: Administracja II lub z przykładowych testów z tego zakresu.

Egzamin Oracle Certified Professional przeprowadzany jest w języku angielskim.