Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN and control_file_record_keep_time

RE: RMAN and control_file_record_keep_time

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 22 Jun 2004 07:06:09 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00866@EXCHMN3>


Roger

   Apparently nobody has encountered this issue. I certainly haven't. Just count yourself lucky ;-)

   My recommendation would be to file a TAR with Oracle Support and see if they can provide an explanation.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Monday, June 21, 2004 4:31 PM
To: oracle-l_at_freelists.org
Subject: RE: RMAN and control_file_record_keep_time

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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 Tue Jun 22 2004 - 07:06:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US