Using the DB Space Reclamation Utility on INSIGHT Appliance Enforce/Oracle

Often it may be recommended to reclaim space after a large number of incidents have been deleted from SDLP Enforce or when the DB has grown over time and need to recover its white space. Below are the steps to follow when reclaiming space on INSIGHT Appliances.

Currently the built in reclaim scripts are for Oracle 11g only.

Please find Oracle 12c reclaim script attached, you may extract it to /tmp and run from /tmp using same steps below.

 

Please complete these Symantec DLP article before starting:

https://support.symantec.com/en_US/article.TECH252716.html

 

Refer to:

https://support.symantec.com/en_US/article.TECH236826.html

https://support.symantec.com/en_US/article.DOC9267.html

 

=======================================================================

Please apply DLP_lobspace_mgmt_b.pls from the zip file attached (LOB_Space_Management_Script.zip), then run the reclaim before upgrading to 12c.

https://support.insightdlp.com/hc/en-us/articles/360023622133

=======================================================================

1. SSH to Enforce server and navigate to the location of the DLP_lobspace_reclaim.sql

SSH as appuser

sudo su - protect

cd /opt/SymantecDLP/Protect/install/sql

or

cd /opt/Symantec/DataLossPrevention/Enforce\ Server/15.1/Protect/install/sql

or

/opt/Symantec/DataLossPrevention/EnforceServer/15.5/Protect/install/sql

 

 

2. View oracle size data before reclaming

vi /var/log/SymantecDLP/INSIGHT/size.txt.<YYYY-MM-DD-HH-MM>

vi /var/log/SymantecDLP/INSIGHT/size.txt.2018-03-08-10\:00

 

3. connect to database

sqlplus /nolog

connect sys as sysdba

ENTER PASSWORD

 

4. Run reclaim script

@@DLP_lobspace_reclaim.sql

OUTPUT:

 

5. Review output file /opt/SymantecDLP/Protect/install/sql/lobspace_reclamation.txt

vi /opt/SymantecDLP/Protect/install/sql/lobspace_reclamation.txt

To exit vi:

:q!

 

6. Restart Enforce

as appuser

sudo shutdown -r now

 

7. After reboot check oracle size data before reclaiming

vi /var/log/SymantecDLP/INSIGHT/size.txt.<YYYY-MM-DD-HH-MM>

vi /var/log/SymantecDLP/INSIGHT/size.txt.2018-03-08-10\:00

 

Note: If the database space reclamation utility returns any invalid objects, you must
recompile your database using the utlirp and package provided by Oracle. You
can find the utlirp package in ORACLE_HOME/RDBMS/ADMIN. If you see any other
errors in the logs, contact Symantec Support and provide them a copy of the
lobspace_reclamation.log file.

 

mceclip0.png

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.