000037500 - Severe performance degradation when running RMAN in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 6, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037500
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Product/Service Type: Enterprise Software
IssueOn a software only RSA Identity Governance & Lifecycle implementations where the database is supplied by the customer and not RSA, customers may choose to run Recovery Manager (RMAN) to backup the database. When RMAN is running on an active database, severe performance degradation may occur.

CauseRunning RMAN on an active database can cause severe performance degradation. It can potentially deadlock the entire database. Because of the heavy reads on the database by RMAN, there can be row lock contention across multiple tables and indices. In addition, both database I/O and file system I/O can be affected.
ResolutionTo avoid performance issues while running RMAN:
  1. Schedule RMAN backup outside of peak hours.
  2. Stop RSA Identity Governance & Lifecycle during RMAN backup.