This discussion is archived
10 Replies Latest reply: Jan 21, 2013 5:01 AM by 966684 RSS

DG space

966684 Newbie
Currently Being Moderated
Hi All,

Oracle 11gr2 on RHEL 5.6. DG environment.

Issue - My DG server is running out of space. Initially it had less storage compared to Primary. Primary server is Ok.

Getting additional storage can be time consuming when it requires a process of management approval. Also I may need to reconfigure my DG after adding new storage

If I shrink my data files in Primary data files it will reclaim space (below HWM), will it reclaim similar from DG and free some space.

Or RESIZE my data files in primary.

What can be the resolution.?
  • 1. Re: DG space
    saurabh Pro
    Currently Being Moderated
    If you resize your primary database datafile then same will be done on the standby database datafile too and if you shrink the data in your primary database it will do same in standby database too.


    The best solution would be to get the storage space, if it takes times then you can use any of the two methods as your requirement.

    1. Shrink data in datafile

    If there are more unused free space below HWM then this is useful as it will move the HWM and there will be free space in datafile. But this will not make space in your mount point.

    2. REsized datafile

    If your datafile is big and there is lot of free space in it then you can do so. This will Free space in your mount point.
  • 2. Re: DG space
    966684 Newbie
    Currently Being Moderated
    2. REsized datafile

    If your datafile is big and there is lot of free space in it then you can do so. This will Free space in your mount point.
    If I go for resize, how do we estimate the resize value.
  • 3. Re: DG space
    saurabh Pro
    Currently Being Moderated
    the following link might be useful to you. BUT FIRST TEST IT ON SOME TEST DATABASE AND THEN TRY ON PRODUCTION DATABASE.

    http://avdeo.com/2008/02/21/reducing-datafile-size-to-recover-free-space-oracle-database-10g/
  • 4. Re: DG space
    teits Pro
    Currently Being Moderated
    see this link:
    www.dba-oracle.com/art_dbazine_weeg_datafile_resizing_tips.htm

    HTH
    Tobi
  • 5. Re: DG space
    mseberg Guru
    Currently Being Moderated
    Hello;

    Here's a source of information I trust :

    Data Guard – Adding and Resizing a datafile on the Primary database

    http://gavinsoorma.com/2009/07/data-guard-adding-and-resizing-a-datafile-on-the-primary-database/

    ( Read - 2. Resize datafile - carefully )

    Best Regards

    mseberg
  • 6. Re: DG space
    966684 Newbie
    Currently Being Moderated
    Hi

    Thanks for your replies..

    Can we deallocate space from another mount point and allocate on the data mount point. Its in OS level though. Is it possible?
  • 7. Re: DG space
    mseberg Guru
    Currently Being Moderated
    Hello again;

    Yes. In Unix / Linux you can.

    In most cases it goes the other way but I have a step by step here using rsync :

    http://www.visi.com/~mseberg/rsync_oracle.html

    Best Regards

    mseberg
  • 8. Re: DG space
    966684 Newbie
    Currently Being Moderated
    mseberg wrote:
    Hello again;

    Yes. In Unix / Linux you can.

    In most cases it goes the other way but I have a step by step here using rsync :

    http://www.visi.com/~mseberg/rsync_oracle.html
    Hi,

    Can't access the link. Please check

    Thanks
  • 9. Re: DG space
    CKPT Guru
    Currently Being Moderated
    963681 wrote:
    mseberg wrote:
    Hello again;

    Yes. In Unix / Linux you can.

    In most cases it goes the other way but I have a step by step here using rsync :

    http://www.visi.com/~mseberg/rsync_oracle.html
    Hi,

    Can't access the link. Please check

    Thanks
    These commands more with OS , If you do not have enough space then move the datafiles to other mount point. Instead of removing and adding space at OS level.
    This is quick workaround.

    1) Stop MRP
    2) Move file and rename it using "alter database rename file" command"
    3) Start MRP

    Will it work for you? if not check for OS level commands.
    HTH.
  • 10. Re: DG space
    966684 Newbie
    Currently Being Moderated
    In most cases it goes the other way but I have a step by step here using rsync :

    http://www.visi.com/~mseberg/rsync_oracle.html
    Hi Mseberg,

    Can you please send me the steps in the link. The link is not opening..

    Thanks,

Legend

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