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?
As suggested you should convert the physical standby database into a snapshot standby database. You can do almost all changes on the snapshot standby database, except for TDE operations. To do TDE stuff you must have a keystone and a TDE master key. This you create on the primary database, and copy it to the standby database. Part of the TDE configuration goes into the control file, so you can't undo that with Flashback Database (which is used by snapshot standby database).