• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How does the RMAN Retention Policy Obsolete Incremental Backupsets

by admin

The report/delete obsolete commands works in two steps.

First, we identify the oldest full backup (i.e. full or level 0 backupset, or image copy) of every file that is not obsolete, as defined by the retention policy (either REDUNDANCY or RECOVERY WINDOW). Every older full backup is obsolete.

Then, all archived logs and level > 0 incremental backups that are older than the oldest non-obsolete full backup are also considered to be obsolete, because there is no longer any full backup to which they could possibly apply.

Note that a level > 0 backup performs much the same function as an archived log – it causes a full backup to move forward in time, so those backups are treated in the same manner as archived logs for the purposes of retention. Incremental backups are not restored using the restore command, they are restored using the recover command if it will cause fewer archive logs to be needed during recovery. When you restore it is always only from full or level 0 incremental backups of
the datafiles.

Filed Under: oracle, RMAN

Some more articles you might also be interested in …

  1. IN and EXISTS SQL Operator
  2. Retrieving data with PL/SQL
  3. RMAN-06059 During RMAN Backup of archivelogs ( How to backup archivelogs moved to a different location)
  4. Whats is PL/SQL
  5. How to Check if a table is Indexed in Oracle
  6. Understanding Flashback Table Feature in Oracle Database
  7. Oracle GoldenGate: How to start Extract & Replicat using Shell Script
  8. Oracle Database Basics – User Accounts
  9. How to Recover From Lost or Missing Database Parameter Files (PFILE or SPFILE)
  10. How to Configure client connectivity in Oracle Data Guard configuration (Implement failover procedures)

You May Also Like

Primary Sidebar

Recent Posts

  • pw-cat Command Examples in Linux
  • pvs: command not found
  • pulseaudio: command not found
  • pulseaudio Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright