Tematy OCP część II
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
czerwiec 24th, 2010 at 14:18
Medicamentspot.com International Legal RX Medications. Special Internet Prices (up to 40% off average US price). NO PRIOR PRESCRIPTION REQUIRED!…
Combivir@buy.online” rel=”nofollow”>.…