RSM Warning: LogXptMode is inconsistent with the database setting
In the data guard log from my primary server, i find some entries with "RSM Warning: property 'LogXptMode' of site 'CHODS' is inconsistent with the database setting.
broker metadata value: 'async (= LGWR ASYNC NOAFFIRM)'; database setting: (LGWR SYNC NOAFFIRM);
I would use LGWR ASYNC NOAFFIRM, max. Performance for physical standby database.
Current Parameter Primary:
********************************
Log_archive_dest_2=> service="choDs.root.local", LGWR NOAFFIRM delay=0 OPTIONAL max_failure=0 reopen=300 async=0 register nonet_timeout
--> additionally question for best practice.....LAN environment??
--> async=4096 (2 MB Buffer)
--> max_failure=10
--> reopen=15
--> net_timeout=30
Current Parameter Secondary:
***********************************
Log_archive_dest_2=> ''