RE: RMAN and control_file_record_keep_time
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Jun 2004 16:31:11 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent:=20Friday,=20June=2018,=202004=2010:24=20AM
To:=20Oracle-L@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@xxxxxxxxxxx=
.
----------------------------------------------------------------
Please=20see=20the=20official=20ORACLE-L=20FAQ:=20http://www.orafaq.com
----------------------------------------------------------------
To=20unsubscribe=20send=20email=20to:=20=20oracle-l-request@xxxxxxxxxxxxx
put=20'unsubscribe'=20in=20the=20subject=20line.
--
Archives=20are=20at=20//www.freelists.org/archives/oracle-l/
FAQ=20is=20at=20//www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
For=20technical=20support=20please=20email=20tech_support@xxxxxxxxxxx=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@xxxxxxxxxxx=
.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
