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

Home -> Community -> Usenet -> c.d.o.server -> Re: moving a database

Re: moving a database

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 11 Feb 2000 21:07:44 GMT
Message-ID: <38a479b5.10256820@news.earthlink.net>


Unix has a tar command :)
If you're architecture is the same (disks) it's fairly easy, just copy the files to the same locations on the second machine, and start the database (datafiles, control files, init files, redo files)

Otherwise you'll need to explore the
ALTER DATABASE BACKUP CONTROLFILE TO TRACE command (so that you can place files in differenct dirs)

On Fri, 11 Feb 2000 21:52:38 +0100, =?iso-8859-1?Q?H=E5kan?= Wahlberg <hakan.wahlberg_at_bol.boliden.se> wrote:

>Sorry, it's an Oracle 8.1.5 on Windows NT 4.0. What difference would the OS
>make?
>/Håkan W
>
>NetComrade wrote:
>
>> what OS?
>> On Fri, 11 Feb 2000 16:17:42 +0100, =?iso-8859-1?Q?H=E5kan?= Wahlberg
>> <hakan.wahlberg_at_boliden.se> wrote:
>>
>> >How do I move a database (instance) with all its files from one disk to
>> >another.
>> >/Håkan W
>> >
>> >
>>
>> ---------------
>> In case I forgot to mention:
>> We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes
>> ---------------
>> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
>> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>



In case I forgot to mention:
We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes
Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email
Received on Fri Feb 11 2000 - 15:07:44 CST

Original text of this message

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