September 18, 2008

After R12 Installation, $ORACLE_HOME/.patch_storage consumes more space.

After R12 installation we find the RDBMS patching backup area ($ORACLE_HOME/.patch_storage) takes more than 5 GB space.
This will increase you backup time and requires more backup space.

Note 550522.1 stats,
From OPatch Version 10.2 Opatch does not backup only the affected modules, it also takes a backup of the complete affected libraries to $ORACLE_HOME/.patch_storage//backup// for faster rollback.
This causes the .patch_storage directory to grow accordingly to the size of the libraries and modules being patched.

Hence after every R12 installation, we can clean up this area. Steps are,

•Login as Database OS User
•Set the Path
$ PATH=$ORACLE_HOME/OPatch:$PATH
$ export PATH
$ which opatch
$ opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc

•Check the size of .patch_storage
$ du -sh $ORACLE_HOME/.patch_storage

•Run opatch cleaning
$ opatch util cleanup -help
$ opatch util cleanup -invPtrLoc $ORACLE_HOME/oraInst.loc

•After cleaning check the .patch_storage size
$ du -sh $ORACLE_HOME/.patch_storage

Note:550522.1 How To Avoid Disk Full Issues Because OPatch Backups Take Big Amount Of Disk Space.

No comments: