Re: VMS - duplicating database

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 12 Mar 2003 20:38:07 +0100
Message-ID: <v23v6vobab3ahng19ges0jkmut0bdjpq6m@4ax.com>

On 12 Mar 2003 09:30:13 -0800, timasmith_at_hotmail.com (Tim Smith) wrote:

>Hi,
> I have a large 200GB database that I need to duplicate to another
>node. Does anyone have a procedure for this. I have a bunch of disks
>that I can backup the entire database to and I believe I can mount
>those on the second node (VMS guys do I need to reboot that node?).
> What do I have to do, apart from init.ora to 'point' the database
>to the new name?
>
>thanks
>
>Tim

Follow the procedure to clone a database which has been posted here many times before

issue alter database backup to trace on the source database. copy the trace file to the target node
edit when necessary
copy the files
run the trace file

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 12 2003 - 13:38:07 CST