Lost of Control File

[newcomer]

I am sorry!!

What I would like to know that, suppose I don't know that some thing wrong has happened in my first disk.

And I try to move a datafile of a particular tablespace to a new location ...... U said I Oracle will fire an error.... My doubt is does oracle allow me to move that file at that time or it stop me there itself?

Regards

[jovery]

If you are trying to move a datafile to a new location when the database is up Oracle would retain the old location until you had physically move the file via a host copy command and in your senario this is where you would get the error but it would not be an Oracle error but an OS one.

eg.

To move a datafile while the database is open:

1. Make the tablespace READ_ONLY
2. Take the tablespace offline
3. Move the datafile via the OS --> this is where your error would occur.
4. Update the file location in Oracle
5. Bring the tablespace online
6. Make the tablespace READ_WRITE

Therefore if the error occured at point 3 and the file could not be moved it would remain in it's original location and you would simple skip point 4.

HTH

[newcomer]

So, the error will occur at point # 3, bcoz of missing the controlfile right? Not for any other constraints.

Ok, I would like to clear one more doubt ....

1. Suppose I lost all my original control files, and Backup control files.

2. I am going to create a new control file with the details of existing datafile names and size.

3. I know the name but how to get the size of those files? Will u suggest me to take it from O/S level? but sometimes oracle give error even I am taking size from O/S.

What do u suggest?

Regards

[TomazZ]

Originally posted by jovery
To move a datafile while the database is open:

1. Make the tablespace READ_ONLY
2. Take the tablespace offline
3. Move the datafile via the OS --> this is where your error would occur.
4. Update the file location in Oracle
5. Bring the tablespace online
6. Make the tablespace READ_WRITE

Do we really need to put tablespace in READ ONLY=
And why?

It works without...