dg主備都配置了lgwr sync affirm。主庫startup，備庫alter database open read only;然后alter database recover managed standby database disconnect from session; 發現進行資料增刪改后，發現無法實作資料的實時同步，必須通過alter system switch logfile后，備庫才能同步主庫的資料。
要實作實時同步必須啟用alter database recover managed standby database using current logfile disconnect from session;
主庫配置：
*.log_archive_config='dg_config=(pri,std)'
*.log_archive_dest_1='location=/u01/app/arch/ims valid_for=(all_logfiles,all_roles) db_unique_name=pri'
*.log_archive_dest_2='service=std lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=std'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_max_processes=4
*.log_file_name_convert='/u01/app/oracle/oradata/ims','/u01/app/oracle/oradata/ims'
*.memory_target=1606418432
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'
備庫配置
*.fal_client='std'
*.fal_server='pri'
*.log_archive_config='dg_config=(pri,std)'
*.log_archive_dest_1='location=/u01/app/arch/ims valid_for=(all_logfiles,all_roles) db_unique_name=std'
*.log_archive_dest_2='service=pri lgwr sync affirm valid_for=(online_logfiles,primary_role) db_unique_name=pri'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_max_processes=4
*.log_file_name_convert='/u01/app/oracle/oradata/ims','/u01/app/oracle/oradata/ims'
*.memory_target=1606418432
*.open_cursors=300
*.processes=1500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1655
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'
uj5u.com熱心網友回復：
在DG 備庫上仔細檢查是否正確設定了standby logfile。大小和主庫一致；組數最好多一組。
否則不會實時同步的！
uj5u.com熱心網友回復：
select db_unique_name,protection_mode,protection_level from v$database;看下是什么模式。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/65168.html
標籤：基礎和管理