Return
-
Title
Are there any recommendations on OLR usage? -
Description
Are there any recommendations on OLR usage?
Are there any limitations known? -
Cause
-
Resolution
WORKAROUND
There are a lot parameters related to memory requirements for table recovery by OLR.
It depends on number of tlogs added, number of changes in database registered as internal logs, backup structure and many other parameters.Our tests shows that OLR may need from 1% up to 20% of the table size in the server RAM to make the recovery and about 2x table size on the disk if use Bulk Insert (BCP) recovery method.We do not recommend to use OLR for tables recovery with size equal or more than 1TB.
We recommend to use OLR for recovery tables with size larger than 100GB on high performance systems only.STATUS
Enhancement request number LS-1434 has been created to add these recommendations to the LS help files.
-
Defect ID
LS-1434