10 Replies Latest reply: Jan 21, 2013 7:01 AM by 966684 RSS

    DG space

    966684
      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
          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
            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
              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
                see this link:
                www.dba-oracle.com/art_dbazine_weeg_datafile_resizing_tips.htm

                HTH
                Tobi
                • 5. Re: DG space
                  mseberg
                  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
                    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
                      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
                        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
                          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
                            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,