Home » Infrastructure » Unix » running out of disk space in /oracle/oradata/sid1 dir.
running out of disk space in /oracle/oradata/sid1 dir. [message #97976] Mon, 11 August 2003 15:38 Go to next message
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 Go to previous message
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
Previous Topic: ORA-00600: internal error code, arguments: [kzckini: nzdsi_initialize], [28750]
Next Topic: Installing oracle On AIX 4.3.3
Goto Forum:
  


Current Time: Sun Sep 27 20:35:55 CDT 2020