| running out of disk space in /oracle/oradata/sid1 dir. [message #97976] |
Mon, 11 August 2003 15:38  |
trau con
Messages: 1
Registered: August 2003
|
Junior Member |
|
|
Hi,
I'm running out of space in the /oracle/oradata/sid1 dir. Can you show me how to recover it back? Following are the actual commands used on my server:
$pwd
/oracle1/oradata/sid1
$ls -ltr
total 1045906
-rw-r----- 1 oracle dba 512512 Aug 11 19:46 redosid101.log
-rw-r--r-- 1 oracle dba 1050624 Aug 11 19:48 users01.dbf
-rw-r--r-- 1 oracle dba 26216448 Aug 11 19:48 tools01.dbf
-rw-r--r-- 1 oracle dba 109840384 Aug 11 19:48 temp01.dbf
-rw-r--r-- 1 oracle dba 262146048 Aug 11 19:48 system01.dbf
-rw-r--r-- 1 oracle dba 134219776 Aug 11 19:48 rbs01.dbf
-rw-r----- 1 oracle dba 1484800 Aug 11 20:54 control01.ctl
$df -k /oracle/oradata/sid1
Filesystem kbytes used avail capacity Mounted on
/dev/vx/dsk/nfsss1_dg/vol42 524288 524183 104 100% /oracle1
As you can see, the system is getting full and I really NEED some help. Your help is much appreciated.
Sincerely,
Trau Con
|
|
|
|
| Re: running out of disk space in /oracle/oradata/sid1 dir. [message #97977 is a reply to message #97976] |
Mon, 11 August 2003 23:33  |
Prasad
Messages: 104
Registered: October 2000
|
Senior Member |
|
|
Hi Trau Con
U relocate some of u'r datafiles some other disks.
Locate the disks where u hv sufficent disk space.
I think users or temp temp tablespace bring it offline
sql > alter tablespace users offline
sql> alter tablespace users rename datafile '/oracle/oradata/sid1/users01.dbf' to
'/oracle/oradata/sid_extra/users01.dbf';
sql> alter tablespace users online;
U'r Job is done. But I would sugest is use
ln -s command to link datafiles from various locations to this /oracle/oradata/sid1 disk. Then U can control u'r i/o activities also better.
Regards
Prasad
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
