Adding a Datafile to an existing Index Tablspace on a Live Busy System [message #312010] |
Mon, 07 April 2008 14:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
azeem87
Messages: 116 Registered: September 2005 Location: dallas
|
Senior Member |
|
|
Hi
One of our Production Index tablespace was about to fully utilized (still 1000 mb was there)
But since it was busy day and we expected a volume to come in , we decided to add extra space
by adding a Datafile through OEM,the moment this was being done, APP team started getting pagers , and got this error, and there was dealy for a very short period of time and all went fine after that short period.
ORA-00372: file 36 cannot be modified at this time
ORA-01110: data file 36: '/u05/oradata/Billing/APP_INDX.03.dbf'
Questions is :- Does adding a Datafile on a busy (really very busy system), makes unavialability of tablespace or other datafiles inside that tablespace for a short period of time,
Note :- This tablespace is purely for indexes. Version is Oracle 10g 2 node RAC.
What else could have given that message.
Thanks
|
|
|
Re: Adding a Datafile to an existing Index Tablspace on a Live Busy System [message #312014 is a reply to message #312010] |
Mon, 07 April 2008 15:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
00372, 00000, "file %s cannot be modified at this time"
// *Cause: attempting to modify the contents of a file that cannot be
// modified. The file is most likely part of a read only tablespace
// but may be in the process of going offline, or the database may
// be in the process of closing.
// *Action: check the status of the file and its tablespace
Were you adding a datafile to a tablespace or increasing the size of an already existing file of a tablespace?
I would add the datafile at a command prompt. I have never used OEM and do not trust any "tool" that hides the actual command to be used.
|
|
|
Re: Adding a Datafile to an existing Index Tablspace on a Live Busy System [message #312257 is a reply to message #312014] |
Tue, 08 April 2008 05:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
We had something similar a while back, when one of the "backup" DBAs added a 5 Gig datafile to a database (because all the other data files were also 5 Gig big at that time)
( Oracle 9.2.0.X.X on AIX )
We figured at that time that the problem might have been that the OS side of the file creation was not finished, but the database already tried to use the datafile.
The normal procedure for that database would have been to create a 100MB datafile with auto-extend enabled in 100MB steps, which has never resulted in any problems in this direction.
|
|
|