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