Data Protection Advisor - How to check the size of a datastore/database (DB) export?

摘要: A database export is deemed a valid backup of the DPA datastore. They should be run regularly and also required prior to any upgrade or changes being made to the datastore. Space is needed, but how to check the size of a datastore export? ...

本文适用于 本文不适用于 本文并非针对某种特定的产品。 本文并非包含所有产品版本。
查看其他资源

说明

NOTE:  There is no command to determine the size of a database export without having an existing export to check.  
However, the following command can be run:

Linux: <install dir>/opt/emc/dpa/services/bin> ./dpa.sh ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"
Windows:  <install dir>\emc\dpa\services\bin> dpa ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"

The output reflects the size of the DPA datastore (db).  A db export is typically 1/10th of the size of this db but this may vary.
This is a general rule.  There are exceptions to this if there are large indexes on the db.  
Always place the db export outside of the DPA install directory for safety and space reasons.

Example:
dpaapp@lab]# ./dpa.sh ds query "SELECT pg_size_pretty(pg_database_size('apollo'));"

EMC Data Protection Advisor

pg_size_pretty
----------------
87 GB
(1 row)

87GB is the size of the db thus we would expect the size of the db export to be over 8GB.

受影响的产品

Data Protection Advisor
文章属性
文章编号: 000203586
文章类型: How To
上次修改时间: 10 3月 2023
版本:  7
从其他戴尔用户那里查找问题的答案
支持服务
检查您的设备是否在支持服务涵盖的范围内。