Re: Control files Restore?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 7 Mar 2003 08:17:08 -0800
Message-ID: <a20d28ee.0303070416.240c83a9@posting.google.com>

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

You should at least have 2, PREFERABLY on DIFFERENT disks.
>
> But when I do a trace I'll only have one control file namely
> c:\oracle\admin\seven\udump\seven_ora_1092.trc

This is not a controlfile.

>
> 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 ........
If you do a CREATE CONTROLFILE the controlfile you just restored will be overwritten. Also: the CREATE CONTROLFILE automatically creates ALL control files listed in the control_files init.ora parameter.

As the controlfiles are by design always in sync, you can restore one and copy them over the others.

>
> Hope Someone can help
> cheers
> J

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Mar 07 2003 - 10:17:08 CST