OCP - Oracle Certified Professional

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

Tags: ANALYZE DBVERIFY, Automatic Database Management, DB_BLOCK_CHECKING, Dealing with Database Corruption, password file, recover index tablespace, recover redo log, Recovering from Non-Critical Losses, rman backup, sql tuning advisor, tablespace

This entry was posted on piątek, czerwiec 20th, 2008 at 23:26 and is filed under OCP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.