High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Difference between max availability and max performance

edited Dec 7, 2019 4:05AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered

Hi All. I've read the documentation and didn't find the real difference between max availability and max performance protection modes. For both modes I can make SYNC/AFFIRM for the transport logs. And after doing some tests with crashing primary database the last SCN from the dump of redo logs are the same, between crashed primary and standby databases. Only one difference which I've found in the alert log.

For the max performance

LGWR: Standby redo logfile selected for thread 1 sequence 1790 for destination LOG_ARCHIVE_DEST_2

For the max availability

LGWR: Standby redo logfile selected to archive thread 1 sequence 1824

LGWR: Standby redo logfile selected for thread 1 sequence 1824 for destination LOG_ARCHIVE_DEST_2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center