:

.patch_storage Consuming Large Amount of Space

The Problem

You have multiple Oracle Homes installed on the same DB server and you notice that the size of the software is increasing pretty rapidly. You have patched the homes many times since you installed the base release and it seems to grow with each patch application.

In particular, you notice that the .patch_storage folder is increasing in size. It will be located somewhere similar to the below on a Windows server:

D:\Oracle\Product\11.2.0\dbhome_1\.patch_storage

The Cause

Each time that you apply another Oracle patch to your Oracle Home, backups are saved in the .patch_storage folder. This enables you to rollback from an Oracle Home patch.

The Solution

You can use the Opatch utility to remove redundant files which are no longer required for rolling back patches. DO NOT attempt to remove files manually because there might be some dependency which you are unaware of. Here is how to remove files from the .patch_storage folder:

Step 1 – set Oracle Home
SET ORACLE_HOME=D:\Oracle\Product\11.2.0\dbhome_1
CD D:\Oracle\Product\11.2.0\dbhome_1\Opatch

Opatch util cleanup

Now check out how much space you have saved! Repeat this for each Oracle Home that you have. It is probably worth doing this periodically if you are applying patches regularly in order to reclaim as much space as possible from the .patch_storage folder.

More Information

Check Metalink note 550522.1

Like it, share it...

Category: Windows


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *