From oracle-l-bounce@freelists.org Mon Mar 29 14:55:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2TKtgJ13660 for ; Mon, 29 Mar 2004 14:55:42 -0600 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 i2TKtgo13655 for ; Mon, 29 Mar 2004 14:55:42 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1933B634805; Mon, 29 Mar 2004 15:52:01 -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 09778-89; Mon, 29 Mar 2004 15:52:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B58C63480E; Mon, 29 Mar 2004 15:51:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 29 Mar 2004 15:50:44 -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 09CFC634757 for ; Mon, 29 Mar 2004 15:50:44 -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 08773-78 for ; Mon, 29 Mar 2004 15:50:43 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 5FED463463D for ; Mon, 29 Mar 2004 15:50:42 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 29 Mar 2004 20:58:35 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B0030B@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: rman, init.ora, spfile??? Date: Mon, 29 Mar 2004 14:55:08 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2011 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Paula - My understanding (just working from what somebody told me and I haven't checked the documentation) is that if the database uses the spfile, that single file will always be used when starting up the database. This was one of the purposes of spfile, to get away from the need to have distributed init.ora files. A simple test should suffice to verify that statement. Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Paula_Stankus@doh.state.fl.us Sent: Monday, March 29, 2004 2:43 PM To: oracle-l@freelists.org Cc: Rich.Jesse@qtiworld.com Subject: RE:rman, init.ora, spfile??? Guys, When I first setup rman on a centralized remote server I had to ensure that I had a copy of the init file for the target databases locally stored under $ORACLE_HOME/dbs..... With spfiles - yadayada - is there a better way to handle this then saying "hey, when you change the init file - move a copy to the backup server/host" - or automated a script to do this? Is there some better way to do this with spfile??????? Like - start rman, connect to target - produce init...file from spfile????? - ???? Thanks, Paula ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------