RAC 환경 아카이브 로그 전환 방법

RAC 환경 아카이브 로그 전환 방법

-- shutdown immediate all database instances

$ srvctl stop database -d <db_unique_name>

-- startup database in mount mode

$ srvctl start database -d <db_unique_name> -o mount

-- enable archive logging

$ sqlplus / as sysdba

sql> alter database archivelog;

sql> exit;

-- stop database

$ srvctl stop database -d <db_unique_name>

-- restart all database instances

$ srvctl start database -d <db_unique_name>

-- verify archiving is enabled/disabled by means of:

sql> archive log list;

출처 : How To Enable/Disable Archive Logging In RAC Environment (문서 ID 1186764.1)