Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 9416 invoked from network); 12 Sep 2007 10:37:46 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 12 Sep 2007 10:37:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 07A837417FF; Wed, 12 Sep 2007 10:59:00 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29399-05; Wed, 12 Sep 2007 10:58:59 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66BDF741763; Wed, 12 Sep 2007 10:58:59 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 12 Sep 2007 10:14:27 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8EB8174186F for ; Wed, 12 Sep 2007 10:14:27 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18734-03-15 for ; Wed, 12 Sep 2007 10:14:27 -0400 (EDT) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.251]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5C22474189C for ; Wed, 12 Sep 2007 10:14:27 -0400 (EDT) Received: by an-out-0708.google.com with SMTP id b36so44051ana for ; Wed, 12 Sep 2007 07:53:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:from; bh=mCvUJkCKpebRrrNIHTUoR3u9jeiadcSQcrUrZlDKcoQ=; b=oVvwDi+fS4cQFsXZuUcHpD7MOEFik+M/oNKNIolhRQea3+87iPdNEiNqTczwya/SmuWu8tN5ON64/vYEWetP4Q+zQyvw6I9dLGoggI5bD4VMnjl8TEasprrOnBRTtGSaFgDFF6PgI0yz6Od/swJVury34SNpIU8kxU8fdzicFxk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:from; b=YtAyA8UVXBkH1HVK42ORlLuA6ssd46KQCu/JN/xTc2GbyLVrlaYePqkc8vjzmXq+puI2PX/DF3BvAfge3XKSsX2orCPK+2C9lw2j7mHGiplMoPgf6xHnevy37lIr/H7Xk+o43XoqcL+pnuGDuoWzLAFbcMhsatHAzBc0y4p6DDI= Received: by 10.100.139.12 with SMTP id m12mr8406655and.1189608789292; Wed, 12 Sep 2007 07:53:09 -0700 (PDT) Received: from ?63.101.102.74? ( [63.101.102.74]) by mx.google.com with ESMTPS id 8sm16630nzn.2007.09.12.07.53.01 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 12 Sep 2007 07:53:06 -0700 (PDT) Message-ID: <46E7FD44.2020901@inbox.lv> Date: Wed, 12 Sep 2007 07:52:52 -0700 User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: lyallbarbour@sanfranmail.com CC: oracle-l@freelists.org Subject: Re: controlfiles being updated References: <20070911133643.B8CFF1158CC@ws1-7.us4.outblaze.com> In-Reply-To: <20070911133643.B8CFF1158CC@ws1-7.us4.outblaze.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed From: GovindanK X-archive-position: 1472 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: gkatteri@gmail.com Precedence: normal Reply-to: gkatteri@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Others have given lots of details. V$views get their info from control file. When the database role is switched from Primary to Standby and vice-versa is another example. When a log shipped to the standby is applied the control file gets updated too. Checkpoint info is stored for tracking consistency etc etc. HTH GovindanK Lyall Barbour wrote: > Hi all, > Just a general question about controlfiles. I was ready the archive messages for this list and found out that controlfiles are updated everytime a checkpoint happens. Can anyone list any other reasons an update would happen to the controlfiles? > > Thanks, > Lyall Barbour > > -- http://www.freelists.org/webpage/oracle-l