Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rman, init.ora, spfile???

RE: rman, init.ora, spfile???

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 29 Mar 2004 14:55:08 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B0030B@EXCHMN3>


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_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paula_Stankus_at_doh.state.fl.us
Sent: Monday, March 29, 2004 2:43 PM
To: oracle-l_at_freelists.org
Cc: Rich.Jesse_at_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_at_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_at_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
Received on Mon Mar 29 2004 - 14:55:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US