it’s simply a matter of a time…

about // addons // orasnap// gallery

Moving & Recreate Temp Tablespace

Yesterday i get error on my database

Errors in file /rdbms/oracle/admin/udump/prod_ora_685.trc: ORA-01114: IO error writing block to file 10004 (block # 503489) ORA-27072: skgfdisp: I/O error HP-UX Error: 28: No space left on device Additional information: 503489

Karena semua query di tampung di temporary tablespace,
so i go to that mount point, and you now what, the mount point was full

bdf
Filesystem          kbytes    used   avail %used Mounted on
/dev/vg12/lvol5    112656384 112656384       0  100% /rdbms/oracle/temp

So i extend the new datafile on temp tablespace, the extend proses was to quickly than before, :(
Check and richeck, so i used command bellow

lvdisplay /dev/vg12/lvol5
fstyp -v /dev/vg12/lvol5

Think fast, I used another mount point to moving and recreate the temp tablespace..detail click here.

And blast..
the error was gone, the mount point was suspect corrupt, Use umount, lvremove, lvcreate and than newfs, mount and yes new mount point was added again.


No Comments Yet


There are no comments yet. You could be the first!

Leave a Comment

:) :( :d :"> :(( :n/ :x 8-| /:) :o :-? :-" :-w ;) [-( :)>- more »

…From Bali ..Take A Rest