oracle rac开启归档

1.创建归档目录

su - grid
asmcmd
lsdg
cd fra
mkdir arch

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;

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; 切换所有节点日志