Включение режима архивирования

alter system set log_archive_dest_1='LOCATION=/u01/oradata/arch_logs_01/loans/ MANDATORY' scope=spfile;
alter system set log_archive_dest_2='LOCATION=/u01/oradata/arch_logs_02/loans/ OPTIONAL' scope=spfile;

alter system set log_archive_format='loans_%t_%s_%r.arc' scope=spfile;
alter system set archive_lag_target=900 scope=spfile;

-- Включение режима архивирования:
shutdown immediate
startup mount
alter database archivelog;
alter database open;

alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;