Tadashige Morii wrote:
> > $B=i4|2=%Q%i%a!<%?$K(B control_file_record_keep_time=0 $B$r@_Dj(B
> $B!!$3$l$C$F$I$&$$$&F0$-$9$k$s$G$9$+!)(B
$B%3%s%H%m!<%k%U%!%$%k$X%G!<%?%Y!<%9$N>pJs$r=q$-9~$`$H$-(B
$B%l%3!<%I$NF|IU$r8+$F>e=q$-$9$k$+$7$J$$$+$9$k$h$&$G$9!#(B
$B$=$N;~$NK~N;4|4V$H;W$o$l$^$9!#(B
$B!J(B# strings /home/oracle/oradata/orcl/control01.ctl
$B$rpJs$,=P$F$/$k$G$7$g$&(B....$BMzNr$r;}$C$F$$$k$N$G(B
$B$9!#!K(B
$B%G%U%)%k%H#7F|$G$9$+$i!"#1=54V0JFb$K(B 6553$B2s%3%s%H%m!<%k%U%!%$%k$X(B
$B=q9~$_$,H/@8$9$k$H>e=q$-$9$k$H$3$m$,$J$/$J$C$F$7$^$&$h$&$G$9!#(B
$B0lHLE*$K$O!"=i4|%G!<%?%Y!<%9:n@.8e(B
$B==J,$JBg$-$5$N(B REDO LOG $B$r:n$C$F$$$l$PLdBj$O5/$-$J$$$G$7$g$&!#(B
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$B!J0l0B?4!#(B
$B;d$N$*5R$5$s$GBg5,LO$J%G!<%?=hM}$d$C$F$$$k$N$O!"(BOracle7.3.4 $B$P$+$j$@$+(B
$B$i!#(B
$B2P$KL}$rCm$$$@$h$&$G!K(B
http://www.labunix.uqam.ca/oracle/ $B$+$iH4?h!#(B
CONTROL_FILE_RECORD_KEEP_TIME
Parameter type: integer
Parameter class: dynamic, scope = ALTER SYSTEM
Default value: 7 (days)
Range of values: 0 - 365 (days)
Records in some sections in the control file are circularly reusable
while records in other sections are
never reused. CONTROL_FILE_RECORD_KEEP_TIME applies to reusable
sections. It specifies the minimum age in
days that a record must have before it can be reused. In the event a new
record needs to be added to a
reusable section and the oldest record has not aged enough, the record
section expands. If
CONTROL_FILE_RECORD_KEEP_TIME is set to 0, then reusable sections never
expand and records are reused as
needed.
--
Takumi Okada
Cyber Net Communications, Inc.