2 Replies Latest reply: Sep 28, 2013 8:18 AM by Paul M. Branched from an earlier discussion. RSS

    Alter Database Flashback On in 11g R2

    1043868

      Hi Guys, I have one question.

      For 11gR2, can I put FLASHBACK ON while the database is open with compatibility being 11.1?

      Any idea ??

        • 1. Re: Alter Database Flashback On in 11g R2
          Dude!

          I have not seen such info, but it should be easy to test.

          • 2. Re: Alter Database Flashback On in 11g R2
            Paul M.
            For 11gR2, can I put FLASHBACK ON while the database is open with compatibility being 11.1?

            As Dude said, it's not so difficult to test :

            SQL> select * from v$version where rownum=1;

             

            BANNER

            --------------------------------------------------------------------------------

            Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

             

            SQL> select status from v$instance;

             

            STATUS

            ------------

            OPEN

             

            SQL> sho parameter compatible

             

            NAME                                 TYPE        VALUE

            ------------------------------------ ----------- ------------------------------

            compatible                           string      11.1.0.0.0

            SQL> select flashback_on from v$database;

             

            FLASHBACK_ON

            ------------------

            NO

             

            SQL> alter database flashback on;

             

            Database altered.

             

            SQL>

            And there is The documentation


            flashback_mode_clause


            Use this clause to put the database in or take the database out of FLASHBACK mode. You can specify this clause only if the database is in ARCHIVELOG mode and you have already prepared a fast recovery area for the database.You can specify this clause when the database is mounted, either open or closed.