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 tablespace on that mount point (force..), the extend proses was to quickly than before,
so i use lvdisplay /dev/vg12/lvol5 and
fstyp -v /dev/vg12/lvol5,
to check the size and compare with bdf/sam command.
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,
umount, lvremove, lvcreate and than newfs, mount and yes new mount point was added again.
No comments yet. Be the first to comment this post.