[ORACLE] RAC Archive log mode 변경

1. archive log mode 확인

SQL> archive log list

Database log mode           No Archive Mode

Automatic archival           Disabled

Archive destination           /oracle/base/product/19c/dbs/arch

Oldest online log sequence     15

Current log sequence           16

 

2. cluster 중지

 

SQL> alter system set cluster_database=false scope=spfile sid='*';

 

System altered.

 

3. DB 중지

 

[oracle@rac1-:~]$srvctl stop database -d orcl

 

4. 한쪽 노드 DB mount

 

[oracle@rac1-:~]$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 15 01:43:58 2021

Version 19.10.0.0.0

 

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

SQL> startup mount

 

ORACLE instance started.

 

Total System Global Area 2399140608 bytes

Fixed Size            8899328 bytes

Variable Size          620756992 bytes

Database Buffers     1761607680 bytes

Redo Buffers            7876608 bytes

Database mounted.

 

5. archive log 경로 및 format 설정

 

SQL> alter system set log_archive_dest_1='location=+RECO' scope=spfile;

 

System altered.

 

SQL> alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;

 

System altered.

 

6. archive log mode 변경

 

SQL> alter database archivelog;

 

Database altered.

 

7. cluster 기동

 

SQL> alter system set cluster_database=true scope=spfile sid='orcl';

 

System altered.

 

8. DB 전체 기동

 

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

 

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

 

[oracle@rac1-:~]$srvctl start database -d orcl

[oracle@rac1-:~]$srvctl start service -d orcl

 

[oracle@rac1-:~]$sqlplus / as sysdba

 

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 15 01:49:23 2021

Version 19.10.0.0.0

 

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

 

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

 

9. archive log mode 변경 확인

 

SQL> archive log list

Database log mode           Archive Mode

Automatic archival           Enabled

Archive destination           +RECO

Oldest online log sequence     15

Next log sequence to archive   16

Current log sequence           16