1.

How To Change Protection Mode In Oracle Data Guard Setup?

Answer»

By using FOLLOWING query your can change the PROTECTION mode in your primary database after setting up required value in corresponding LOG_ARCHIVE_DEST_n PARAMETER in primary database for corresponding STANDBY database. ALTER DATABASE SET STANDBY DATABASE TO MAXIMUM [PROTECTION|PERFORMANCE|AVAILABILITY];

Example: alter database set standby database to MAXIMUM PROTECTION;

By using following query your can change the protection mode in your primary database after setting up required value in corresponding LOG_ARCHIVE_DEST_n parameter in primary database for corresponding standby database. ALTER DATABASE SET STANDBY DATABASE TO MAXIMUM [PROTECTION|PERFORMANCE|AVAILABILITY];

Example: alter database set standby database to MAXIMUM PROTECTION;


Discussion

No Comment Found

Related InterviewSolutions