Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 25346 invoked from network); 12 Sep 2007 11:42:50 -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 11:42:48 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98D4D740229; Wed, 12 Sep 2007 12:04:04 -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 12593-09; Wed, 12 Sep 2007 12:04:04 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1284F73FA89; Wed, 12 Sep 2007 12:04:04 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 12 Sep 2007 11:19:32 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1D09173FEF4 for ; Wed, 12 Sep 2007 11:19:32 -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 00832-04 for ; Wed, 12 Sep 2007 11:19:32 -0400 (EDT) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.246]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A954473FECF for ; Wed, 12 Sep 2007 11:19:26 -0400 (EDT) Received: by an-out-0708.google.com with SMTP id b36so50193ana for ; Wed, 12 Sep 2007 08:58:03 -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:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=NfZYO5pZjccX8BW1qrH2F2/QQ+bNpQEgcUDGEmqxDJE=; b=l3wsrNmJ6zjP4FIF4f6deKccmY9I4Ola/KVbWvH1VLLTHzAXPt4OzE/53EGbW8QzrZ7+vqHSAle0EonKKJ2KRhV+EVccaalkkcC9olNn7ClOLUWSThgGW+LWfvWIyzUqzirb3Ew9zB07RnF1WOr+BAq1l0aDyNP4KA6ql/gddx8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=XI6HNmITAt20iejdqW3yVJ5z8j+2Yl8G/3Ap9jcc5KMorQNdMjxgHEmKOdoBYaa66lImsnVCbjkhF+9JImous0B3uiOilyyVWyFXBfAP2Yw2DuC99zv7uIlQKvowSK5WMQtAr5/A027RIFd80blDZQGuoMSfzFGdA0wWuaIB5CM= Received: by 10.100.121.12 with SMTP id t12mr8517022anc.1189612683730; Wed, 12 Sep 2007 08:58:03 -0700 (PDT) Received: from ?10.128.32.182? ( [12.164.102.7]) by mx.google.com with ESMTPS id 18sm507776nzo.2007.09.12.08.58.01 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 12 Sep 2007 08:58:01 -0700 (PDT) Message-ID: <46E80CA3.8030709@gmail.com> Date: Wed, 12 Sep 2007 11:58:27 -0400 From: fmhabash 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 X-archive-position: 1477 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: fmhabash@gmail.com Precedence: normal Reply-to: fmhabash@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 When you know what's in it, you can infer the events that touch it. SQL> select type from v$controlfile_record_section TYPE -------------------- DATABASE CKPT PROGRESS REDO THREAD REDO LOG DATAFILE FILENAME TABLESPACE TEMPORARY FILENAME RMAN CONFIGURATION LOG HISTORY OFFLINE RANGE ARCHIVED LOG BACKUP SET BACKUP PIECE BACKUP DATAFILE BACKUP REDOLOG DATAFILE COPY BACKUP CORRUPTION COPY CORRUPTION DELETED OBJECT PROXY COPY BACKUP SPFILE DATABASE INCARNATION -- http://www.freelists.org/webpage/oracle-l