4.修改primary库的参数
& P0 r% z6 i8 q! x3 r2 ` alter system set db_unique_name='wellcomm' scope=spfile; 9 h+ g8 A z. K5 c$ r3 ?* n; l
alter system set log_archive_config='DG_CONFIG=(wellcomm,wellcommb)';
6 O' V% ^, f; h alter system set log_archive_dest_1='LOCATION=/u01/oracle/oradata/wellcomm/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=wellcomm';
! u2 i# l( g2 b$ b, N, b alter system set log_archive_dest_2='SERVICE=wellcommb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=wellcommb';
! a" `- ]2 S6 F$ y' R) v4 h alter system set log_archive_dest_state_1=enable;
1 @/ c& b8 Y9 t2 }0 X alter system set log_archive_dest_state_2=enable;
* p- Y4 F8 S* g3 n1 `' A. S8 a. K alter system set log_archive_max_processes=10;
8 A7 h9 S, r, h- f1 v6 ?, P( O& ^+ k 5.克隆Primary数据库 " w5 l1 G2 R" P+ J3 S/ q
shutdown immediate 7 U+ v/ R' k& x/ Q5 W9 p! x
startup mount
. p2 q# W; L) q backup database;
% Y& L5 J; ^6 l 创建standby的控制文件
3 q6 {. ]! m: i# H3 @! ?5 \ alter database create standby controlfile as '/u01/oracle/controlbak.ctl'; / u& {. Z3 D. G; K
创建standby的参数文件并按standby主机的配置修改 5 ]. a9 R9 T0 ^) J1 y$ r
create pfile='/u01/oracle/initwellcommb.ora' from spfile; # _" f1 U6 s6 @8 o/ M2 s+ k
6.在standby主机上恢复数据库(rman方式); " ? Y* G$ Z( r' B* y
将5步的文件拷备到对应位置(ftp) / ~( {. u( I- d5 }0 Z% N9 m
startup mount pfile=''; ) G: w" u, o: f4 o
修改参数文件 1 u/ a y- ` g5 s
db_name='ora10g1' # }, l0 w; `; F% |. f0 |+ N" b2 `
db_unique_name='ora10g3' - I5 i8 w7 z, ~6 b+ V
log_archive_config='DG_CONFIG=(wellcomm,wellcommb)' 4 S. y \$ t7 V$ Z/ K( w
log_archive_dest_1='LOCATION=/u01/oracle/oradata/wellcommb/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=wellcommb' log_archive_dest_2='SERVICE=wellcomm LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=wellcomm' 4 R! }" h% G) [/ T9 p
log_archive_dest_state_1=enable
/ Y- l' ^) m6 [7 o. E5 K, r( @5 u log_archive_dest_state_2=enable 1 I4 b5 i% F% o' Y+ @7 Q' a
remote_login_passwordfile='EXCLUSIVE' % Z& k0 B9 Y$ c
log_archive_max_processes=10 restore database; |