Oracle DBA FAQ‎ > ‎

Archive location filled - How to set the archive log location to new location?

posted Sep 21, 2010, 9:15 AM by Sachchida Ojha   [ updated Mar 22, 2011, 6:51 AM ]
conn "sys/pass as sysdba"
show parameter log_archive_dest
alter system set log_archive_dest_1="new loc" or
alter system set db_recovery_file_dest="new loc";
alter system set log_archive_dest_1='location=/backup/DUPRPTDB/archive';
alter system switch logfile
Comments