Re: Ocopy and Archived Logs

From: joel garry <joel-garry_at_home.com>
Date: Mon, 14 Dec 2009 09:41:54 -0800 (PST)
Message-ID: <373074ae-644d-4471-a006-e6271282cb8e_at_z10g2000prh.googlegroups.com>

On Dec 14, 7:50 am, Gary <gjwater..._at_gmail.com> wrote:

>
> This section comes last in the backup script, just before the the
> logfile is switched. I'm not sure what is meant by "keeptime is longer
> than the age of the oldest archivelog"; does this mean the controlfile
> should be backed up /first/ in the script?
>

There is an entry in the system reference manual for an alter system command called CONTROL_FILE_RECORD_KEEP_TIME "...specifies the minimum number of days before a reusable record in the control file can be reused."

The default is 7 days, which is entirely too short for many places. Google about for opinions on how this should be set for different ways of dealing with archived logs like
http://mrothouse.wordpress.com/2006/11/06/oracle9i-control_file_record_keep_time/ Personally, I set it to 30 and then figure out what it should be with management sign-off on a given retention policy.

jg

--
_at_home.com is bogus.
http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf

Received on Mon Dec 14 2009 - 11:41:54 CST