• 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. Simple Steps to use LogMiner for finding high redo log generation
  2. How to switch roles in Oracle Data Guard
  3. Warning: ORA-16829: fast-start failover configuration is lagging
  4. Oracle Database 12c : Creating a Scheduler Job in a Multitenant Database
  5. How to convert NON-OMF to OMF files ( Oracle Managed File conversion – NON-ASM )
  6. Oracle GoldenGate: GLOBALS Sample Parameter File
  7. How to Clone a Pluggable Database from an RMAN Container Database Backup
  8. How to Connect to an Oracle Pluggable Database (PDB)
  9. How to Move OCR, Vote Disk File, ASM SPILE to new Diskgroup
  10. How to set the db_file_name_convert and log_file_name_convert parameters

You May Also Like

Primary Sidebar

Recent Posts

  • aws ec2: CLI for AWS EC2 (Command Examples)
  • aws cur – Create, query, and delete AWS usage report definitions (Command Examples)
  • aws configure – Manage configuration for the AWS CLI (Command Examples)
  • aws cognito-idp: Manage Amazon Cognito user pool and its users and groups using the CLI

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright