000012842 - Checking to see what archived log files can be removed from RSA Authentication manager 7.1

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000012842
Applies ToRSA Authentication Manager 7.1 SP4 AM 7.1 SP4 Appliance 3.0.4
Windows 2003 SP2
Recovery Manager (RMAN)
ARCHIVELOG mode
 
IssueWarning: Low disk space.  More than 75% of disk space allotted for replication on this instance is in use.  If it reaches 100% this authentication and replication on this server will stop working and will eventually stop working on all instances.  Run the manage-database CLU to increase the allotted disk space.
archived log files are taking up a lot of disk space
RSA Authentication Manager Database Server fails to start
Resolution

The RSA Authentication Manager 7.1 SP2 internal database is using ARCHIVELOG mode which is for database recovery should anything go wrong. The archived log files are redo logs containing transaction records that are placed in the RSA_AM_HOME\backup\<sid-name>\ARCHIVELOG\<date> (e.g. for Windows ?C:\Program Files\RSA Security\RSA Authentication Manager\backup\QIICUULI\ARCHIVELOG\2010_05_06? or for UNIX ?/usr/local/RSASecurity/RSAAuthenticationManager/backup/QIICUULI/ARCHIVELOG/2010_05_06?). A busy RSA Authentication Manager will generate a lot of archived log files which will require a lot more disk space.


 


It is possible that a technical issue with replication cause a large amount of archived log files to accumulate and take up disk space. Use knowledge article a50917 (Reporting Replication issues to RSA Customer Support) to generate reports on replication.


 


RSA does not recommend removing or deleting these archive log files either via the Recovery Manager (RMAN) or using tools within the operating system.


 


IMPORTANT NOTICE: Removing these archived log files will impact the recovery of the RSA Authentication Manager internal database and replication to replica(s).


 


Should you need to see what logs are safe to delete, RSA provides a Command Line Utility (CLU) to generate a report file called ?safe_to_delete.txt? on the last archived log files that are safe to delete. The report file is generated in the current folder where the CLU is executed.


 


rsautil manage-data -a exec-sql -f diagnostics/safe_delete_archive_logs.sql


 


Should the CLU generated report return the result ?no rows selected? then there are no archived logs files to be deleted.


 


Here is an example of the CLU running on a Windows platform:



  

C:\Program Files\RSA Security\RSA Authentication Manager\utils>rsautil manage-data -a exec-sql -f diagnostics/safe_delete_archive_logs.sql


  

Enter password: ***********


  

Confirm password: ***********


  

 


  

 Manage Database ims-2.0.2-build20091007172001


  

 Copyright (C) 2008 RSA Security Inc. All rights reserved.


  

 


  

 %% Running at: am71sp2p.bellnet.local:[qiicuuli] %%


  

 


  

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


  

 %             Execute SQL                %


  

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


  

 Are you sure you want to execute the SQL file [diagnostics/safe_delete_archive_logs.sql] ? (Y/N): y


  

 


  

.


  

.SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 14 15:27:58 2010


  

.


  

.Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


  

.


  

.


  

.Connected to:


  

.Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production


  

.With the OLAP, Data Mining and Real Application Testing options


  

.


  

.


  

.no rows selected


  

.


  

.Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production


  

.With the OLAP, Data Mining and Real Application Testing options


  

 


  

 Done...


  

 


  

C:\Program Files\RSA Security\RSA Authentication Manager\utils>


  

 


 


 

Here is an example of the CLU running on a Unix platform:



  

 


  

login as: emcsrv
   Current build is 3.0.4.10
   emcsrv@cs-appliance3-05.na.rsa.net's password:
   Last login: Fri Jan 20 16:01:52 2012 from 10.100.41.61
   -bash-3.00$ sudo su - rsaadmin
   Password:
   -bash-3.00$ cd /usr/local/RSASecurity/RSAAuthenticationManager/utils
   -bash-3.00$ ./rsautil manage-data -a exec-sql -f diagnostics/safe_delete_archive_logs.sql
   Enter Master password: ********


  

 Manage Database ims-2.0.4-build20111004160151
    Copyright (C) 2010 RSA Security Inc. All rights reserved.


  

 %% Running at: cs-appliance3-05.na.rsa.net:[t7ntqgfv] %%


  

 ===========================================
    %             Execute SQL                %
    ===========================================
    Are you sure you want to execute the SQL file [diagnostics/safe_delete_archive_logs.sql] ? (Y/N): y
   .
   .SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jan 20 16:09:23 2012
   .
   .Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
   .
   .
   .Connected to:
   .Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
   .With the Partitioning, Data Mining and Real Application Testing options
   .
   .
   .no rows selected
   .
   .Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
   .With the Partitioning, Data Mining and Real Application Testing options


  

 Done...


  

-bash-3.00$


  
NotesHere is an example of the output when run on a Windows Platform, and there are some that are safe to delete
NAME                                                                           
--------------------------------------------------------------------------------
C:\PROGRA~1\RSASEC~1\RSAAUT~1\BACKUP\QBKP4HBG\ARCHIVELOG\2011_12_20\O1_MF_1_2127
_%U_.ARC                                                                       
                                                                               
C:\PROGRA~1\RSASEC~1\RSAAUT~1\BACKUP\QBKP4HBG\ARCHIVELOG\2011_12_20\O1_MF_1_2128
_%U_.ARC                                                                       
                                                                               
C:\PROGRA~1\RSASEC~1\RSAAUT~1\BACKUP\QBKP4HBG\ARCHIVELOG\2011_12_20\O1_MF_1_2129
_7H0939LM_.ARC                                                                 
                                                                               
C:\PROGRA~1\RSASEC~1\RSAAUT~1\BACKUP\QBKP4HBG\ARCHIVELOG\2011_12_20\O1_MF_1_2130
_%U_.ARC                                                                       
NAME                                                                           
--------------------------------------------------------------------------------
                                                                               
 
Legacy Article IDa50832

Attachments

    Outcomes