100% correct
<<Re: copying datafile nt4-w2k>>
--- Begin Message ---
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
----------------------------------------
--- End Message ---
