oracle

This is an old revision of the document!

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. Scheduling & Jobs
  12. Installation & Maintenance
  13. Client connections
  14. Bugs in Oracle
  15. SQL Processing
  16. Auditing & Tracing
  17. Locks, Mutexes & Enqueues in Oracle
  18. Services
  19. 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 Server Config
  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

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
  12. Big data Integration

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
  • oracle.1605804860.txt.gz
  • Last modified: 2020/11/19 16:54
  • by andonovj