This discussion is archived
1 2 Previous Next 18 Replies Latest reply: May 14, 2013 3:17 AM by MahirM.Quluzade RSS

Oracle generating archive log in Automatic archival   Disabled mod

yasirdba Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points