10 Replies Latest reply: Oct 4, 2012 9:18 AM by Milton RSS

    How to open a active dataguard?

    Milton
      Hello,

      I have an Active DataGuard, Oracle version 11.2.0.3 and Solaris 10.
      I have to do a test on the Active DataGuard environment, I want to open this database to run multiple scripts DML. At the end I must return to the DataGuard active as it was before the opening to continue with normal operation.

      I appreciate the document indicate commands or procedure I should run to do this activity.

      regards,
      Milton
        • 1. Re: How to open a active dataguard?
          mseberg
          Hello;

          SQL> SELECT database_role, open_mode FROM v$database;


          SQL> alter database recover managed standby database cancel;


          SQL> alter database open;

          SQL> alter database recover managed standby database disconnect from session;

          SQL> select process,status,sequence# from v$managed_standby;

          If you have Data Guard Broker setup then
          DGMGRL > edit database physt set state=apply-off;
          
          SYS@physt > alter database open read only;
          
          DGMGRL > edit database physt set state=apply-on;
          Best Regards

          mseberg

          Edited by: mseberg on Oct 3, 2012 3:12 PM
          • 2. Re: How to open a active dataguard?
            Milton
            Hello,

            Is this all?

            I am going to do a test, I need run some scripts to delete and insert rows in some tables and, after that I have return to the enviroment original.

            Regards,
            Milton
            • 3. Re: How to open a active dataguard?
              mseberg
              Yes.

              Milton, you understand Active Data Guard make the Standby Database a "Reader" database. It allows read-only access on the standby at the same time as archiving transactions from the primary.

              So your inserts need to be on the primary.

              Best Regards

              mseberg
              • 4. Re: How to open a active dataguard?
                Milton
                Yes,

                When I created this adg enviroment, I read a note indicating that he could open the database for testing and then return to the point before the opening to continue the active DataGuard. I want to do this test and do not remember the number of document information and commands.

                Regards,
                Milton
                • 5. Re: How to open a active dataguard?
                  mseberg
                  Data Guard Concepts and Administration 11g Release 2 (11.2) E10700-02

                  See - 9.2 Opening a Physical Standby Database

                  http://docs.oracle.com/cd/E11882_01/server.112/e25608.pdf

                  No help.

                  Best Regards

                  mseberg
                  • 6. Re: How to open a active dataguard?
                    saurabh
                    As i understand you want to open the standby database in read/write mode test it and again revert back to standby by database. If it is so then following link might help you.


                    http://oracleinstance.blogspot.in/2011/09/physical-standby-database-for-readwrite.html
                    • 7. Re: How to open a active dataguard?
                      UweHesse
                      Active Data Guard resp. Real-Time Query will never allow for DML on the Standby DB. Period.

                      You can open a Physical Standby Read-Write and do DML then, but it will no longer show the same state as the Primary. In other words: Real-Time Query is off then.

                      One convenient way to have a Physical Standby opened Read-Write, do anything and then reconvert it into Physical Standby is a Snapshot Standby Database.
                      There is no (direct) relation to Active Data Guard here, though.

                      Kind regards
                      Uwe Hesse

                      "Don't believe it, test it!"
                      http://uhesse.com
                      • 8. Re: How to open a active dataguard?
                        Milton
                        Thank you !!
                        • 9. Re: How to open a active dataguard?
                          Seberg
                          If the thread was answered , please close then marking as answered.

                          It's a forum etiquette.

                          https://forums.oracle.com/forums/ann.jspa?annID=910
                          • 10. Re: How to open a active dataguard?
                            Milton
                            Thank you, I am going to follow the step for this doc. 11g Using Snapshot Standby Database. [ID 443720.1]

                            Regards,
                            Milton