Oracle, Life, etc.
I’m using this site to document the work I’ve done as an Oracle DBA / Developer.
- ID Card Project
- Testing a Migration from Single Instance to RAC using Workload Capture and Replay in 11g
- Useful SQL Queries and Oracle Code
- Oracle Backup Strategy
- Oracle Recovery Strategy
- Copy AWR Reports to the Filesystem Automatically
Notes for OCP 11g Upgrade Exam. From this book.
- Installing, Upgrading and Change Management
- Diagnosing and Resolving Problems
- Intelligent Infrastructure and Security
- Automatic SQL Tuning and SQL Plan Management
- Automatic Storage Management (ASM) and Partitioning Enhancements
- Performance Enhancements
- RMAN and Flashback Enhancements
- Oracle SecureFiles and Miscellaneous New Features
From 2006. Notes for OCP 10g. From this book.
- Configuring Security for the Listener
- Getting Started with Oracle Recovery Manager (RMAN)
- Using RMAN to Backup Databases
- Diagnosing Oracle Database Issues
- Recovering from Noncritical Losses
- Incomplete Database Recovery
- Using Oracle Flashback Database
- Recovering from User Errors
- Detecting and Recovering from Database Corruption
- Tools for Oracle Database 10g Tuning
- Monitoring and Managing Storage
- Managing Storage with Automatic Storage Management
- Monitoring and Managing Memory
- Managing Oracle Database Resources
- Automating Administrative Tasks