Tematy OCP część II
piątek, czerwiec 20th, 2008
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