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