RE: Is DATAFILE order important in CREATE CONTROLFILE?
Thanks all for your responses. I'll go by "the order doesn't matter". Let's see if I can hose up our dev DB with this now... ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > Sent: Thursday, April 11, 2002 3:13 PM > To: Multiple recipients of list ORACLE-L > > > I'm writing a Perl script to automate the procedure to create > a copy of an > 8.1.7 production DB to a development server. Both production > and dev are > HP/UX 11.0. > > In doing this, I've created a file that cross-references where the > production datafiles are and where they are to be placed in dev. This > works > fine, but I also wanted to dynamically create the CREATE CONTROLFILE > statement for the "new" dev DB. > > I've noticed that the DATAFILE clause does not have the > SYSTEM tablespace's > datafile first, nor are any of the other datafiles in the > same order that > they are in production (e.g. from the output of an ALTER SYSTEM BACKUP > CONTROLFILE TO TRACE). Does this matter? Does the order need to be > preserved? > > I suppose I'll end up dynamically creating the > cross-reference file, which > would preserve the order, but now I'm curious. > > TIA! > > Rich Jesse System/Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is DATAFILE order important in CREATE CONTROLFILE?
Hi I hope it doesn't matter. We have been using dynamically created "create controlfile" for years now to copy production DB to test/developnment. I believe the files are alfabetical in our case. jack "Hand, Michael T" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> om> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Is DATAFILE order important in CREATE CONTROLFILE? [EMAIL PROTECTED] 11-04-2002 22:53 Please respond to ORACLE-L Rich, I believe the datafile order in a CREATE CONTROLFILE statement is critical, from lowest FILE# to highest. I'd be reluctant to prove myself wrong by testing our database copy process (I used sed to map the datafiles.), but we are moving 500-600Gb databases around and rerunning it would require another 25hr window ;) -Original Message- Sent: Thursday, April 11, 2002 3:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te ret
RE: Is DATAFILE order important in CREATE CONTROLFILE?
I wouldn't rely on a list generated from doing an ls on a directory because there may very well be files in that directory that are not part of the database (like files that used to be part of the db but not any more). I have a Perl script that queries dba_data_files on both source and target db's to get file info. I have another Perl script that generates the mappping information for me. This script also reports on differences (very helpful). I take the trace file from running "alter database backup controlfile to trace;" on the source db and run it through another Perl script that generates the "ready-to-use" sql script that gets the refreshed target db to the "ready-to-be-recovered" state. So, yes, order doesn't matter. HTH Gerardo -Original Message- Sent: Thursday, April 11, 2002 3:28 PM To: Multiple recipients of list ORACLE-L No, the order does not matter. We create control files frequently when we clone from production to test and development. We use this piece of code to generate the listing in Korn Shell: ls /*/oradata/SID/*.dbf | while read FN; do echo "'"$FN"',"; done Of course you will have to replace the final comma with a semi-colon. Good luck. --Michael -Original Message- Sent: Thursday, April 11, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Rich, I believe the datafile order in a CREATE CONTROLFILE statement is critical, from lowest FILE# to highest. I'd be reluctant to prove myself wrong by testing our database copy process (I used sed to map the datafiles.), but we are moving 500-600Gb databases around and rerunning it would require another 25hr window ;) -Original Message- Sent: Thursday, April 11, 2002 3:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael - EDS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Is DATAFILE order important in CREATE CONTROLFILE?
Rich - I frequently clone our production database to test. Since the location of the files is different, I usually end up editing the CREATE CONTROLFILE in a major way, resorting the contents sometimes to the name of the datafile and sometimes sorted to the location. We have about 200 datafiles. I have not experienced any ill effects from these changes, but it never occurred to me that it might. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 1:50 PM To: '[EMAIL PROTECTED]' Jesse - No, order isn't important. This is a relational database after all - right? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 2:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is DATAFILE order important in CREATE CONTROLFILE?
Rich, Interesting one, but the order of files in the CCF really does NOT matter. As far as I could observe, Oracle is able to determine the file number from the datafile header and arrange itself. I regularly clone a 125Gb/205 file (and growing) Apps Database from one server to another and wildly run around for re-locating files in different directories as they grow. I create the CCF from a 'ls -1 /u*/oradata//*' appended to a previous part of an older CCF. This captures any new files into the CCF in the _right_ location without me having to create a new ccf by hand every time. A subsequent backup controlfile shows that actual order as it should have been, not necessarily the order in which the previous ccf was created. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -Original Message- > From: Hand, Michael T [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 11, 2002 1:54 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Is DATAFILE order important in CREATE CONTROLFILE? > > > Rich, > > I believe the datafile order in a CREATE CONTROLFILE > statement is critical, > from lowest FILE# to highest. I'd be reluctant to prove > myself wrong by > testing our database copy process (I used sed to map the > datafiles.), but we > are moving 500-600Gb databases around and rerunning it would > require another > 25hr window ;) > > -Original Message- > Sent: Thursday, April 11, 2002 3:13 PM > To: Multiple recipients of list ORACLE-L > > > I'm writing a Perl script to automate the procedure to create > a copy of an > 8.1.7 production DB to a development server. Both production > and dev are > HP/UX 11.0. > > In doing this, I've created a file that cross-references where the > production datafiles are and where they are to be placed in > dev. This works > fine, but I also wanted to dynamically create the CREATE CONTROLFILE > statement for the "new" dev DB. > > I've noticed that the DATAFILE clause does not have the > SYSTEM tablespace's > datafile first, nor are any of the other datafiles in the > same order that > they are in production (e.g. from the output of an ALTER SYSTEM BACKUP > CONTROLFILE TO TRACE). Does this matter? Does the order need to be > preserved? > > I suppose I'll end up dynamically creating the > cross-reference file, which > would preserve the order, but now I'm curious. > > TIA! > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, > Sussex, WI USA > -- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hand, Michael T > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is DATAFILE order important in CREATE CONTROLFILE?
No, the order does not matter. We create control files frequently when we clone from production to test and development. We use this piece of code to generate the listing in Korn Shell: ls /*/oradata/SID/*.dbf | while read FN; do echo "'"$FN"',"; done Of course you will have to replace the final comma with a semi-colon. Good luck. --Michael -Original Message- Sent: Thursday, April 11, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Rich, I believe the datafile order in a CREATE CONTROLFILE statement is critical, from lowest FILE# to highest. I'd be reluctant to prove myself wrong by testing our database copy process (I used sed to map the datafiles.), but we are moving 500-600Gb databases around and rerunning it would require another 25hr window ;) -Original Message- Sent: Thursday, April 11, 2002 3:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael - EDS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Is DATAFILE order important in CREATE CONTROLFILE?
Rick, I believe the order of the datafiles in the BACKUP CONTROLFILE TO TRACE comes from the file# in V$DBFILE. If you select from v$dbfile there is no guarantee the list will be in order of the file# and the file# is not the order in which the datafiles were created. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 04/11/02 04:03PM >>> Order of files in alter system backup... does not matter. Wow using Perl to do this when then procedure is documented a 1000 times over. I am sure you have some very good reason. Automating something that I would think is not very frequent may be overkill. Oh well enjoy. Rick "Jesse, Rich" world.com> cc: Sent by: Subject: Is DATAFILE order important in CREATE CONTROLFILE? [EMAIL PROTECTED] m 04/11/2002 03:13 PM Please respond to ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you wan t to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOV
RE: Is DATAFILE order important in CREATE CONTROLFILE?
Rich, I believe the datafile order in a CREATE CONTROLFILE statement is critical, from lowest FILE# to highest. I'd be reluctant to prove myself wrong by testing our database copy process (I used sed to map the datafiles.), but we are moving 500-600Gb databases around and rerunning it would require another 25hr window ;) -Original Message- Sent: Thursday, April 11, 2002 3:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is DATAFILE order important in CREATE CONTROLFILE?
But you assume too much. We have three copies of our production system to three different test/dev/playground databases. First, is our nightly hot backup that gets started up as a new instance (on the prod server) for our users as a playground after the datafiles are put to tape. Second is our weekly test backup to a dev server. And third is an on-demand (quarterly or less) copy to the dev area on the dev server. And, no I don't think this scheme is necessarily a good idea, but I've been out-voted many times. And all this is why I'm making a very flexible set of Perl scripts -- to handle these situations and more with less maintenance work in the long-run. :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 11, 2002 3:03 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Is DATAFILE order important in CREATE CONTROLFILE? > > > > Order of files in alter system backup... does not matter. > Wow using Perl > to do this when then procedure is documented a 1000 times > over. I am sure > you have some very good reason. Automating something that I > would think is > not very frequent may be overkill. Oh well enjoy. > > Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is DATAFILE order important in CREATE CONTROLFILE?
Jesse - No, order isn't important. This is a relational database after all - right? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 2:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Is DATAFILE order important in CREATE CONTROLFILE?
Order of files in alter system backup... does not matter. Wow using Perl to do this when then procedure is documented a 1000 times over. I am sure you have some very good reason. Automating something that I would think is not very frequent may be overkill. Oh well enjoy. Rick "Jesse, Rich" world.com> cc: Sent by: Subject: Is DATAFILE order important in CREATE CONTROLFILE? [EMAIL PROTECTED] m 04/11/2002 03:13 PM Please respond to ORACLE-L I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is DATAFILE order important in CREATE CONTROLFILE?
I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. This works fine, but I also wanted to dynamically create the CREATE CONTROLFILE statement for the "new" dev DB. I've noticed that the DATAFILE clause does not have the SYSTEM tablespace's datafile first, nor are any of the other datafiles in the same order that they are in production (e.g. from the output of an ALTER SYSTEM BACKUP CONTROLFILE TO TRACE). Does this matter? Does the order need to be preserved? I suppose I'll end up dynamically creating the cross-reference file, which would preserve the order, but now I'm curious. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).