RE: RMAN and control_file_record_keep

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Mon, 21 Jun 2004 16:31:11 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F702D4EEDC@irv2kexch01>

Nobody=20replied=20so=20far.=20I=20guess=20I=20am=20going=20to=20recreate=20= control=20file
just=20to=20trim=20down=20the=20control=20file=20size?

-----Original=20Message-----
From:=20oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent:=20Friday,=20June=2018,=202004=2010:24=20AM To:=20Oracle-L_at_Freelists.=20Org=20(E-mail) Subject:=20RMAN=20and=20control_file_record_keep_time

Hi,

My=20control_file_record_keep_time=20is=20set=20to=2030=20days.

Why=20I=20am=20still=20seeing=20the=20following=20in=20the=20alert=20log=20= file?
"kccrsz:=20expanded=20controlfile=20section=2015=20from=2012574=20to=20127= 89=20records
=20=20requested=20to=20grow=20by=20127=20record(s);=20added=202=20block(s)=
=20of=20records"

The=20database=20is=209=20month=20old=20andw=20e=20did=20not=20change=20th= e=20frequency=20of=20
backups;
The=20number=20of=20archived=20redo=20log=20files=20that=20are=20generated=
=20does=20not=20change=20

much;
And=20the=20retention=20period=20for=20RMAN=20records=20stays=20the=20same= .

RMAN>=20show=20all;

using=20target=20database=20controlfile=20instead=20of=20recovery=20catalo= g
RMAN=20configuration=20parameters=20are:

CONFIGURE=20RETENTION=20POLICY=20TO=20REDUNDANCY=201;=20#=20default
CONFIGURE=20BACKUP=20OPTIMIZATION=20OFF;=20#=20default
CONFIGURE=20DEFAULT=20DEVICE=20TYPE=20TO=20DISK;=20#=20default
CONFIGURE=20CONTROLFILE=20AUTOBACKUP=20ON;
CONFIGURE=20CONTROLFILE=20AUTOBACKUP=20FORMAT=20FOR=20DEVICE=20TYPE=20DISK=

=20TO=20'%F';=20#=20

default
CONFIGURE=20DEVICE=20TYPE=20DISK=20PARALLELISM=201;=20#=20default CONFIGURE=20DATAFILE=20BACKUP=20COPIES=20FOR=20DEVICE=20TYPE=20DISK=20TO=20= 1;=20#=20default

CONFIGURE=20ARCHIVELOG=20BACKUP=20COPIES=20FOR=20DEVICE=20TYPE=20DISK=20TO=


=201;=20#=20default

CONFIGURE=20MAXSETSIZE=20TO=20UNLIMITED;=20#=20default
CONFIGURE=20SNAPSHOT=20CONTROLFILE=20NAME=20TO=20
'/oracle/PR2/920_64/dbs/snapcf_PR2.f';=20#=20default

RMAN>=20exit

Thanks,

Roger=20Xu

This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20=
to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=

g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20= entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20= have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s= ender=20immediately=20and=20delete=20the=20material.=20

This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=

Please=20see=20the=20official=20ORACLE-L=20FAQ:=20http://www.orafaq.com

To=20unsubscribe=20send=20email=20to:=20=20oracle-l-request_at_freelists.org put=20'unsubscribe'=20in=20the=20subject=20line.

--
Archives=20are=20at=20http://www.freelists.org/archives/oracle-l/
FAQ=20is=20at=20http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

For=20technical=20support=20please=20email=20tech_support_at_dp7uptx.com=20or=


=20you=20can

call=20(972)721-8257.=20
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.

************************************************************************
This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20=
to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20=
entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20=
have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s=
ender=20immediately=20and=20delete=20the=20material.=20
************************************************************************
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=
.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jun 21 2004 - 16:28:18 CDT

RE: RMAN and control_file_record_keep_time