sql clone "alter system set control_files =" j4 Q o/ t6 g* C5 Q$ L* u% C
- x- X+ P: R: K$ R0 l ''C:\oracle\oradata\standby\CONTROL01.CTL'' comment=' G, w) j0 Q0 A0 F1 v; i+ O
- a, V. ?( ~/ D2 K$ N
'''' scope=spfile";
) j& e# a6 E% I# D
H6 l* l5 D8 e V: U" | sql clone "alter system set log_archive_max_processes =
5 G, E+ _0 \7 S4 j / S" b, R" O; p" V9 h0 G+ P
5 comment= `7 I0 ?' {1 J/ g
/ l9 p, G! u% ~1 t '''' scope=spfile";
3 e/ d k' U) T$ M1 q
" D1 {+ Y. N3 ]% J sql clone "alter system set fal_client =6 f' [) J7 p/ e$ p, K
! o$ Y7 j0 z w9 s& S ''standby'' comment=
$ I4 q7 U/ ]! G. H4 l& V
& j. b& Q9 F1 X1 H. { '''' scope=spfile";) a, L: ^5 J: M) F0 j9 t
1 Q$ g S8 ~9 G* u! K, B; f" k sql clone "alter system set fal_server =* X& ]/ {! h+ d6 P! ~
. h2 ^% k, F' e$ M9 k ''primary'' comment=6 q3 y. H; S, D' B' W3 ?
5 d: K2 h0 k6 F% u: [ '''' scope=spfile";* N/ L% Z2 T* Z; g% B% x* o: Z: H
! `) x4 _$ V5 q! u% _ sql clone "alter system set standby_file_management = O# B' p2 P i
& ?+ Z7 Y: g6 e& @6 F
''AUTO'' comment=5 [9 d" h' ?/ s9 \0 v
; O. A% ]! d* b1 k9 i! L- g
'''' scope=spfile";
8 |3 [3 c; x& W, ~7 a# }. l , H: ]2 \% Q3 O8 _2 _! R9 A6 W/ w! o; B
sql clone "alter system set log_archive_config =
6 B' j! m8 n8 P' Q. {* q/ R- j! [ ) j* r0 F$ A0 J! J2 m/ P: [
''dg_config=(primary,standby)'' comment=9 G V: h( Q+ E& @: J6 M8 _' L+ ~# b
9 _& v* [6 q7 L '''' scope=spfile";
3 R$ E' K- I1 B; C; \
# X4 T2 z/ a" {. F4 n2 Q; n sql clone "alter system set log_archive_dest_1 =* p6 }1 C0 J, ]& B+ l& h3 k# a
; q2 U; V( z- x/ [
''service=primary ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primary'' comment=& H" U, K/ X! ~& b" v
9 G4 q) X1 k, @4 r2 N X7 t
'''' scope=spfile";
j# h: k, m: }7 T* t4 k6 W# y ! z v# S! \5 b, u( \( B' I# C
shutdown clone immediate;) l J, ^+ }/ q: c1 d" I0 c% C: ~
; d% y/ R' f; e5 I
startup clone nomount;, U6 H9 Y0 M( o p& d
: Y! v0 N, J1 ^ J m# [- A }4 q- n: H0 i$ T7 s: L* ]/ J
+ Z' N. z+ l6 A6 V( Q d
正在执行内存脚本2 @ _% \3 }9 J Q# P
# ]& v) ~4 F/ D9 G# }* h9 c sql 语句: alter system set audit_file_dest = ''c:\oracle\admin\standby\adump'' comment= '''' scope=spfile
- E6 V9 y9 J" m j+ s' l# j 7 V6 U1 @$ X) B+ v9 l! v3 E# o
sql 语句: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=standbyXDB)'' comment= '''' scope=spfile: k$ O/ r% l( u! t; }, {% q# y) j
/ |9 X; Q) r* F4 F
sql 语句: alter system set db_unique_name = ''standby'' comment= '''' scope=spfile
2 H) q8 X- b _9 q3 v. I+ V / U: T5 G$ p/ q8 r$ L2 I
sql 语句: alter system set db_file_name_convert = ''\primary\'', ''\standby\'' comment= '''' scope=spfile# D/ k) a6 a$ A1 x4 ]
0 Y2 Y0 @1 V, ?6 F( h& C sql 语句: alter system set log_file_name_convert = ''\primary\'', ''\standby\'' comment= '''' scope=spfile. C. l% n& V8 I: ^. \
/ C( {0 ^: I4 e: t7 C: G, v( {. a
sql 语句: alter system set control_files = ''C:\oracle\oradata\standby\CONTROL01.CTL'' comment= '''' scope=spfile
9 {1 @7 D3 l8 T l; [
: G- V- H& c/ x0 x! ?& b9 C1 [% t sql 语句: alter system set log_archive_max_processes = 5 comment= '''' scope=spfile
1 O4 O; B' M: J% W# E8 z 8 O2 V) v/ b1 M% S7 S1 O- u
sql 语句: alter system set fal_client = ''standby'' comment= '''' scope=spfile |