RMAN and control_file_record_keep

From: <oracle-l-bounce_at_freelists.org>
Date: Fri, 18 Jun 2004 10:23:38 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F702D4EECB@irv2kexch01>

Hi,

My control_file_record_keep_time is set to 30 days.

Why I am still seeing the following in the alert log file? "kccrsz: expanded controlfile section 15 from 12574 to 12789 records requested to grow by 127 record(s); added 2 block(s) of records"

The database is 9 month old andw e did not change the frequency of backups;
The number of archived redo log files that are generated does not change much;
And the retention period for RMAN records stays the same.

RMAN> show all;

using target database controlfile instead of recovery catalog RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/oracle/PR2/920_64/dbs/snapcf_PR2.f'; # default

RMAN> exit

Thanks,

Roger Xu

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Jun 18 2004 - 10:20:43 CDT

RMAN and control_file_record_keep_time