sqlplus: alert system set log_archive_dest='/opt/oracle/archive' scope=spfile sid='*';
select sid,name,value from v$spparameter where name='log_archive_dest'
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
archive log list;
sqlplus: alert system set log_archive_dest='/opt/oracle/archive' scope=spfile sid='*';
select sid,name,value from v$spparameter where name='log_archive_dest'
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
archive log list;