• 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. Oracle RMAN: Monitoring Recovery Manager Jobs
  2. How to Create a Physical Standby Database by Using SQL and RMAN Commands
  3. WebLogic Server Domain: How To Disable the HTTP methods other than GET and POST (such as PUT, DELETE, etc.)
  4. How to Install/Uninstall/Upgrade Oracle SQLTXPLAIN (SQLT) Tool
  5. How to find daily and hourly archive log generation in Oracle Database
  6. How to Rename the Default JSESSIONID in WebLogic
  7. How to Use DBMS_METADATA To Get The DDL For Objects
  8. Oracle Home Relinking Interview Questions and Answers
  9. How to Resize the Undo Tablespace in Oracle Database
  10. How To Setup UDEV Rules For RAC OCR And Voting Devices on Partitions

You May Also Like

Primary Sidebar

Recent Posts

  • grpck command – Remove corrupt or duplicate entries in the /etc/group and /etc/gshadow files.
  • xxd command – Expressed in hexadecimal form
  • sesearch: command not found
  • macof: command not found

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright