oracle

Basic Management

  1. Pre-Install and Install
  2. Backup, Recovery, RMAN
  3. Tablespaces, Datafiles & FS
  4. Log management
  5. Undo
  6. Memory
  7. Performance monitoring & tuning
  8. Tables, Indexes, Objects
  9. Network & Listeners
  10. Security & Users
  11. Installation & Maintenance
  12. Client connections
  13. Bugs in Oracle
  14. SQL Processing
  15. Auditing & Tracing
  16. Locks, Mutexes & Enqueues in Oracle
  17. Services
  18. DBFS Management

Backup & Recovery

Backup

  1. Set up Backup
  2. Backup mode
  3. Set up RMAN Catalog
  4. Duplication

Restore & Recovery

  1. Overview
  2. Lost init File
  3. Lost Control File
  4. Lost Redo log File
  5. Lost Archivelog File
  6. Cross Incarnation Restore

Exadata

  1. Overview & Initial Config
  2. Storage Cell Server
  3. Management
  4. Monitoring
  5. Backup & Recovery
  6. Patching

Grid Infrastructure

  1. Pre-installation Tasks
  2. Patching
  3. Upgrade
  4. Backup and Restore of the OCR and Voting Disks
  5. Troubleshooting
  6. Procedures

Data Guard

  1. Overview & Physical Standby Configuration
  2. Logical Data Guard
  3. Management
  4. Broker Configuration
  5. Troubleshooting
  6. MAA Upgrade

RAC Database

  1. Installation & Configuration
  2. Instance Addition & Removal
  3. Application Continuity
  4. RAC Database Upgrade
  5. Migration From Single Instance to RAC Database
  6. MAA Configuration

Enterprise Manager

  1. Database Control
  2. Grid/Cloud Control
  3. Errors

Unified Directory

  1. Overview
  2. Standalone Installation
  3. Colocated Installation
  4. OUDSM installation & Configuration
  5. Management
  6. Troubleshooting

Golden Gate

  1. Installation
  2. Management
  3. GoldenGate for Big Data Installation & Configuration
  4. ActiveMQ Handler
  5. Hadoop HDFS Handler
  6. Hadoop HBase Handler
  7. Apache Flume Handler
  8. Apache Kafka Handler
  9. Apache Cassandra Handler
  10. MongoDB Handler
  11. Generic JDBC Handler

Multitenant

  1. Overview & Installation
  2. PDB Management
  3. Application Container
  4. Troubleshooting

NoSQL

  1. Overview & Installation
  2. Configuration
  3. Import from Mongo

Procedures

  1. Direct Upgrade to 12c from 11g with duplicate
  2. Upgrade to 12c from 10.2.0.3
  3. Upgrade to 12cR2 from 10.2.0.5
  4. Migrate ASM to FileSystem
  5. Dump to CSV using trigger after Insert
  6. Enable NFS Direct
  7. Automatic User Password Management
  8. Force Open
  9. Migrate datafile from different OS
  10. Create Wallet & Certificates for SSL/TLS
  11. Import CSV Data
  12. Rename a database
  • oracle.txt
  • Last modified: 2022/12/16 12:00
  • by andonovj