Site icon Database Tutorials

Changing Data Protection Mode From SQLPLUS

In today’s article we will learn to Changing Data Protection Mode From SQLPLUS.

1. We learn whether Data Guard Broker is used or not.

2. We query the Redo Transport modes of the Databases to see the changes, both after changing the Protection Mode and after ENABLE the Configuration.

3. We query the LOG_ARCHIVE_DEST_n parameters to see the changes both after changing the Protection Mode and after ENABLE the Configuration.

4. We DISABLE the configuration.

5. We update the LOG_ARCHIVE_DEST_n parameter in accordance with the Maximum Protection to the Logical Standby Database.

6. We set the Data Protection Modes of the Standby Databases to Maximum Protection.

7. We move on to post-change controls.

We question whether the Protection Modes have changed.

We’re looking for lag.

Although it is seen that there is no lag, an existing table is deleted and it is seen whether the transactions are reflected on the Standby side.

8. The configuration is enabled and it is seen that all changes are back to the settings before the configuration was disabled.

 

 

Exit mobile version