SQL> alter system set log_archive_dest1='/home/oracle/oradata/ORCL/ArchiveLog1' scope=spfile;
SQL> alter system set log_archive_dest2='/home/oracle/oradata/ORCL/ArchiveLog2' scope=spfile;
SQL> alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
DB 재구동
SQL> shutdown immediate;
SQL> startup mount;
아카이브 사용 설정
SQL> alter database archivelog;
SQL> alter database open;
|