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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
HUH?

Report message to a moderator

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: 68686
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

Report message to a moderator

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

Report message to a moderator

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: 68686
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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Problem in procedure ORA-03113: end-of-file on communication channel
Next Topic: ORA-00600: internal error code, arguments: [kqrfrpo]
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:18:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.