Comment Re:Jesus no (Score 1) 402
Use the dgmgrl to convert the standby database to 'Snapshot Standby'. Once it is in that mode you can make any changes you want to the system and then convert the standby back to 'Physical Standby'.
During the conversion back to Physical Standby it brings the database back to the point in time that it was converted to snapshot and applies all the logs that have shipped while in snapshot mode. Just make absolutely sure that you've got enugh space in the FRA to hold the initial snapshot and any changes before the database is reverted.
All the while the DG brokers are still running and you never 'stop' DG, just change the standby to something more usable for those instances where devs need current production data.