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

The Geek Diary

CONCEPTS | BASICS | HOWTO

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

Empty Directories in the Flash Recovery Area (FRA) are not deleted

By admin

The Problem

RMAN archived redolog backups and maintenance commands are deleting files from the Flash Recovery Area (FRA) when needed. For example:

RMAN> backup archivelog all delete input;
      delete obsolete;

These commands only delete the files, but not the actual directories when they are empty after the deletion of the files.

The Solution

When there is an empty subdirectory that is more than 7 days old, they will get purged automatically at the end of controlfile backup. The interval of 7 days is hardcoded and cannot be changed.

For example :

RMAN> backup database including current controlfile;

or

RMAN> backup current controlfile;

Filed Under: oracle

Some more articles you might also be interested in …

  1. How to Startup/Shutdown PDB’s in Oracle Database 12c
  2. How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database
  3. How to Restore a Dropped Pluggable Database (PDB) in Multitenant Environment
  4. How an SQL query is executed in Oracle Database
  5. How to Drop/Truncate Multiple Partitions in Oracle 12C
  6. How Realms Work in Oracle Database Vault
  7. What roles can be set as default for a user in Oracle Database
  8. CentOS / RHEL : Installing and Configuring ASMLib
  9. How to rename database and then move datafile online in Oracle Database 12.2
  10. Oracle RMAN 12c – New Features

You May Also Like

Primary Sidebar

Recent Posts

  • MySQL: how to figure out which session holds which table level or global read locks
  • Recommended Configuration of the MySQL Performance Schema
  • MySQL: Identify what user and thread are holding on to a meta data lock that is preventing other queries from running
  • MySQL: How to kill a Long Running Query using max_execution_time
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary