Sample Header Ad - 728x90

Stop Dataguard configuration to test standby database

0 votes
1 answer
317 views
I would like to know how it would be the correct way in which I should proceed to stop the Dataguard configuration in order to perform a series of tests on the standby database. It turns out that I have an environment with two Oracle 11gR2 databases, one primary and the other physical standby in a remote location (DR), the fact is that I have to perform some stress tests, modifications in some logical structures and above all, apply TDE to column level and measure the performance after applying it, all these actions I would like to do in the physical standby since it is impossible to stop the production database as it is very critical. So, as I was saying, the idea is to momentarily stop Dataguard, perform all operations on standby, and then return everything to the way it was before. What steps should I take to carry out the task in question?
Asked by miguel ramires (169 rep)
Nov 8, 2021, 02:15 AM
Last activity: Nov 17, 2021, 06:54 PM