1 2 Previous Next 18 Replies Latest reply: May 14, 2013 5:17 AM by Mahir M. Quluzade Go to original post RSS
      • 15. Re: Oracle generating archive log in Automatic archival   Disabled mod
        Mahir M. Quluzade
        It means your showed files, which is starting ARC.. is not archived logs. :)
        • 16. Re: Oracle generating archive log in Automatic archival   Disabled mod
          yasirdba
          Yes it is stopped, but i do not how??


          The result of "show parameter db_recovery_file_dest"
          SQL> show parameter db_recovery_file_dest

          NAME TYPE VALUE
          ------------------------------------ ----------- -----------------------------
          db_recovery_file_dest string D:\flash_recovery_area
          db_recovery_file_dest_size big integer 3852M
          SQL>
          The result of "show parameter log_arch"


          SQL> show parameter log_arch

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_config string
          log_archive_dest string
          log_archive_dest_1 string
          log_archive_dest_10 string
          log_archive_dest_11 string
          log_archive_dest_12 string
          log_archive_dest_13 string
          log_archive_dest_14 string
          log_archive_dest_15 string
          log_archive_dest_16 string
          log_archive_dest_17 string

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_dest_18 string
          log_archive_dest_19 string
          log_archive_dest_2 string
          log_archive_dest_20 string
          log_archive_dest_21 string
          log_archive_dest_22 string
          log_archive_dest_23 string
          log_archive_dest_24 string
          log_archive_dest_25 string
          log_archive_dest_26 string
          log_archive_dest_27 string

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_dest_28 string
          log_archive_dest_29 string
          log_archive_dest_3 string
          log_archive_dest_30 string
          log_archive_dest_31 string
          log_archive_dest_4 string
          log_archive_dest_5 string
          log_archive_dest_6 string
          log_archive_dest_7 string
          log_archive_dest_8 string
          log_archive_dest_9 string

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_dest_state_1 string enable
          log_archive_dest_state_10 string enable
          log_archive_dest_state_11 string enable
          log_archive_dest_state_12 string enable
          log_archive_dest_state_13 string enable
          log_archive_dest_state_14 string enable
          log_archive_dest_state_15 string enable
          log_archive_dest_state_16 string enable
          log_archive_dest_state_17 string enable
          log_archive_dest_state_18 string enable
          log_archive_dest_state_19 string enable

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_dest_state_2 string enable
          log_archive_dest_state_20 string enable
          log_archive_dest_state_21 string enable
          log_archive_dest_state_22 string enable
          log_archive_dest_state_23 string enable
          log_archive_dest_state_24 string enable
          log_archive_dest_state_25 string enable
          log_archive_dest_state_26 string enable
          log_archive_dest_state_27 string enable
          log_archive_dest_state_28 string enable
          log_archive_dest_state_29 string enable

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_dest_state_3 string enable
          log_archive_dest_state_30 string enable
          log_archive_dest_state_31 string enable
          log_archive_dest_state_4 string enable
          log_archive_dest_state_5 string enable
          log_archive_dest_state_6 string enable
          log_archive_dest_state_7 string enable
          log_archive_dest_state_8 string enable
          log_archive_dest_state_9 string enable
          log_archive_duplex_dest string
          log_archive_format string ARC%S_%R.%T

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_local_first boolean TRUE
          log_archive_max_processes integer 4
          log_archive_min_succeed_dest integer 1
          log_archive_start boolean FALSE
          log_archive_trace integer 0
          SQL>
          • 17. Re: Oracle generating archive log in Automatic archival   Disabled mod
            yasirdba
            can i set email notication, if some one reply my question.

            Thanks Mahir M. Quluzade
            • 18. Re: Oracle generating archive log in Automatic archival   Disabled mod
              Mahir M. Quluzade
              log_archive_format string ARC%S_%R.%T
              No, they are archived log files.
              When you changed to NOARCHIVELOG, archive generation is stoped.

              Regards
              Mahir M. Quluzade
              1 2 Previous Next