SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\oradata\primary\arch1\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary';
6 T3 h& r+ x3 U6 w
: [4 B4 g0 d5 G8 j. T' W 系统已更改。: F y$ s, _ G# H& K' N+ Z9 m
( F* i. a% {& Z) w/ ^) E
SQL> alter system set LOG_ARCHIVE_DEST_2='SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby';2 `, [/ l: T8 s
& U( c" B+ m/ a7 e% ] w; H& L
系统已更改。
) ]$ H+ C# J. p2 o# t1 g, g5 D$ [ 3 k: u T9 a" @4 A+ m6 M
SQL> alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE;
" E1 \$ r8 C \& O$ P0 y
1 o1 e4 S1 s7 Y: A2 u$ l3 U 系统已更改。5 n+ u S C8 j0 }. _
/ A% e* [6 c' d2 e SQL> alter system set FAL_SERVER=standby; o( i6 d5 r3 t0 L: D, R$ `
# V% G4 a; b6 b/ S5 I' E
系统已更改。
+ P* S3 I- R! e/ D 5 O- k* n. o2 Q' E9 D- d, k
SQL> alter system set FAL_CLIENT=primary;
3 l" H* V. O2 y: G; k' K
, v" `- r8 a3 O8 w; A5 R 系统已更改。9 a- J$ d7 {. w$ U- R1 n, c+ H
8 K3 O1 N2 x7 w% I$ h" B$ i; Q
SQL> alter system set DB_FILE_NAME_CONVERT='C:\oracle\oradata\standby\','C:\oracle\oradata\primary' scope=spfile;- X+ V5 U) m S+ x' B6 ]
0 w6 {( Q& y- L 系统已更改。3 ~1 R6 v* L$ e; ~& n/ H, ]
9 k: j& k& {, K! o SQL> alter system set LOG_FILE_NAME_CONVERT='C:\oracle\oradata\standby\arch1\','C:\oracle\oradata\primary\arch1' scope=spfile; [5 f" @0 t$ S9 f6 r
3 q/ _+ a" U5 }7 M& \ 系统已更改。
3 \ t! }$ v4 I" q9 b , w" v5 |2 A+ C
6. 配置监听相关参数( I% K+ p0 ^( p! v
7 H* {) C" C1 k# d
编辑C:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora为如下内容: K( x8 s- P% q& j
" i" q8 m8 ~4 \, Q1 g) A # listener.ora Network Configuration File: C:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora" D8 ~% \! I8 _# M8 ?' ^
% {$ T) _, z' ~' w8 W+ R
# Generated by Oracle configuration tools.! Y# L: R$ }5 [+ U- A7 p3 k; i! R4 I
0 ], C. X, t- _' p0 [ SID_LIST_LISTENER =
- m' ]0 @7 Q; X% T; Z # }# i1 o5 f8 u" O3 o
(SID_LIST =
8 X1 F7 u o" o$ G% R3 M
" d9 |0 S. t- ^" f* i; n6 E (SID_DESC =
- k* {9 z& ^+ S4 `6 w/ F, h# n7 P3 d
* c, L* d& a" X7 @ (GLOBAL_DBNAME = primary)5 U( G2 u, E6 V
& Q9 n) F. G9 _* Y3 s2 H
(ORACLE_HOME = C:\oracle\product\11.2.0\dbhome_1)# s( a5 V' ^ f& Z- ~
/ h: z0 ]3 M l. a' Q$ T (SID_NAME = primary) |