1.创建归档目录
su - grid
asmcmd
lsdg
cd fra
mkdir arch
2.修改归档路径
su - oracle sqlplus / as sysdfba alter system set log_archive_dest_1='location=+fra/arch' scope=spfile sid='prod1'; alter system set log_archive_dest_1='location=+fra/arch' scope=spfile sid='prod2'; alter system set log_archive_format='prod_%t_%s_%r.arc' scope=spfile;
3.开启归档模式
srvctl stop database -d prod -o immediate srvctl status database -d prod srvctl start instance -d prod -i prod1 -o mount 启动一个实例到mount alter database archivelog; alter database open; archive log list;
4.开启另个节点,由于控制文件在ASM共享文件中,其他的节点会读取修改后的控制文件
srvctl start instance -d prod -i prod2
crsctl stat res -t 检查集群状态
5.日志切换
alter system switch logfile; 切换当前节点日志 alter system archive log current; 切换所有节点日志