Can I haz Exabytes?

[Raven]

The massive 20+ GB hard drive of our demo server is full making it impossible to run our testing scripts. FML

[Sabre]

You seriously need to get out of there...

My workstation at work:

Code: Select all

Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              19G   11G  7.1G  60% /
udev                  2.0G  156K  2.0G   1% /dev
none                  2.0G  4.0K  2.0G   1% /dev/shm
none                  2.0G   92K  2.0G   1% /var/run
none                  2.0G     0  2.0G   0% /var/lock
none                  2.0G     0  2.0G   0% /lib/init/rw
/dev/sda3             5.8T   96G  5.5T   4% /Data

No data sets loaded right now, so my /Data RAID is very empty

[Raven]

U01 is the problem. The DB is stuck in internal mode now, so we can't even access the DB to delete file attachments and free up space. We are boned as it were.

Code: Select all

bash-3.00$ df -h
Filesystem             size   used  avail capacity  Mounted on
/dev/dsk/c1t0d0s0      9.8G   7.5G   2.2G    78%    /
/devices                 0K     0K     0K     0%    /devices
ctfs                     0K     0K     0K     0%    /system/contract
proc                     0K     0K     0K     0%    /proc
mnttab                   0K     0K     0K     0%    /etc/mnttab
swap                   2.2G   1.3M   2.2G     1%    /etc/svc/volatile
objfs                    0K     0K     0K     0%    /system/object
sharefs                  0K     0K     0K     0%    /etc/dfs/sharetab
/platform/sun4u-us3/lib/libc_psr/libc_psr_hwcap1.so.1
                       9.8G   7.5G   2.2G    78%    /platform/sun4u-us3/lib/libc_psr.so.1
/platform/sun4u-us3/lib/sparcv9/libc_psr/libc_psr_hwcap1.so.1
                       9.8G   7.5G   2.2G    78%    /platform/sun4u-us3/lib/sparcv9/libc_psr.so.1
fd                       0K     0K     0K     0%    /dev/fd
swap                   2.2G    48K   2.2G     1%    /tmp
swap                   2.2G    32K   2.2G     1%    /var/run
/dev/dsk/c1t0d0s5       17G    16G    87M   100%    /u01
/dev/dsk/c1t0d0s4      2.0G   914M   1.0G    47%    /export/home
/vol/dev/dsk/c0t6d0/patches
                       1.3G   1.3G     0K   100%    /cdrom/patches

[Sabre]

Any chance you have a bigger HD around that you can use temporarily? You could transfer all the stuff over on U01 to the borrowed drive, mount it, purge/compact/etc. the database, and then copy it back to the old drive and remount.

[Raven]

My boss poked around and deleted a whole bunch of old log files and freed up enough space to fix it. Thus proving once more that I'm not an Oracle DBA. Why do they keep giving me the jobs of an Oracle DBA???

[schvin]

no christmas this year for solaris

[complacent]

no christmas this year for solaris

but there's going to be one for sparc... weird, right?

[Sabre]

^^^ Indeed :/

[schvin]

no christmas this year for solaris

but there's going to be one for sparc... weird, right?

yeah, didn't see that one coming.