You need the REOPEN at the end, or else it won't start achiving. (and it's log_archive_dest, not archive_log_dest...)sql> alter system set archive_log_dest=c:/abcd/efhn/ijk/....;
Code:ALTER SYSTEM SET log_archive_dest='location=/u01/oradata/archive reopen'; ALTER SYSTEM ARCHIVE LOG ALL;




Reply With Quote