| control file shrink? [message #51990] |
Tue, 25 June 2002 01:37  |
Marks
Messages: 11
Registered: February 2002
|
Junior Member |
|
|
Oracle 8.1.7 HPUX 11
After heavy redo activity the control files of our database have grown to 44mb. This is causing some problems related to file system space.
Is it possible to shrink the control file ?
I know there is a control_file_record_keep parameter, but if I set this to zero days as instead of the current setting of 30 would the control file shrink ?
What are the consequences of truncating the info in the control file ?
|
|
|
|
| Re: control file shrink? [message #52027 is a reply to message #51990] |
Wed, 26 June 2002 15:48  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Yes, it will shrink, since the information in the control file will be retained for less time.
That might impact, RMAN if you are using it, since RMAN is using the control file for backup/restore information.
Hope that helps,
clio_usa
OCP - DBA
Visit our web site [url=http://www.dbaclick.com]Click Here
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
