Moving & Recreate Temp Tablespace

Filed under: Oracle — Wrote on Thursday, December 13th, 2007 @ 12:29 am

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.

Bookmark and Share
  -

No comments yet. Be the first to comment this post.

Leave your comment

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

-->
© it’s simply a matter of a time…