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>>
--- Begin Message ---
Yes, the database is down while doing this.
Opening the database and creating a controlfile works,
but I really didn't expect recovery on an 8.0 database
to work with 8i executables.
Jared
On Friday 28 March 2003 11:38, Jeffrey Beckstrom wrote:
> Presuming this is a cold backup. I recall trying it about a year or so ago
> with a hot backup and had a problem with recovery not knowing when to stop
> - it kept wanting more log files.
>
> >>> [EMAIL PROTECTED] 3/28/03 1:43:41 PM >>>
>
> Certainly possible.
>
> I'm currently copying 8.0 files on NT to Win2k servers with
> 8.1.7 installed. Rebuild the controlfile, open the database
> and upgrade. Works great.
>
> Jared
>
> On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote:
> > hi all
> >
> > We are planning an upgrade from NT4 to W2K.
> > I am considering to create a new instance on another server with W2K
> > installed and copying the datafiles
> > from the server with NT4 on it.
> > Is this possible ? Or do i have to use the exp/imp strategy ?
> >
> > thanks
> >
> > vr.gr.
> > Geo Kor
> > Sr. System Engineer I&DM Db
> > RDW Voertuiginformatie en -toelating
> > Holland
----------------------------------------
Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML
----------------------------------------
--
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).
--- End Message ---
