RE: rman nocatalog - required maintenance on the control file
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Aug 2004 14:02:21 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Schauss, Peter
Sent: Thursday, August 05, 2004 1:55 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS
Sent: Thursday, August 05, 2004 1:45 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
