This discussion is archived
2 Replies Latest reply: Oct 5, 2010 12:53 PM by j.m.krueger RSS

Oracle Slice Resize

802964 Newbie
Currently Being Moderated
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....


regards,
  • 1. Re: Oracle Slice Resize
    user4994457 Newbie
    Currently Being Moderated
    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).

    --
    Darren
  • 2. Re: Oracle Slice Resize
    j.m.krueger Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points