From oracle-l-bounce@freelists.org Fri Jun 18 10:20:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5IFKRe15391 for ; Fri, 18 Jun 2004 10:20:43 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5IFKG615353 for ; Fri, 18 Jun 2004 10:20:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 08D2772C4BA; Fri, 18 Jun 2004 10:04:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27289-51; Fri, 18 Jun 2004 10:04:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53EC472C2E2; Fri, 18 Jun 2004 10:04:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 18 Jun 2004 10:02:59 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F3D1172C4A2 for ; Fri, 18 Jun 2004 10:02:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26446-99 for ; Fri, 18 Jun 2004 10:02:57 -0500 (EST) Received: from mail54.messagelabs.com (mail54.messagelabs.com [216.82.244.35]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 6605F72C4C9 for ; Fri, 18 Jun 2004 10:02:56 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: roger_xu@dp7uptx.com X-Msg-Ref: server-6.tower-54.messagelabs.com!1087572221!6687066 X-StarScan-Version: 5.2.10; banners=dp7uptx.com,-,- X-Originating-IP: [216.136.17.254] Received: (qmail 14352 invoked from network); 18 Jun 2004 15:23:42 -0000 Received: from unknown (HELO mail.dp7uptx.com) (216.136.17.254) by server-6.tower-54.messagelabs.com with SMTP; 18 Jun 2004 15:23:42 -0000 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Subject: RMAN and control_file_record_keep_time Date: Fri, 18 Jun 2004 10:23:38 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: RMAN and control_file_record_keep_time Thread-Index: AcRT76Wae7aYlp5MRvC4kYfSq6r1QABWGrtgAAAHnAAFrom: "Roger Xu" To: "Oracle-L@Freelists. Org (E-mail)" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3050 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: roger_xu@dp7uptx.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l From: oracle-l-bounce@freelists.org X-Virus-Scanned: by amavisd-new at freelists.org 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@dp7uptx.com. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------