• 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

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 Set the Permission of the Files Created Using UTL_FILE
  2. ORA-65208: Lockdown profile P1 does not exist
  3. CentOS/RHEL7 – Tuned Profiles Oracle
  4. How to Create a Physical Standby Database by Using SQL and RMAN Commands
  5. How to Start/Stop/Relocate SCAN listener in Oracle 11gR2 RAC
  6. Oracle RAC : understanding split brain
  7. How to quiesce an Oracle 12c RAC database
  8. Unable to instantiate disk “ASM_DISK” – error on running ‘oracleasm scandisks’ command
  9. Interview Questions : Oracle 12c Multitenant Database Architecture
  10. Oracle Database 18c: Roll Forward Physical Standby Using RMAN Incremental Backup in Single Command

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