| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN and control_file_record_keep_time
One reason that I can think of to rebuild the control file is to
eliminate the archlogs that are listed from day - one when you use the
OEM or other product to look at the database. It lists the pages and
pages of archlogs and I think that is what is increasing the size of the
control file. In 10g mine has grown and the only thing that is changing
is the increase in archivelogs.
My control files started small and now they are up to 21741568 (21.7
meg). I generate about 25 archlogs each morning when I load about
250,000 rows of data. I generated a lot of archlogs when I loaded 2
years worth of data into the database and I noticed in the alert log
that the control file had made an entry that it had grown.
Other than rebuilding the control file that is the only way I know of
shrinking it. Anybody have a different method?
Thanks,
Ron
>>> thomas.mercadante_at_labor.state.ny.us 06/22/2004 10:18:37 AM >>>
I guess I was wondering why he felt the need to trim down the size of
the
control file. This is not a good enough reason for me to recreate the
control files. Heck, how big are control files? 2M? Roger, you got
free
time on your hands?.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Tim Johnston [mailto:tjohnston_at_quallaby.com]
Sent: Tuesday, June 22, 2004 10:15 AM
To: oracle-l_at_freelists.org
Subject: Re: RMAN and control_file_record_keep_time
He might also get more help if people could actually read his mail...
Roger,=20you=20need=20to=20figure=20this=20out=20before=20people=20will=20ta ke=20the=20time=20to=20read=20your=20email
Tim
DENNIS WILLIAMS wrote:
>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=20recrea
>te=20
>=
>control=20file
>just=20to=20trim=20down=20the=20control=20file=20size?
>
>
>
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 13:37:35 CDT
 |
 |