# oracle 10g 아카이브 모드 설정

1. 아카이브 모드 상태 확인 ```SQL
    SQL> archive log list
    \\Database log mode              No Archive Mode
    Automatic archival             Disabled
    Archive destination            USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence     1
    Current log sequence           2
    \\\\SQL> show parameter spfile
    \\NAME                                 TYPE        VALUE
    ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- ~-~-~-~-~-~-~-~-~-~-- ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
    spfile                               string      /u01/app/oracle/product/10.2.0
                                                     /db_1/dbs/spfileTSH1.ora
    ```
2. 아카이브 모드 설정 ```SQL
    SQL> ALTER SYSTEM SET log_archive_dest_1='location=/u01/app/oracle/oradata/data reopen=60' scope=spfile;
    System altered.
    \\\\SQL> ALTER SYSTEM SET log_archive_format='%t_%s_%r.arc' scope=spfile;
    System altered.
    ```
3. Oracle 종료 ```SQL
    SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    ```
4. Oracle 시작 ```SQL
    SQL> startup mount
    .ORACLE instance started.
    \\Total System Global Area  608174080 bytes
    Fixed Size                  1220844 bytes
    Variable Size             171970324 bytes
    Database Buffers          432013312 bytes
    Redo Buffers                2969600 bytes
    Database mounted.
    ```
5. log모드 변경 ```SQL
    SQL> alter database archivelog;
    Database altered.
    ```
6. 아카이브모드 설정내용 확인 ```SQL
    SQL> archive log list
    Database log mode              Archive Mode
    Automatic archival             Enabled
    Archive destination            /u01/app/oracle/oradata/data
    Oldest online log sequence     1
    Next log sequence to archive   2
    Current log sequence           2
    ```
7. DB Open ```SQL
    SQL> alter database open;
    Database altered.
    ```
8. DB 셧다운 & Cold Backup 권장 ```SQL
    SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    ```
9. log파일 생성확인 ```SQL
    SQL> ALTER SYSTEM SWITCH LOGFILE;
    \\System altered.
    ```