RE: RMAN recovery window and control_file_record_keep_time
Date: Tue, 25 Oct 2016 16:03:57 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F1369C013E5_at_NC2PWEX504.us.ad.lfg.com>
I will be interested in what others say about this as well. I have always practiced setting my controlfile_record_keep_time longer than my retention. While we use a recovery catalog for centralizing backup data, I also like to keep metadata in my controlfile. Of course, this may cause some controlfile growth but it has to be pretty minimal. If I ever "lost" my recovery catalog, I would want all the information I need going back past my recovery window stored in the controlfile as well.
Chris..
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Ndolo Intertek
Sent: Tuesday, October 25, 2016 11:58 AM
To: ORACLE-L
Subject: RMAN recovery window and control_file_record_keep_time
Recently we changed our backup policy with RECOVERY WINDOW OF 3 DAYS.
The control_file_record_keep_time still remains at 7.
Is this something we need to be concerned about?
No issues but I wanted to see if we have a potential of some sort of risk down the road.
And I am happy to finally be able to post on the list.
So this is my introduction :)
William Ndolo
Valued Quality. Delivered.
Intertek is dedicated to Customer Service and welcomes your feedback. Please visit http://www.intertek.com/email-feedback/ to send us your suggestions or comments. We thank you for your time.
Except where explicitly agreed in writing, all work and services performed by Intertek is subject to our Standard Terms and Conditions of Business which can be obtained at our website: http://www.intertek.com/terms/ Should you have any difficulty obtaining these from the web site, please contact us immediately and we will send a copy by return.
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**
CONFIDENTIALITY NOTICE
This e-mail may contain confidential or privileged information, if you are not the intended recipient, or the person responsible for delivering the message to the intended recipient then please notify us by return e-mail immediately. Should you have received this e-mail in error then you should not copy this for any purpose nor disclose its contents to any other person.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 25 2016 - 18:03:57 CEST