Re: RMAN and control_file_record_keep_time
- From: Peter Gram <peter.gram@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx,Peter Gram - Miracle A/S <peter.gram@xxxxxxxxxxxx>
- Date: Tue, 22 Jun 2004 23:27:26 +0200
Ron
Even if the control file is 27, 60 and 200 Mb I don't see a reason to
recreate the file. If you have some how can prove that the
performance of the database is affected by the size if the control file
size it is fine to make a new control file. I have never
seen a prof that size does mater when it comes control files. A wise
DBA once sad to me "If it is not broken don't fix it".
/peter
Ron Rogers wrote:
>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@xxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxx]
>Sent: Tuesday, June 22, 2004 10:15 AM
>To: oracle-l@xxxxxxxxxxxxx
>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@xxxxxxxxxxxxx
>>
>>-----Original Message-----
>>From: oracle-l-bounce@xxxxxxxxxxxxx
>>[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
>>Sent: Monday, June 21, 2004 4:31 PM
>>To: oracle-l@xxxxxxxxxxxxx
>>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?
>>
>>
>>
>>
>>
>
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------
>
>
>
--
Best regards / Venlig hilsen
/*Peter Gram*/
Miracle A/S <www.miracleas.dk>
Kratvej 2
DK - 2760 Måløv
Cell: (+45) 2527 7107
Phone: (+45) 4466 8855
Fax: (+45) 4466 8856
Home: (+45) 3874 5696
Email: peter.gram@xxxxxxxxxxxx
25 Aug 2004 OracleEkspert-konference 2004 på Trekroner
<http://www.oracleekspert.dk/konference.htm>
17 Sep 2004 DECUS-fest i Pederstrup
18-20 Oct 2004 RAC-kursus med Jonathan Lewis
28-30 Oct 2004 The Last Database Forum at Lalandia
<http://miracleas.dk/events/DBF2004/invitation.html>
22-24 Nov 2004 RMAN-kursus med Tuomas Pystynen
17-19 Jan 2005 Miracle Master Class with Tim Gorman
7-9 Mar 2005 Database Master Class with Chris Date
2-4 May 2005 SQL Server Master Class with Kimberly Tripp
----------------------------------------------------------------
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:
