Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

Oracle DBA2 - Backup and Recovery

All Notes

---

• Overview

• Recoverability

  • Fast Recovery Area
  • Multiplexing Control Files
  • Multiplexing Redo Log Files
  • Enable Archived Redo Log Files

---

• Backup

  • Backup Strategy

    • Cold Backup and Hot Backup
    • Whole Database Backup and Partial Database Backup
    • Full Backup and Incremental Backup
      • Block Change Tracking
    • Backup Additional Database Files
      • Control File
      • Archive Log Files
  • Backup Channels and Devices

  • Retention Policy

    • Archival Backups

  • Backup File

    • Backup Sets and Image Copies
    • Backups Compression
    • Multisection for Very Large Files
    • Duplexing Backup Sets
    • Proxy Copies

  • Backing Up Backup File

    • Backing Up Backupset and Image Copy
    • Backing up Recovery Data
  • Tuning Backup Performance

---

• Restore and Recovery
  • Recovery Catalog
    • Virtual Private Catalog
  • Instance Failure & Instance Recovery
  • File Loss
    • Media Recovery: Complete Recovery vs Point-in-Time Recovery
    • Complete Recovery
      • NOARCHIVELOG Mode
      • ARCHIVELOG Mode - CDB
      • ARCHIVELOG Mode - PDB
      • Using Image Copy
    • Point-in-Time Recovery
      • Incomplete Recovery(DBPITR)
      • PITR in PDB
      • Tablespace point-in-time recovery(TSPITR)
      • Table point-in-time recovery (TPITR)
  • Block Corruption & Block Media Recovery
  • Recovery Additional Database Files
    • Server Parameter File & Control File
    • NOLOGGING Database Objects
    • Redo Log
    • Re-creating Password File

---

• Flashback
  • Flashback Query
  • Flashback Version Query
  • Flashback Table
  • Flashback Transaction Query
  • Flashback Transaction Backout
  • Flashback Drop & Recycle Bin
  • Flashback Data Archives
  • Flashback Database

---

• PDB Snapshots
• Database Duplication
  • Backup-Based Duplicate Database

---

• Recovery Manager (RMAN)

  • Connect

  • Configuration

  • Catelog
  • Reporting
  • Backups Commands

  • Stored Scripts

  • Diagnosis
    • Automatic Diagnostic Repository (ADR)
    • Data Failure & Data Recovery Advisor

---

DBA1

• oraenv