Re: Copy database?

Thanks David - spot on. That was exactly what I was looking for. Worked first time. My last Oracle DBA course was back on 7.3, and I just didn't remember or see in the docs the "CREATE CONTROLFILE SET" command! :)

Thanks to everyone for their assistance.

"David Cabrey" <david.cabrey_at_pnl.gov> wrote in message news:a870dfaa.0403191109.6f4a903e_at_posting.google.com...
> User the 'alter database backup controlfile to trace' feature. Run
> this on the existing database. This command will put a trace file in
> the SID's udump area. The file name is like any other trace name...
> so look for the most recent one and copy it somewhere. Edit the
> comment information at the top out. At the first line where it
> says....
>
> CREATE CONTROLFILE REUSE DATABASE "SOMESIDNAME" NORESETLOGS...
>
> change the REUSE to SET and give the new sid name.
>
> Then make sure ALL the files in the command below map to the correct
> location of the new database you are creating new control files for.
>
> Change your oracle environment to point to the new sid... sys as
> sysdba into sqlplus and run the commands in the control file trace you
> just edited.
>
> Note -- there are two CREATE CONTROLFILE statements in a 9i trace dump
> of this type. The first one DOES NOT DO a reset log... the second one
> does. You will have to use the reset log when SETting a new SID name.
> So make sure you look at the entire trace dump file before doing
> anything to seperate these two commands.
>
> This command will create new control files and place them in the
> location specified by the init.ora file... so make sure the control
> files are not there before running this.
>
> dave
Received on Mon Mar 22 2004 - 08:27:42 CST