Re: Control files Restore?

"James" <james_at_nothing.com> wrote in message news:1047022051.246479_at_ftp.adept.co.za...
> Hi there
> Again I'm asking questions!

No problem
> The question comes when restoring a database from the datafiles and a hot
> backup to a new loctation and database name. The control files are
confusing
> me.

If I understand your problem you are trying to create a copy of your database from a backup on a new system with a new database name.

>
> Is it true that I can have 3 control files namely
> c:\oracle\oradata\seven\CONTROL01.ctl
> c:\oracle\oradata\seven\CONTROL02.ctl
> c:\oracle\oradata\seven\CONTROL03.ctl

Not a good idea to create them all on the same disc. If you have more discs create each of these on seperate discs or RAID sets. The idea is that the control file is the basic resource for controlling and starting the database you need to ensure that is a disc is lost you have another one to hand.

>
> But when I do a trace I'll only have one control file namely
> c:\oracle\admin\seven\udump\seven_ora_1092.trc
No - this is not the controlfile this is a dump / script which can be used to recreate a controlfile. N.b. not the same as the one you had before as Logfile information is not the same. You can however use this to create controlfiles in the case you mention from this file. You need to edit the file to make it a true script. Change it to reference the new location of the database datafiles. Also you can change the name of the database during this stage as well. Oracle Metalink has articles on how to do this.

>
> Now when I'm restoring the database(with a new name) Where and which
> controlfile/s do I restore before I do the
> CREATE CONTROLFILE ........

The trace version which you will need to edit as mentioned above. This will create the actual controlfiles you want and if all goes well you will get a database with new name, that opens!

>
> Hope Someone can help
> cheers
> J
>

Regards Kevin Received on Fri Mar 07 2003 - 04:13:40 CST