Oracle11g建立Data Guard和10g有一點點不同,這篇我將告訴大家需注意的小地方。
11g建立過程大多和10g相同,利用rman duplicate快速建立physics standby是最佳選擇,最大差異就是rman command(詳細過程可參考前天分享的10g rman duplicate)
連線至auxiliary database
![]()
執行 rman command(差異部分小弟用粗體顯示)
RUN {
allocate channel c1 type disk;
ALLOCATE AUXILIARY CHANNEL ax1 DEVICE TYPE DISK;ALLOCATE AUXILIARY CHANNEL ax2 DEVICE TYPE DISK;ALLOCATE AUXILIARY CHANNEL ax3 DEVICE TYPE DISK;ALLOCATE AUXILIARY CHANNEL ax4 DEVICE TYPE DISK;
duplicate target database for standby from active database dorecover;}
![]()
![]()
![]()
建立完成後測試同步功能
開啟standby db redo apply
![]()
Check current sequence
![]()
alter system switch logfile;
![]()
switchlog後primary和standby同步成功。
下篇小弟將實測physics standby db open readonly狀態下可否open redo apply services