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

[#1]

Article Number

000027956

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:

Image description

Notice that no backup file is created.