000027956 - How to determine the size of a backup before creating one in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Jun 7, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000027956
Applies ToRSA Product Set: Identity Governance & Lifecycle
IssueThis 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.
ResolutionAs 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.