Home » RDBMS Server » Server Administration » control_file_record_keep_time
control_file_record_keep_time [message #257308] Wed, 08 August 2007 01:25 Go to next message
alantany
Messages: 115
Registered: July 2007
Senior Member

Hi,all!
I want to know if control_file_record_keep_time will limit the keep time of backup infomation of RMAN in contolfile.
THX!
Regards.
Alan
Re: control_file_record_keep_time [message #257311 is a reply to message #257308] Wed, 08 August 2007 01:26 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
HUH?
Re: control_file_record_keep_time [message #257321 is a reply to message #257308] Wed, 08 August 2007 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It gives a threshold from where Oracle can reuse the entries.
Among these entries there are RMAN ones.

Regards
Michel
Re: control_file_record_keep_time [message #257340 is a reply to message #257321] Wed, 08 August 2007 02:21 Go to previous messageGo to next message
alantany
Messages: 115
Registered: July 2007
Senior Member

Thanks!
Assume that control_file_record_keep_time is set to 7 days,so Rman which use control for catalog can only keep 7 days backup info?
Regards!
Alan
Re: control_file_record_keep_time [message #257358 is a reply to message #257340] Wed, 08 August 2007 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
At least 7 days.
If Oracle does not need to reuse the entries, it does not erase them.

Regards
Michel
Re: control_file_record_keep_time [message #257477 is a reply to message #257358] Wed, 08 August 2007 07:57 Go to previous messageGo to next message
alantany
Messages: 115
Registered: July 2007
Senior Member

Thanks!Michel.
Alan
Re: control_file_record_keep_time [message #278575 is a reply to message #257308] Mon, 05 November 2007 01:35 Go to previous message
halfydba
Messages: 20
Registered: November 2007
Location: Australia
Junior Member
Beware of setting this value too big. You cannot "shrink" a controlfile, you can only recreate it. If you say, set it to 365 days your controlfile will maintain an huge amount of backup information and your controlfile could grow very very large. This could/probably lead to controlfile enqueue issues. If you want to store more than 7 days worth of backup information, best setup a recovery catalog.
Previous Topic: Problem in procedure ORA-03113: end-of-file on communication channel
Next Topic: ORA-00600: internal error code, arguments: [kqrfrpo]
Goto Forum:
  


Current Time: Sun Dec 04 08:28:49 CST 2016

Total time taken to generate the page: 0.06733 seconds