This only works if you don't want to rename the database. Jared
On Sunday 30 March 2003 22:48, [EMAIL PROTECTED] wrote: > i saw this document on Metalink, it is possible to copy everything even > without creating the controlfiles!! > > * goal: How to copy an Oracle database to another machine > * fact: Oracle Server - Enterprise Edition > fix: Pre-requisites: The copy is between 2 machines, both have to be on the > same OS and have to have exactly the same database version installed. 1. > Make sure the database you want to copy was closed with a SHUTDOWN > IMMEDIATE, SHUTDOWN NORMAL or SHUTDOWN TRANSACTIONAL. 2. Copy init.ora and > control files to create instance and be able to go in mount mode. Check the > init.ora for the locations where the controlfiles have to be, if those > locations are not valid on the machine put the control files on different > places and adjust the init.ora accordingly. 3.a. Copy the datafiles (all of > them). b. Copy the redo-logfiles (all of them). 4.a. (Unix only) Set the > environment variables: ORACLE_SID - set to the database name you wish to > create ORACLE_HOME - set to full pathname of the Oracle system home > directory PATH - needs to include $ORACLE_HOME/bin b. (NT/2000 only) Do > 'set ORACLE_SID=<SID>' Use oradim to create the service for the instance. > For more information on oradim please refer to (the part that refers to > creating a new instance): Note:68720.1 Creating a new 7.3, 8.0, 8.1 > Instance/Database > <http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=68720.1>5. Use > servermanager (check the name to use for your version of oracle) or sqlplus > (version 9i and above) to startup the database in mount mode. Do CONNECT > INTERNAL/<PASSWORD> then STARTUP MOUNT Then do a rename of the copied > datafiles if they are not in the same path as on the other machine. For all > the files that are in the result of the query: SELECT NAME FROM V$DATAFILE; > do ALTER DATABASE RENAME FILE '<oldfullpath>\<filename>' to < > newfullpath>\<filename>'; 6. Query the datadictionary for the old location > of the redolog files using: SELECT MEMBER FROM V$LOGFILE; If the new place > is not the same as the old do: ALTER DATABASE RENAME FILE > '<oldfullpath>\<redologfilename>' to & lt;newfullpath>\<redologfilename>'; > 7. Now open the database: ALTER DATBASE OPEN; > > > <<Re: copying datafile nt4-w2k>> ---------------------------------------- Content-Type: message/rfc822; name="Attachment: 1" Content-Transfer-Encoding: 7bit Content-Description: Re: copying datafile nt4-w2k ---------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
