Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HOW TO DISABLE LOG_ARCHIVE_DEST IN ARCHIVELOG;;;PLZ HELP ME

orawissJan 16 2008 — edited Jan 16 2008

Hi 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

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2008

Added on Jan 16 2008

#general-database-discussions

5 comments

4,522 views