5 Replies Latest reply: Sep 13, 2013 6:30 AM by EdStevens RSS

    The fast recovery area can not be used for archive log?

    Kramer

      I`m using the the version 11.0.2.3 for testing.  I read a line as below from the OCP book.

      If none of the LOG_ARCHIVE_DEST_n parameters have been set, then transitioning

      the database to archivelog mode will internally set LOG_ARCHIVE_DEST_10 to the

      flash recovery area, if it has been configured.

      In my database the fast recovery already been set as below.

      SQL> show parameter db_recovery

       

       

      NAME                                 TYPE        VALUE

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

      db_recovery_file_dest                string      +FASTRECOVERY

      db_recovery_file_dest_size           big integer 4248M

      So I thought if I turn the database into archive log mode, then the log_archive_dest_10 will be set as the same value as db_recovery_dest.

      SQL> alter database archivelog;

       

       

      Database altered.

       

       

      SQL> alter database open;

       

       

      Database altered.

       

       

      SQL> show parameter log_archive_dest

       

       

      NAME                                 TYPE        VALUE

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

      log_archive_dest                     string

      log_archive_dest_1                   string

      log_archive_dest_10                  string

      See, after the database become archive, the log_archive_dest_10 still be empty.

       

       

      So is there any thing wrong with my understanding?

        • 1. Re: The fast recovery area can not be used for archive log?
          saurabh

          check below cmd to see where archive are generated.

           

          SQL> archive log list

           

          And also check the following

           

          SQL> select flashback_on from v$database;

          • 2. Re: The fast recovery area can not be used for archive log?
            Kramer

            saurabh wrote:

             

            check below cmd to see where archive are generated.

             

            SQL> archive log list

             

            And also check the following

             

            SQL> select flashback_on from v$database;

            Hi

             

            Here is the out put

             

             

             

            SQL>  select flashback_on from v$database;

             

             

            FLASHBACK_ON

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

            NO

             

            SQL>  archive log list

            Database log mode              Archive Mode

            Automatic archival             Enabled

            Archive destination            USE_DB_RECOVERY_FILE_DEST

            Oldest online log sequence     11

            Next log sequence to archive   12

            Current log sequence           12

             

            The flashback is not enabled. But archive log list shows archive destination is specified to use_db_recovery_file_dest.  And I checked the log_archive_dest_10 still empty

            • 3. Re: The fast recovery area can not be used for archive log?
              JohnWatson

              That is  quote a from the Oracle Press All-In-One Exam guide that I had a part in writing. Your issue is that you are using 11.2.x, but the book was written with 11.1.x. Look up the relevant parameters in the docs for the two releases, and you will see that the situation has changed.

              Oracle Uni validates the exams against both releases, so there should not be any questions where the difference would matter, but in any case, with your attention to detail I am sure tat you will have no problem with the exams.

              --

              John Watson

              Oracle Certified Master DBA

              • 4. Re: The fast recovery area can not be used for archive log?
                Kramer

                Oh! Yes, it` you. It`s interesting to meet you here.

                Thanks very much. It`s an excellent book. Easy to understand.

                • 5. Re: The fast recovery area can not be used for archive log?
                  EdStevens

                  Kramer wrote:

                   

                  saurabh wrote:

                   

                  check below cmd to see where archive are generated.

                   

                  SQL> archive log list

                   

                  And also check the following

                   

                  SQL> select flashback_on from v$database;

                  Hi

                   

                  Here is the out put

                   

                   

                   

                  SQL>  select flashback_on from v$database;

                   

                   

                  FLASHBACK_ON

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

                  NO

                   

                  SQL>  archive log list

                  Database log mode              Archive Mode

                  Automatic archival             Enabled

                  Archive destination            USE_DB_RECOVERY_FILE_DEST

                  Oldest online log sequence     11

                  Next log sequence to archive   12

                  Current log sequence           12

                   

                  The flashback is not enabled. But archive log list shows archive destination is specified to use_db_recovery_file_dest.  And I checked the log_archive_dest_10 still empty

                   

                  Flashback off or on has nothing to do with it.