RiCo技術農場

11g建立過程大多和10g相同,利用rman duplicate快速建立physics standby是最佳選擇，最大差異就是rman command

(前面建立過程可參考Oracle 10g DG第五章Create physical standby db by SQL+快速複製資料庫-rman Duplicate小弟就不在寫了)

 

連線至auxiliary database

執行 rman command(差異部分小弟用紅色highlight起來)

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