SQL> connect sys/oracle@standby as sysdba
1 O2 v) H; b8 n8 j % L, p _. ~" `
已连接。
" D1 y) f$ H" N+ }. o1 p) ^ 6 p8 h0 u, x4 p
SQL>
# a0 G) h3 G: |
1 J$ m% O# a2 X! P- b" I o 12. 通过RMAN创建从库
$ o5 ~8 I/ H4 d1 h
. A( Y9 }$ q1 \" c* a 通过RMAN连接目标库(主库)与辅助库(从库)然后执行以下脚本,注意脚本里面的是反斜杠(unix需用正斜杠): N$ y6 e; E' L/ u1 M
9 ]8 T# K1 n3 |1 {2 D rman target sys/oracle@primary auxiliary sys/oracle@standby2 T( H* D% x& f1 C: G8 c
( e" {& T; X% B) Y8 e
run {
+ V# v. M V$ R& Q- T3 b- d
' t+ S5 l1 f% `( c9 u' R/ g duplicate target database for standby from active database' L, e9 m& ~% ^: r% Q9 e
N) Y) b6 A( f8 _! [7 p! ~
spfile
2 K* q* O- } M. e8 Z + a' z. U5 ~( P c
parameter_value_convert 'primary','standby'
; n! @, E. M) G, s5 z1 ]
% J! J h* y% z2 h$ M; C; S( G set db_unique_name='standby'2 _4 V) W& `8 ?! s, W K. M
; z5 l% X; \0 L8 x" e7 U set db_file_name_convert='\primary\','\standby\'
" p7 ] }, l1 ?. k* A/ q( H, r, P 0 ?$ W/ ?# w8 X/ g0 s
set log_file_name_convert='\primary\','\standby\'
% u! _* X0 N: N* g' \ ! b% u* N6 C( i: \
set control_files='C:\oracle\oradata\standby\CONTROL01.CTL'
* w) Y! p! ~+ B9 \$ E
. g" H! o$ P/ `0 N7 g: P, w9 M8 A set log_archive_max_processes='5'! q" _8 G }' v0 C3 i
/ x6 t0 r, C9 I! m ?! O+ c set fal_client='standby'2 @+ G! q, ` \9 o8 h; K
& f u' A! ~- {9 ]" ` set fal_server='primary'
$ u M" y0 V" p6 G; M3 H
" u; ?% h9 c: C1 q+ p, M0 \5 l% R set standby_file_management='AUTO'
9 ?! A. c8 P% E5 Q) S 8 u5 Q M4 L! v0 Z. T
set log_archive_config='dg_config=(primary,standby)'
) w! a/ F( P5 B0 K9 H 9 U0 s; y7 M0 s2 O! a
set log_archive_dest_1='service=primary ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primary'# M9 z1 P' A( i$ F$ ^. P" y3 q
- K4 M" U# F1 K! d ;# q0 E9 R b* T. {3 L. q) x% k
8 ~9 } F( B8 i4 p; ? }8 D F' S2 p5 W9 t# q
4 |2 l7 [/ o7 {& P
脚本输出! O7 j( W& G5 k0 |. f+ M
4 X }0 L# C2 H! S1 X C:\>rman target sys/oracle@primary auxiliary sys/oracle@standby- D) V9 S# C" ?4 ~, R8 h
+ L3 B: K, v" Z; [* a( D6 p4 P 恢复管理器: Release 11.2.0.1.0 - Production on 星期日 6月 17 20:46:53 20121 g* b. X, Z: U& A, r
! h7 q) K2 v' i; R
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved." c" O" j# Y# x& [5 ?" S
: N6 K& _7 A. |8 m) C 连接到目标数据库: PRIMARY (DBID=1623612784)
& u: Z3 o6 k: v) \4 k0 Y
2 u+ y; d1 U6 Q6 U. J 已连接到辅助数据库: PRIMARY (未装载)$ x* |6 I1 T& o) J/ X* ~
. q! ^0 E- G% B; m
RMAN> run {% {9 F9 m0 F1 ?
/ h4 d' g; I8 I) J/ P/ Y! \
2> duplicate target database for standby from active database# S- N! m- B6 O V5 E/ O3 l% c
$ E1 j! U% s/ Z 3> spfile$ f5 ]$ T6 [: M6 J
- I2 l! X; {( P4 L: X
4> parameter_value_convert 'primary','standby'
6 q- w) w0 v! C0 I
5 ~6 _0 e# }& H1 D8 c 5> set db_unique_name='standby'
# e% C1 B8 }* W8 M1 r # L: X$ p8 e; N2 q8 ?
6> set db_file_name_convert='\primary\','\standby\'
+ g6 h) K9 i4 K, ]7 d5 @% } 1 M( [3 U9 l# o1 e! v
7> set log_file_name_convert='\primary\','\standby\'0 ~9 r( A5 F+ w6 [) [; C2 m. x
1 q$ I0 ?8 y1 N4 x
8> set control_files='C:\oracle\oradata\standby\CONTROL01.CTL' h. S. Y: c* k: {5 x6 B/ }
/ Z. E, Y6 @( ?4 d3 O c9 N 9> set log_archive_max_processes='5' |