Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving a database
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
>
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Fri Feb 11 2000 - 15:07:44 CST