| 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 nocatalog - required maintenance on the control file
Peter
My understanding is that you can only indirectly affect the control file. Robert Freeman has a good paragraph on it in his book. Basically I think when the controlfile runs out of room, it first deletes backup records in excess of the CONTROL_FILE_RECORD_KEEP_TIME. If that doesn't free up enough space, then it expands the control file. The major rule is don't have C_F_R_K_T less than you will ever want to recover to. The second rule is don't bump C_F_R_K_T to a huge value because your control file might keep growing. The third rule is don't worry to much about the extra records in the control file because you probably can't affect it in a positive manner.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive."
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Schauss, Peter
Sent: Thursday, August 05, 2004 1:55 PM
To: oracle-l_at_freelists.org
Subject: RE: rman nocatalog - required maintenance on the control file
Does the setting of this parameter mean that records older than the specified number of days are deleted automatically or that they are candidates for reuse? The manual is a bit vague on this point.
In any event, CONTROL_FILE_RECORD_KEEP_TIME is set to 7 (days) on the database I am working with. The rman list backup command, however, shows backups going back to July 8 which was when I first began working with rman.
Thanks,
Peter Schauss
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS
Sent: Thursday, August 05, 2004 1:45 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: rman nocatalog - required maintenance on the control file
Peter
Take a look at the init.ora parameter CONTROL_FILE_RECORD_KEEP_TIME.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive."
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Schauss, Peter
Sent: Thursday, August 05, 2004 12:23 PM
To: Oracle-L (E-mail)
Subject: rman nocatalog - required maintenance on the control file
I am preparing to use rman in nocatalog mode for my daily backups. I know that the control file will record information about the backups which I have done. Should I plan to purge information about old backups from the control files at regular intervals?
Thanks,
Peter Schauss
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |