Re: about database copy??

From: Dennis <dwehlman_at_my-deja.com>
Date: Wed, 20 Dec 2000 12:04:17 GMT
Message-ID: <91q780$q1h$1@nnrp1.deja.com>

To modify or create a control file run

alter database backup controlfile to trace; -- dumps controlfile data to udump destination

Modify trace file and run it within svrmgrl to create new control files.

Dennis

In article <91pi8u$e55$1_at_news.nsysu.edu.tw>, "kk" <hsy1106_at_kcg.url.com.tw> wrote:
> hi all
> i want to copy the all database to another directory
> but i wnat to change the sid.
> it means that the two database are the same besides the sid
> here r my steps
> 1.backup controlfile to trace
> 2.shutdown database
> 3.copy all datafiles,redo log files,controlfiles
> 4.modify the control file
> 5.svrmgrl
> 6.connect internal
> 7.run the control file
>
> any one can tell me 4.how to modify the control file
> any one can help me
> thank u very much
> kk
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 06:04:17 CST