[ORACLE] 아카이브 모드 켜기

1. 모드 확인

SQL> select name, log_mode from v$database;

NAME               LOG_MODE
------------------ ------------------------
DEVDB              NOARCHIVELOG

SQL> archive log list

Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence     71
Current log sequence           73

SQL> show parameter log_archive

 

2. 아카이브 로그가 생성될 디렉토리 생성

SQL> ! ls -l $ORACLE_BASE/oradata
SQL> ! mkdir /u01/app/oracle/oradata/devdb_arch1
SQL> ! mkdir /u01/app/oracle/oradata/devdb_arch2

3. 아카이브 로그 경로 설정

SQL> alter system set log_archive_dest_1 = 'location=/u01/app/oracle/oradata/devdb_arch1/';
SQL> alter system set log_archive_dest_2 = 'location=/u01/app/oracle/oradata/devdb_arch2/';

※ 10g 이전버전
SQL> alter system set log_archive_start  = true;
SQL> alter system set log_archive_format = arch_%s.arc

4. 데이터베이스 모드 수정

SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;

5. 생성 확인

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/oradata/devdb_arch2/
Oldest online log sequence     71
Next log sequence to archive   73
Current log sequence           73

SQL> !ls /u01/app/oracle/oradata/devdb_arch1
SQL> alter system switch logfile;
SQL> !ls /u01/app/oracle/oradata/devdb_arch*
SQL> alter system switch logfile;
SQL> !ls /u01/app/oracle/oradata/devdb_arch*