oracle11g归档日志可以放在本地、共享存储或ASM磁盘,本次修改放在本地盘中
1、创建归档所需要的路径
节点1:
mkdir /arch1
chown -R oracle:oinstall /arch1
chmod -R 777 /arch1
节点2:
mkdir /arch2
chown -R oracle:oinstall /arch2
chmod -R 777 /arch2
2、备份spfile
任意节点执行create pfile='/u01/app/oracle/initdljyzs1.ora' from spfile; 来备份spfile
3、修改归档日志存放地
alter system set log_archive_dest_1='location=/arch1' scope=both sid='inst1';
alter system set log_archive_dest_1='location=/arch2' scope=both sid='inst2';
4、修改归档模式
1. The following steps need to be taken to enable archive logging in a RAC database environment:
-- 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;
alter system archive log current;或alter system switch logfile;
至于这两种切换日志的区别我博客有提到。