How to determine the size of a backup before creating one in RSA Identity Governance & Lifecycle
3 years ago
Originally Published: 2014-10-20
Article Number
000056658
Applies To
RSA Product Set: Identity Governance & Lifecycle
Issue
This knowledge base article describes a command you may use to determine the size of an RSA Identity Governance & Lifecycle database export file* before you take the backup. This is especially useful if you are unsure as to whether there is enough space on the local drive to create a successful backup.
 
*Also known as the database backup, database dump or datapump export file.
Resolution
As the oracle user, execute the expdp Oracle database export command with the ESTIMATE and estimate_only parameters as follows:
 
expdp avuser/<password> directory=Aveksa_ExportImport_Directory ESTIMATE=blocks estimate_only=y logfile=log.log
 
For more information,
  • expdp - Oracle datapump utility which is used for the backup.
  • avuser/<password> - Credentials for database access
  • directory=Aveksa_ExportImport_Directory - Output directory.
This directory is specified when the database is created and points to/home/oracle/AveksaExportImportDir.
To verify the name of the backup directory, execute "select * from all_directories" as 'avuser' in SQL*Plus.
  • ESTIMATE=blocks estimate_only=y
Do not do the actual backup. Just report the size that the backup will be.
  • logfile=log.log - File name that contains the output that you see in the terminal window.


An example session is shown here:

User-added image


Notice that no backup file is created.

Don't see what you're looking for?