Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 28163 invoked from network); 6 Jun 2008 14:43:24 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 6 Jun 2008 14:43:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D0B7F85AB76; Fri, 6 Jun 2008 15:37:53 -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 17351-01; Fri, 6 Jun 2008 15:37:53 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 46E5F85AAC2; Fri, 6 Jun 2008 15:37:53 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 06 Jun 2008 14:58:58 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98C5C85B221 for ; Fri, 6 Jun 2008 14:58:58 -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 12243-05 for ; Fri, 6 Jun 2008 14:58:58 -0400 (EDT) Received: from NT15.oneneck.corp (dot092host.oneneck.net [63.226.42.92]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0745885B34F for ; Fri, 6 Jun 2008 14:58:55 -0400 (EDT) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8C807.F7E0F640" Subject: RE: rman configuration Date: Fri, 6 Jun 2008 12:03:12 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C450BF62587@NT15.oneneck.corp> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Priority: normal Thread-Topic: rman configuration References: From: "Allen, Brandon" To: , , X-archive-position: 8659 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-to: Brandon.Allen@OneNeck.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 ------_=_NextPart_001_01C8C807.F7E0F640 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable That's mostly correct, just backwards on one point - it's to sync the catalog from the controlfile (the authoritative source), not the other way around. But you are correct that it's just a temp file not needed for restore/recovery operations, so to the OP - no need to change it. In fact, I don't think you can change it to tape. Maybe you're confusing the snapshot controlfile with controlfile autobackup? They are two completely different things and your controlfile autobackup goes to two places: =20 1) On disk to $ORACLE_HOME/dbs (by default) whenver you make a change to your database structure (add datafile, tablespace, logfile, etc.) 2) To the same channel type as an rman backup, i.e. if you run a database or log backup to sbt_tape and have controlfile autobackup ON, then it will automatically run a controlfile autobackup to sbt_tape after the completion of the database/log backup. =20 Regards, Brandon=20 Privileged/Confidential Information may be contained in this message or = attachments hereto. Please advise immediately if you or your employer do = not consent to Internet email for messages of this kind. Opinions, = conclusions and other information in this message that do not relate to = the official business of this company shall be understood as neither = given nor endorsed by it. ------_=_NextPart_001_01C8C807.F7E0F640 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
That's mostly correct, just backwards = on one=20 point - it's to sync the catalog from the controlfile (the=20 authoritative source), not the other way around.  But you are = correct that=20 it's just a temp file not needed for restore/recovery operations, so to = the OP -=20 no need to change it.  In fact, I don't think you can = change it to=20 tape.  Maybe you're confusing the snapshot controlfile = with=20 controlfile autobackup?  They are two completely different = things=20 and your controlfile autobackup goes to two places:
 
1) On disk to $ORACLE_HOME/dbs (by default) = whenver you=20 make a change to your database structure (add datafile, tablespace, = logfile,=20 etc.)
2) To the same channel type as an = rman backup, i.e. if=20 you run a database or log backup to sbt_tape and have controlfile=20 autobackup ON, then it will automatically run a controlfile autobackup = to=20 sbt_tape after the completion of the database/log=20 backup.
 
Regards,
Brandon =

Privileged/Confidential Information may be contained in this message = or attachments hereto. Please advise immediately if you or your employer = do not consent to Internet email for messages of this kind. Opinions, = conclusions and other information in this message that do not relate to = the official business of this company shall be understood as neither = given nor endorsed by it.

 ------_=_NextPart_001_01C8C807.F7E0F640-- -- http://www.freelists.org/webpage/oracle-l