[RAC] RAC환경에서 archive log mode로 변경하기

① 양쪽 노드전부 shutdown immediate 수행

② 한쪽 노드만 마운트단계로 시작

③ alter system set log_archive_dest_1='location=/data/arc1';

④ alter system set log_archive_dest_1='location=/data/arc2';

⑤ alter database archivelog;

⑥ alter database open;

⑦ archive log list;로 결과 확인 후 나머지 한쪽 노드에서 2,3,4번 수행

step 1. 각 노드에 접속에서 shutdown immediate 종료

--node 1
SQL> select instance_name from v$instance;
    INSTANCE_NAME
    ----------------
    rac1

SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

--node 2
SQL> select instance_name from v$instance;
    INSTANCE_NAME
    ----------------
    rac2

SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

step 2. 한쪽 노드만 mount 단계로 시작 (rac1으로 작업)

SQL> startup mount;
    ORACLE instance started.

    Total System Global Area  285212672 bytes
    Fixed Size                  1267068 bytes
    Variable Size              92277380 bytes
    Database Buffers          188743680 bytes
    Redo Buffers                2924544 bytes
    Database mounted.

SQL> archive log list;
    Database log mode           No Archive Mode
    Automatic archival             Enabled
    Archive destination            /data/arc2
    Oldest online log sequence     16
    Next log sequence to archive   17
    Current log sequence           17

SQL> show parameter spfile;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ----------- 
    spfile                               string      /dev/raw/raw23

step 3. archive log file을 저장할 경로 생성 및 지정

SQL> !mkdir /data
SQL> !chown -R oracle.dba /data

SQL> alter system set log_archive_dest_1='location=/data/arc1';
    System altered.

SQL> alter system set log_archive_dest_1='location=/data/arc2';
    System altered.

step 4. archive log mode로 변경 후 DB open

SQL> alter database archivelog;
    Database altered.

SQL> archive log list;
    Database log mode              Archive Mode
    Automatic archival             Enabled
    Archive destination            /data/arc2
    Oldest online log sequence     16
    Next log sequence to archive   17
    Current log sequence           17

SQL> alter database open;
    Database altered.

step 5. 나머지 노드(arc2)에서 2,3단계 수행

SQL> !mkdir /data
SQL> !chown -R oracle.dba /data

SQL> alter system set log_archive_dest_1='location=/data/arc1';
    System altered.

SQL> alter system set log_archive_dest_1='location=/data/arc2';
    System altered.

SQL> alter database open;
    Database altered.