[RAC] RAC 환경 Archive log mode 변경

테스트 환경

 

OS	linux 7.9
DB	12.2.0.1

 

RAC 환경에서 no archive mode > archive mode로 변경

 

1. RAC Instance 인지 확인

select instance_name , version, status 
from gv$instance;

INSTANCE_NAME                    VERSION                            STATUS
-------------------------------- ---------------------------------- ------------------------

RACDB1                           12.2.0.1.0                          OPEN
RACDB2                           12.2.0.1.0                          OPEN

 

2. archive mode인지 확인

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     27
Current log sequence           28

 

3. DB shutdown 

 

- shutdown 전 상태 확인

[root@ol79rac1 ~]# srvctl status database -d RACDB
Instance RACDB1 is running on node ol79rac1
Instance RACDB2 is running on node ol79rac2

 

-shutdown 후 상태 확인

[root@ol79rac1 ~]# srvctl stop database -d RACDB

[root@ol79rac1 ~]# srvctl status database -d RACDB
Instance RACDB1 is not running on node ol79rac1
Instance RACDB2 is not running on node ol79rac2

 

4. mount 상태로 기동

 

- start 전 옵션 관련되서 확인

[root@ol79rac1 ~]# srvctl start database -help

Starts the database.

Usage: srvctl start database -db <db_unique_name> [-startoption <start_options>] [-startconcurren                                                                                                                   cy <start_concurrency>] [-node <node> | -serverpool "<serverpool_list>"] [-eval] [-verbose]
    -db <db_unique_name>           Unique name for the database
    -startoption <start_options>   Options to startup command (e.g. OPEN, MOUNT, or "READ ONLY")
    -startconcurrency <start_concurrency> Number of instances to be started simultaneously (or 0                                                                                                                    for empty start_concurrency value)
    -node <node>                   Node on which to start the database (only for RAC One Node dat                                                                                                                   abases)
    -serverpool "<serverpool_list>" Comma separated list of database server pool names
    -eval                          Evaluates the effects of event without making any changes to t                                                                                                                   he system
    -verbose                       Verbose output
    -help                          Print usage

 

- mount 상태로 기동 후 상태 확인

[root@ol79rac1 ~]# srvctl start database -d RACDB -startoption mount

 

-crsctl로 확인

[root@ol79rac1 ~]# crsctl status resource ora.racdb.db -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.racdb.db
      1        ONLINE  INTERMEDIATE ol79rac1                 Mounted (Closed),HOM
                                                             E=/ora_engine/12c/db
                                                             home_1,STABLE
      2        ONLINE  INTERMEDIATE ol79rac2                 Mounted (Closed),HOM
                                                             E=/ora_engine/12c/db
                                                             home_1,STABLE
--------------------------------------------------------------------------------

 

-gv$instance로 확인

SQL> select instance_name , version, status
from gv$instance;  2

INSTANCE_NAME                    VERSION                             STATUS
-------------------------------- ---------------------------------- ------------------------
RACDB1                           12.2.0.1.0							MOUNTED
RACDB2                           12.2.0.1.0							MOUNTED

 

5. archive mode로 변경

[node 1]

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

[node 2]

SQL> alter database open;

Database altered.

 

-node2에도 archive log 변경할 경우 에러발생

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any
instance

-> 원인 : 공유스토리지를 사용하고 있기때문에 node1에만 진행해도 node2에도 모드가 변경됨

 

6. archive mode 확인

- archive mode로 변경했지만 archive log 저장 경로는 +RECO (ASM환경)임을 확인

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     27
Next log sequence to archive   28
Current log sequence           28

SQL> show parameter recovery

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ---------------------- 

db_recovery_file_dest                string                 +RECO
db_recovery_file_dest_size           big integer            4500M
recovery_parallelism                 integer                0
remote_recovery_file_dest            string
-------------------------------------------------------------------------------------
oracle@ol79rac1[+ASM1]:/home/oracle$ asmcmd
ASMCMD> ls
DATA/
MGMT/
OCR_VOTE/
RECO/

ASMCMD> cd RECO

ASMCMD> ls
RACDB/

ASMCMD> cd RACDB

ASMCMD> ls
ARCHIVELOG/
CONTROLFILE/
control02.ctl

ASMCMD> cd ARCHIVELOG
ASMCMD> ls
2023_04_07/

ASMCMD> cd 2023_04_07
ASMCMD> ls
thread_1_seq_28.257.1133533397
thread_1_seq_29.258.1133533401
thread_2_seq_18.259.1133533403