HOW TO DISABLE LOG_ARCHIVE_DEST IN ARCHIVELOG;;;PLZ HELP ME
orawissJan 16 2008 — edited Jan 16 2008Hi all,
I have passed my database production in Archivelog mode, for this I have created 2 directory destinations for my Archive logs.
ALTER SYSTEM SET log_archive_dest_1='location=/u01/app/oracle/oradata/ADVDB/archive1/' SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_2='location=/u01/app/oracle/oradata/ADVDB/archive2/' SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_format='arch_%d_%t_%r_%s.log' SCOPE=SPFILE;
Now the problem that I have archive log tacken 8 GO each 10 hours and this takes much disk space so I decide to disable one directory destination such as log_archive_dest_2.
Someone could help how to disable it please (the best procedure)?
thanks a lot,
W