Re: VMS - duplicating database

Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<v23v6vobab3ahng19ges0jkmut0bdjpq6m_at_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

I was searching for VMS specific stuff which produced little - but I have widened my search and will work with that.

>
> 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

Thanks Sybrand, your dedication to making the World an Oracle friendly place is legendary.

Tim Received on Wed Mar 12 2003 - 21:27:16 CST