2 Replies Latest reply on Oct 5, 2010 7:53 PM by j.m.krueger

    Oracle Slice Resize

      Hi, Im using a Sun Solaris 9 on a V890 Server and My oracle database Orahome is On

      /u01 with approx 90% usage....

      but I also have a slice

      /Backup with approx 10%....

      is it possible to Enlarge my /u01? taking space from my /backup? if so How could I do it...??

      my Oracle DB cannot be down... and I cannot add physical disks. I have to make best with this...

      PLEASE HELP....

        • 1. Re: Oracle Slice Resize
          It depends on the specifics of the disk (filesystem, partitions, etc.)

          Is this ZFS? If not, are you using SVM?

          Probably the best thing to do is show the output of 'df -k' and 'prtvtoc /dev/rdsk/cXtXdXs2' (where the details are filled in from the device where /u01 is mounted).

          • 2. Re: Oracle Slice Resize
            If you are using SVM or something like Veritas VM it is possible to resize your /u01 Filesystem.
            The actual doing depends on your environment: SVM or VxVM? Do you need your backup slice, or can it be completely uses?

            If you use SVM and don't need the slice where your backup resides thinks are quite simple:

            use metaclear to clear your backup metadevice and use metattach to attach the now free slice to the metadevice you use for your /u01 device.
            Then use growfs to grow the actual filesystem.
            Be aware that any work on a running filesystem is a possible risk. So be sure to have a consistent backup of you database if anything goes terribly wrong.

            If you need an extra metadevice for /backup, the way would be to destroy the metadevice and using format to resize the slice your backup is on. The free space can be used to create a new slice you can add to your /u01 metadevice.
            This means that you loose all contents of your backup slice as you need to create a new filesystem.