6 Replies Latest reply: Nov 22, 2013 4:06 AM by Mahir M. Quluzade RSS

    DG physical standby 1

      Hi

       

      11.2.0.1

       

      We have a DEV database which is also as critical as PROD db since there are lots of critical projects running on it.

      This DEV database was configured with dataguard physical standby at the DR server.

       

      Well this is what I read in the documents only, as I am newly taking over as dba. The setup was done outsourced

      by 3rd party, and I can not talk to the implentors as they have been long gone.

       

      When I check the DR server only the PROD is running and the DEV was shutdown for the last 12 months.

      My question is if the physical standby is shutdown for almost a year, can it still be activated? or will it still be valid?

      Will it affect performance of the Primary database? since it might still checking heartbeat to it? or holding up some processes like archivers?

      How do you disable physical standby from the primary db?

       

      Thanks

      petra k.

        • 1. Re: DG physical standby 1
          mseberg

          Hello;

           

          "if the physical standby is shutdown for almost a year, can it still be activated? or will it still be valid?"

           

          No and no. Even a tiny production database would have generated and remove too much archive in a years time for the old standby to have ANY value. Rebuild it.

           

          How do you disable physical standby from the primary db?

           

          You could just do this: ( On the primary side )

           

          alter system set log_archive_dest_state_2=defer;

           

          And you could clean up all the parameters for DG too.

           

          How to remove a Data Guard Configuration from Primary Database (Doc ID 733794.1)

           

          Best Regards

           

          mseberg

          • 2. Re: DG physical standby 1

            Excellent answer!

             

            Thanks mseberg

            • 3. Re: DG physical standby 1

              Hi,

               

              If I backup my db using RMAN.

               

              BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

               

              can I be able to restore it using the generic RESTORE DATABASE command? Or do I need to UNCOMPRESS it , or specify RESTORE COMPRESSED BACKUP?

              • 4. Re: DG physical standby 1
                mseberg

                Hello again;

                 

                RMAN will handle so just RESTORE DATABASE, no special compress command needed.

                 

                Hopefully you really need to to perform a restore or you are doing a test.

                 

                Best Regards

                 

                mseberg

                • 5. Re: DG physical standby 1

                  Thanks,

                   

                  One last, Do I need to RMAN backup the  Standby db? Even if I have daily RMAN backup of the Primary DB, which is sent also to the standby server?

                  • 6. Re: DG physical standby 1
                    Mahir M. Quluzade

                    Hi,

                     

                    You can use RMAN backups, which is backed up from standby database.

                    If you have problem with size, then you can  tale backups from standby database (as my case).

                     

                    In your case, I  think, every thing normal.

                     

                    Regards

                    Mahir M. Quluzade