Re: Copy database
From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 28 Nov 2000 21:18:59 GMT
Message-ID: <9017fq$eoc$1_at_nnrp1.deja.com>
Date: Tue, 28 Nov 2000 21:18:59 GMT
Message-ID: <9017fq$eoc$1_at_nnrp1.deja.com>
In article <8vlvb1$a4l$1_at_reader1.imaginet.fr>,
"Raul" <benkira0_at_hotmail.com> wrote:
> Hi All
> How can i copy one oracle database to a remote host?
> can i make a copy of the database on CD_ROM and install it into an other
> host?
> which files i need to copy?
> Thanks
>
It's described in Database Administration documentation. In short, you
have to run alterdatabase backup controlfile to trace command. The trace
file created will contain create controlfile command. Then you copy all
datafiles and redo log files to the new host and run that create
controlfile command. You can open database after that.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 28 2000 - 22:18:59 CET