5 Replies Latest reply: May 11, 2011 1:10 PM by Uwehesse-Oracle RSS

    Flashback database in Dataguard environment

    412903
      On primary if i flashback database to a restore point, do I need to rebuild standby environment. Is there any other option. Can I flashback standby to restore point also. Can you please detail me the steps.

      These I think are the steps.

      1) Create Flashback database Guarantee restore point on Standby.
      2) Create Flashback database Guarantee restore point on primary.

      Backout

      1) Flashback Database to restore point on primary.
      2) Flashback Database to restore point on standby

      Is it possible if we follow the above steps we dont need to rebuild the standby after flashing back the primary database.
        • 1. Re: Flashback database in Dataguard environment
          mseberg
          If I flashback database to a restore point, do I need to rebuild standby environment?

          No, since the standby database should be synchronized to the primary (assumes no delay) it should come along for the ride.


          Can I flashback standby to restore point also?

          Yes, but the retention period must be greater or equal than the Primary database retention period.

          There are very few cases where you would want to do this on the standby.

          For example you might use it if a RESETLOGS was used on the Primary.


          Setup


          Guaranteed restore points provide a complementary capability to Flashback Database.

          You might set them up during an upgrade.

          Ex.

          CREATE RESTORE POINT before_upgrade GUARANTEE FLASHBACK DATABASE;


          FLASHBACK DATABASE TO RESTORE POINT before_upgrade;




          Section 5 of B14192-03 has some good information on this.

          This is worth a look too:


          www.oracle.com/us/solutions/sap/wp-ora4sap-flashback11g-1-303814.pdf



          Queries

          SELECT 
            NAME, 
            SCN, 
            TIME, 
            DATABASE_INCARNATION#,
            GUARANTEE_FLASHBACK_DATABASE,
            STORAGE_SIZE
          FROM 
            V$RESTORE_POINT;
          SELECT 
            NAME, 
            SCN, 
            STORAGE_SIZE
          FROM 
            V$RESTORE_POINT
          WHERE 
            GUARANTEE_FLASHBACK_DATABASE = 'YES';
          Best Regards

          mseberg
          • 2. Re: Flashback database in Dataguard environment
            Dr. Paranoid-Oracle
            What exactly are you trying to protect against? Guaranteed Restore Points will keep the flashback logs growing and around forever until you drop them.

            The general process is documented in the manual at http://download.oracle.com/docs/cd/E11882_01/server.112/e17022/scenarios.htm#i1049616

            Larry
            • 3. Re: Flashback database in Dataguard environment
              Uwehesse-Oracle
              You don't need to recreate your Standby Database if you flashback your Primary (and have flashback logs turned on at Standby also).

              (Guaranteed) restore points are not required for this procedure - they just make it easier resp. enforce the presence of the flashback logs you need to flashback to that time.

              See an example without restore points here:
              http://uhesse.wordpress.com/2010/08/06/using-flashback-in-a-data-guard-environment/

              Kind regards
              Uwe Hesse

              http://uhesse.wordpress.com
              • 4. Re: Flashback database in Dataguard environment
                Talip Hakan Ozturk
                You don't need to recreate standby database if flashback is open. But there are many steps to back standby database.

                Did you hear about Snapshot standby database? It is very good feature with 11g. And very simple. Yo can convert your physical standby to snapshot and back to physical easily.

                DGMGRL> convert database <name> to snapshot standby;
                DGMGRL> convert database <name> to physical standby;


                http://download.oracle.com/docs/cd/E11882_01/server.112/e17022/manage_ps.htm#insertedID7
                • 5. Re: Flashback database in Dataguard environment
                  Uwehesse-Oracle
                  Yes and do you know that we have a table tennis in our Ed Center in Utrecht?
                  Oops, out of topic, you say?

                  I have indeed heared about Snapshot Standby already - I just fail to see what that has to do with the OPs question :-)

                  Snapshot Standby was invented to give you a Test Database and after your test is done get you back your Standby Database.
                  There is no Flashback Database of the Primary involved here.

                  Kind regards
                  Uwe Hesse

                  http://uhesse.wordpress.com