Home » Server Options » RAC & Failsafe » adding/extending datafile for tablespace (Oracle 10g Enterprise Edition Release 10.2.0.3.0, Solaris 10)
adding/extending datafile for tablespace [message #475712] Thu, 16 September 2010 22:39 Go to next message
ko_aung
Messages: 8
Registered: July 2010
Junior Member
Hi,

Recently, I'm encountering the ORA-01654 error.
I did some research and found out that I need to extend or add new datafile for that tablespace.

I'm working in RAC environment with ASM enabled.
I'm not very familiar with DB administration.

My question is
-Do I need to restart the DB after making the changes?
-Do I need to execute the commands on both nodes?

Cheers!

Regards,
ko_aung
Re: adding/extending datafile for tablespace [message #475713 is a reply to message #475712] Thu, 16 September 2010 22:50 Go to previous messageGo to next message
BlackSwan
Messages: 22902
Registered: January 2009
Senior Member
>-Do I need to restart the DB after making the changes?
NO

>-Do I need to execute the commands on both nodes?
NO
Re: adding/extending datafile for tablespace [message #475716 is a reply to message #475713] Thu, 16 September 2010 23:44 Go to previous messageGo to next message
ko_aung
Messages: 8
Registered: July 2010
Junior Member
Thank You, BlackSwan!
Re: adding/extending datafile for tablespace [message #476213 is a reply to message #475716] Wed, 22 September 2010 02:08 Go to previous messageGo to next message
ko_aung
Messages: 8
Registered: July 2010
Junior Member
Hi BlackSwan,

I'd like to use the following cmd:
alter database datafile <datafile_name> resize <new_size>

How can I determine whether the new size is larger than the current?
Is there a way to find out the size set for the specific datafile initially?

Thanks.

Regards,
ko_aung
Re: adding/extending datafile for tablespace [message #476214 is a reply to message #476213] Wed, 22 September 2010 02:28 Go to previous message
Michel Cadot
Messages: 59421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Initially, you have to look at your alert.log file.
Current, query dba_data_files.

Regards
Michel
Previous Topic: RMAN command to reduce the space usage
Next Topic: Action for BLOCK=2 in V$LOCK
Goto Forum:
  


Current Time: Wed Oct 22 16:45:43 CDT 2014

Total time taken to generate the page: 0.12013 seconds