1 2 Previous Next 18 Replies Latest reply: May 14, 2013 5:17 AM by Mahir M. Quluzade RSS

    Oracle generating archive log in Automatic archival   Disabled mod

    yasirdba
      Oracle 11.2 32 bit
      Window server 2008 64bit


      SQL> archive log list;
      Database log mode No Archive Mode
      Automatic archival Disabled
      Archive destination USE_DB_RECOVERY_FILE_DEST
      Oldest online log sequence 947
      Current log sequence 949
      SQL> archive log list;
      Database log mode No Archive Mode
      Automatic archival Disabled
      Archive destination USE_DB_RECOVERY_FILE_DEST
      Oldest online log sequence 947
      Current log sequence 949
      SQL>


      above query shows that archive mod is disable but i have seen that oracle still generating archive log at specified destination .

      when i run backup database command through rman , it gives error that enable the archive log.

      i remember that i have enable the archive log and also change their storage destination. after that i didn't remember that i have disable archive log or not.

      but in above result it shows it is disabled.

      I want to know why oracle generating archive log if its mode is disable.
        1 2 Previous Next