Home » RDBMS Server » Server Administration » Adding a Datafile to an existing Index Tablspace on a Live Busy System (Oracle 10g Rel 2)
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
azeem87
Messages: 95
Registered: September 2005
Location: dallas
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 messageGo to next message
joy_division
Messages: 4644
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
ThomasG
Messages: 3189
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.
Previous Topic: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist
Next Topic: How to know constraints
Goto Forum:
  


Current Time: Sat Dec 10 08:50:36 CST 2016

Total time taken to generate the page: 0.27566 seconds