RE: RMAN without a repository

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Tue, 10 Apr 2007 15:26:03 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45071FDA1E@NT15.oneneck.corp>

It all depends on how many backups you run, how many backup pieces, files, logs, etc. control_file_record_keep_time is just the "minimum number of days before a reusable record in the control file can be reused". Mine is currently set to the default value of 7, yet I still have backups from 10 months ago in my control file because I only run weekly cold backups on this database and my control files are only 8MB  

SQL> show parameter record

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
control_file_record_keep_time        integer     7
 
 

SQL> select min(start_time) from v$backup_set; MIN(START

---

20-JUN-06     SQL> select block_size*file_size_blks from v$controlfile; BLOCK_SIZE*FILE_SIZE_BLKS

---

                  8126464
                  8126464

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan_gaffuri_at_comcast.net    

however, if I set the control_file_record_keep_time to 1000 days, shouldn't that keep 1000 days worth of backup data so I can still restore from tape?  

will control files really get that big? aren't they just keeping some data for rman. This can't be more than a few megabytes at most even with 1000 days worthof backups?  

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 10 2007 - 17:26:03 CDT