sql> shutdown immediate sql> startup mount sql> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archive/ mandatory'; sql> alter system set log_archive_dest_2='LOCATION=/u02/app/oracle/archive/ optional'; sql> alter database archivelog; sql> alter database open; sql> select dbid,name,log_mode from v$database; DBID NAME LOG_MODE ---------- --------------------------- ------------------------------------ 1081616855 KING ARCHIVELOG sql> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/app/oracle/archive/ Oldest online log sequence 39 Next log sequence to archive 41 Current log sequence 41 sql> show parameter log_archive_dest_1; NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ log_archive_dest_1 string LOCATION=/u01/app/oracle/archi ve/ mandatory sql> show parameter log_archive_dest_2; NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ log_archive_dest_2 string LOCATION=/u02/app/oracle/archi ve/ optional
sql> show parameter log_archive_max NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ log_archive_max_processes integer 4 sql> show parameter log_archive_min_succeed_dest NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ log_archive_min_succeed_dest integer 1
sql> alter system archive log current; System altered.
