Lost of Control File

[newcomer]

Hi,

1. My database is up and running since morning 9 O'clock.
2. I have three disks and in the first disk I have only master
control file (i.e the first control file in the Init controlfile
list).

Ques 1. If at any cost, my first disk will crash at any time(I don't
know when it has opened) does my Database will throw any
ERROR when the database is up and runing?

Ques 2. Secondly, if I will copy the control file from the other disk
to it's original first disk, will it give any problem to open
my database?

Regards

[jovery]

1)Yes, if you lose a controlfile while the system is up you will receive an error.

2)Yes, if you copy a valid controlfile from another location to the primary you can restart the instance.

Regards

[davey23uk]

There is no such thing as a 'master' control file. You have at least 2 copies of the control file which are exact opies of each other

If you lost just the control file, shut the db down, copy the good control to another place so you have two copes again, add this to your init.ora file and startup.

[newcomer]

1. Does database give error as soon as the control file get lost or
When I will try to shutdown my database later?

2. If the database will give error immediately --- the what error
shall I get?

3. And if the database will give error while shuting down my
database .. what error shall I get?

Thanks and Regards

[davey23uk]

I tried this for you.

You wont get the error immediatelty, you will get it when the DB tries to write to the control file, which wont be too long.

If the control isnt there you will get this if you shutdown

SQL> shutdown immediate
ORA-00210: cannot open the specified controlfile
ORA-00202: controlfile: '/u02/oradata/RE8/control1.ctl'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL>



What I had to do was shutdown abort, make the changes on the OS level and restart

[newcomer]

So, even if I will try to move my one datafile to a new location, then also I will get the error right?

Thanks

[davey23uk]

Ok, if we are just talking about control files here do this.

Get the database shutdown.

Take a copy of the GOOD control file and copy it to the location of the other control file. If that disk has gone then copy it to a different place and edit the init.ora file and put the location of the new control file in there at the same time removing the location of the old one

[jovery]

Originally posted by newcomer
So, even if I will try to move my one datafile to a new location, then also I will get the error right?

Thanks

Yes, if the control file cannot be located in the place specified in the init.ora the error will occur.

[newcomer]

Hi Jovery,

Thanks.

1 But in such case, does Oracle allow me to move the datafile to a
new location in database level?

2. Or it will fire the error while trying to update that information in control file?

Regards

[jovery]

Sorry you've confused me a bit here,

If you now asking if you can move a datafile while the database is up? If so the anser is yes.

If your asking can a control file be moved when the database is up the answer is no.

Regards